How to creat or modify the form while other user is using access

[question]

Hi,
the database which is put on a central server is using Access 2003 with access to it on many workstations. all the forms and tables are in the server database. Right now I have a problem to modify or create a new form when other user are using this database. Every time when I try to create or modify a form, it says "I do not have exclusive access to the database at this time". Is there any way I can use to let me at least can create a new form while other user are using the database in the server.

thanks

 

[Rick B]

If you have multiple users sharing a database, you should split the
database. The back-end (stored on the server) would contain the tables and
the data. The front-end would contain your forms, queries, and reports.
Each user would have a copy on their own hardrive and would run it from
there. To make changes, you'd update your personal copy and then place it
in a location where your users can get a new copy. There are several ways
to automate this process.

In short, you need to split your database.

Rick B


Hi,
the database which is put on a central server is using Access 2003 with
access to it on many workstations. all the forms and tables are in the
server database. Right now I have a problem to modify or create a new form
when other user are using this database. Every time when I try to create or
modify a form, it says "I do not have exclusive access to the database at
this time". Is there any way I can use to let me at least can create a new
form while other user are using the database in the server.

thanks

 

[Ernie]

-----Original Message-----
If you have multiple users sharing a database, you should split the
database. The back-end (stored on the server) would contain the tables and
the data. The front-end would contain your forms, queries, and reports.
Each user would have a copy on their own hardrive and would run it from
there. To make changes, you'd update your personal copy and then place it
in a location where your users can get a new copy. There are several ways
to automate this process.

In short, you need to split your database.

Rick B

As Rick stated above, you should split your database.

However there is a short-term approach which is workable.
Make a copy of the database, create and test your report
in the copy, then import it into the live database. You
may still need exclusive access to the live db but only
for a couple of minutes compared to the time it can take
to design a report.