Shared database

[Joran]

Hello,

I have a database on a server, containing the tables, and i have a database with the query's/forms/etc. local on the workstations. The last database has linked tables to the one on the server.

The problem i encountered is that if somebody is using the database, other persons cannot read data from the shared database. The message is that the database is allready in use.

The shared database is only for looking up data.

what is wrong?
what is the solution?


Thanks in advance,

Joran

 

[Frink]

Hallo,

You have to make sure that each user opens their front end to the database for shared access (i.e. not Exclusive)

If a user cannot access the database, use Net Watcher to see who is on exclusively and ask them to change their options to open databases for shared access by default.

- Frink