MS access 2003 question

[Guest]

We have a user creates a MS access database. I am not familiar with with
Microsoft access so I wonder whether MS access is a single user database
application (s someone told me) ---only one user can modify it at one time?

The database we called A report. Some user can access without any problem
but some can only open the first part of database then when you click the
some name of database, it is doing nothing? We just cannot figure out what is
the problem even with all office SP update?


Please help.

 

[Joseph Meehan]

We have a user creates a MS access database. I am not familiar with
with Microsoft access so I wonder whether MS access is a single user
database application (s someone told me) ---only one user can modify
it at one time?

The database we called A report. Some user can access without any
problem but some can only open the first part of database then when
you click the some name of database, it is doing nothing? We just
cannot figure out what is the problem even with all office SP update?


Please help.

Access is designed to be multi-user. I think something like a max of
200 users at one time, but in reality 20-50 is a logical limit.

I don't know what is causing your problems, but it does not sound like a
multi user issue.

I do have a few suggestions.

First the database should be split. There is a wizard under Tools
Database Utilities. This will create two databases. The Back end will have
the tables and will stay where it is at. The Front ends will have all the
reports forms etc. You copy that one to each user's machine. No one should
access the back end directly except for maintenance.

Second make sure every user has full access to the directory where the
back end resides. That means full access to create, edit, read and delete
files.

Check to see that the default action when opening a database is not set
to exclusive on any of the user's machines.

You can also try doing a compact and repair, but I suspect that
splitting the database will not only clear up your problem, but will give
better access.