user enviroment needed?

  • Thread starter Thread starter dellero
  • Start date Start date
D

dellero

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.

Thanks

Daniel.

--
Daniel Ellero
ICT Technician
Caister High School

www.green-pastures.net www.tabyouthgroup.co.uk
 
dellero said:
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.
Click to expand...

Hi Daniel.

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
 
dellero via AccessMonster.com said:
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?
Click to expand...

Yes it would and most developers will recommend that you split as a matter
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
 
Back
Top