sharing access database

[Guest]

I have the database shared in the network drive. The first person double
click the file icon can open it. But a second person who does the same action
cannot open it. However, the second person still can open the file by
opening the Access program and using the file open to open it. Could anyone
tell me why the second person cannot just double click to open. Is there any
solution?

 

[Douglas J Steele]

The only thing I can think of is that the default file association for MDBs
has somehow been set up incorrectly.

However, you shouldn't have multiple users opening the same database anyhow.
Shared applications should be split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relations). Only the back-end should be on the
server: each user should have his/her own copy of the front-end, ideally on
their hard drive.

Tony Toews has a bunch of information about this at
http://www.granite.ab.ca/access/splitapp/index.htm, and has a free utility
that will ensure that each user always has the most up-to-date version of
the front-end at http://www.granite.ab.ca/access/autofe.htm

 

[Guest]

Yim...

What Doug is saying is correct. The Default way Access works is with
what they call the JET Data Access engine (depending on your settings), but
no matter what engine you're using to access it's database, once one user
opens a database, by DEFAULT it locks the database from other use, if you're
directly in the application it's self.

There are many preset scripts out there for front-end, back-end database
manipulation.