Read Only Error

  • Thread starter Thread starter Tamer Seoud
  • Start date Start date
T

Tamer Seoud

I've just finished developing a database in Access 2000.
So far only me and another person can access it. Sometimes
I receive the following error message when attempting to
open the database: "Database is read only".

Why am I getting this error message? Is it because the
other person has it opened? In the near future around 14
people will need to access this database, how to make it a
multi-user database?
 
You need to split your database into two databases. The back-end contains
only your main tables and resides on a server type machine such as NT4, W2K
Server, or Win 2003 Server. You can't use XP pro or Win 2K Pro, both of
these only allow 10 users.

The front-end database contains the linked tables from the backend, queries,
forms, reports, etc. and resides on each user's machine. When you place the
front-end on each user's machine, you will need to link the tables, so make
sure you have the Advanced wizards installed so that you can use 'Link Table
Manager' to link the files. Otherwise, you will need to code in the ability
to link the tables using an interface that the users can invoke. To make
linking even easier, set all users up with the same mapping to the server
such as E:\name of back-end database.

In addition to splitting your database to truly make the db multi-user, it
also allows you to make all the changes with the front-end you want without
interfering with the daily operations. Once you have finished modifications
to the front-end, you just have to over write the other front-end with the
new front-end.
 
Thanks a lot for your sufficient answer.
I have two questions; is splitting the database into a
back-end and a front-end is the same like using a run-time
version of the application?
Are there any articles I can read about splitting the
database and about applying security features?
 
Back
Top