O I should add it is currently in a shared network file and all users can use
it just not at the same time. IF someone is useing the database it gives an
error message to the other user that trys to access it.
Would me linking tables to an excel file verus created tables in access be
the problem?
I think what is happening is when a user opens the database it is making
them the Admin of the database by deflaut which is creating the exculisive
use. If I create user groups and do away with the genaric admin group -----
wouldn't that help as well?
OK I tried spliting the database. The error message I get is "error
exicuting command" When a users brings up the switchboard and selectes the
report to run. I also noticed that an accesslock.ldb file is created when
someone is in the database. What am I doing wrong?