Multiple users access at the same time

[Guest]

I have a database mainly for generating reports. How do I allow multiple
users to run reports at the same time?

 

[Guest]

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.

 

[Joseph Meehan]

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.

Access by nature is shared. From your description it sounds like it
happens when someone opens it exclusively. That locks out all other users.
I believe it can also happen if you try to open it exclusively when someone
else is already on it. Normally the error message will say something about
the exclusive issue.

When more than one user is going to be accessing Access at the same time
it is best to use a "Split" version. You split the database (use the
wizard) and it will make two different files. One called the back end
contains the tables and the other contains the reports, queries forms etc.
Each user gets a copy of the front end on their own machine and links from
there to the back end on the server. Each user can even have their own
customized forms and reports.

The splitting speeds up the process and eliminates some issues.

 

[Guest]

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?

 

[Guest]

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?

 

[Joseph Meehan]

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?

Sorry about the delay. I lost this and a couple of other threads a
while back .

LDB is an Access "Locking Database File" It keeps track of who is in
the database, their rights and how to lock data in the file when more than
one user may be viewing and editing the data on the same page at the same
time. It is normal and it should delete itself when the last user logs out.
It can be a problem if someone just shuts down their machine without exiting
Access first. In that situation someone has to manually delete the file
after everyone is out of Access. Note: All users need operating system
rights to make, delete and modify files in the directory where the back end
file and the LDB files are located.