|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
user enviroment needed?here's my problem, I've created a database to track students progresses, staff access it and enter the grades applicable, problem lies when i need to edit something like a report and a member of staff already has it open, it will say "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later." how do i avoid that, is there a way to kick them off? or something similar. Thanks Daniel. -- Daniel Ellero ICT Technician Caister High School www.green-pastures.net www.tabyouthgroup.co.uk Message posted via http://www.accessmonster.com
Show quote
Hide quote
"dellero" <u16214@uwe> wrote in message news:6a66187fa1c32@uwe... Hi Daniel.> Hi, > > here's my problem, > > I've created a database to track students progresses, staff access it and > enter the grades applicable, problem lies when i need to edit something > like > a report and a member of staff already has it open, it will say "You do > not > have exclusive access to the database at this time. If you proceed to make > changes, you may not be able to save them later." how do i avoid that, is > there a way to kick them off? or something similar. > Access is, by definition, a multi-user application. It sounds like you're trying to use your development file as your production file at the same time. What I would advise would be to split the database into front and back ends and to give each user their own copy of the FE, that way you're free to work on the report design and your users are free to run them. There's some info on splitting apps here: www.jmwild.com/SplitSecure.htm HTH - Keith. www.keithwilby.com ok that sounds ok, just let me clarify, the staff currently access the
database from a Shared area on the network. All staff can access the same file at the same time and enter their own data, that's fine it's just when i try and change a report is when the error occurs, would this front/backend thing still help me? -- Daniel Ellero ICT Technician Caister High School www.green-pastures.net www.tabyouthgroup.co.uk Message posted via http://www.accessmonster.com "dellero via AccessMonster.com" <u16214@uwe> wrote in message news:6a68c5ccfb88d@uwe...> ok that sounds ok, just let me clarify, the staff currently access the Yes it would and most developers will recommend that you split as a matter > database from a Shared area on the network. All staff can access the same > file at the same time and enter their own data, that's fine it's just when > i > try and change a report is when the error occurs, would this front/backend > thing still help me? > of urgency since the single file scenario is a recipe for file corruption, even more so if you're trying to do development work on the same file. There's more info here: http://allenbrowne.com/ser-01.html Regards, Keith. www.keithwilby.com Thanks, i'll post here once i've tested this out.
-- Daniel Ellero ICT Technician Caister High School www.green-pastures.net www.tabyouthgroup.co.uk Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200612/1 
Other interesting topics
Access 2003 security warnings
Inner Joins Problem switching between Workgroups Warehouse personnel can't get the needed form - just the backgroun Opening a previously secured database restrict combo box selection depending on user how to change a name in "msysaccounts"? Access security question Programically redirecting to different mdw files Problem opening an Access file from my computer |
|||||||||||||||||||||||
