multiple simultainious users in access 2003

  • Thread starter Thread starter dennisfed
  • Start date Start date
D

dennisfed

i have a database created in 03. it will not allow more than one user at a
time.
it defaults to no lock. everyone has read/write permissions on the network
drive and path in question. i have bound forms and i am not using the recset
method, i am using the default read/write ie: if me.dirty ........ what do i
have to do to allow concurent users.
dennis
 
i have a database created in 03. it will not allow more than one user at a
time.
it defaults to no lock. everyone has read/write permissions on the network
drive and path in question. i have bound forms and i am not using the recset
method, i am using the default read/write ie: if me.dirty ........ what do i
have to do to allow concurent users.
dennis
Click to expand...

You really need to split your application into a shared "backend", containing
the tables, and a "frontend" with links to the tables, forms, reports, queries
etc. Each user should have their OWN copy of the frontend. Tools... Database
Utilities... Database Splitter Wizard will set this up for you. See
http://www.granite.ab.ca/access/splitapp.htm for details and rationale.
 
Back
Top