TABLE LINK

[Rahim]

I have access file(file1) with many tables and queries. These tables are
linked to another access file(file2) with queries.
Now the problem is , The file1 is opened by one user 1 and file2 is opened
by another user2. both are trying to enquire some item in the table throgh
quiery. but, user2; who is using file2(linked to file1) getting meesaage that
the "FILE IS ALREADY IN USE"

Can u pls. give me the solution

 

[Dale Fye]

If your data is in file2, then don't allow anyone to open that file directly.

In a multi-use environment, it is a "best practice" to never give your users
direct access to the file that contains your raw data. You should put that
file (we call this the backend or BE) on a network server somewhere, and then
give your users individual copies of your application (we call this the
frontend or FE) which should be installed on their computers. The
application (FE) should link tables from the BE, and that is how you control
access to the data.

 

[Rahim]

i did as u have suggested, (BE) file i put in the server and local file is
linked to the (BE) from user end. but still, when 2 users tried to search
record, one user getting message that "file already in use". if one user
opened local file(FE) form 1 PC, and other user is trying to open his FE, he
is getting is message that "file already in use".All the users have already
permission to access the server.

Pls. help....

 

[Dale Fye]

What version of Access are you using?

Check all of the files (you don't indicate what version you are using) and
make sure that the default open mode is set to Shared.

Don't remember how to do this in 2003 (might check the help screen), but in
2007, you click on the Windows button in the upper left corner, then click
the Access Options button. On the Access options dialog box, select
Advanced, then scroll down to the Advanced section and click on Shared
instead of Exclusive.

 

[Rahim]

its 2003, i have checked file opend mode is shared. stll same....any solution