About 2 users in Access Database

[technotips]

hi guys,
i have a question, can 2 users work on a database at the sametime if we develop in MS ACESS, if so do we need to do anything extra, i want to design a database and want to know if 2 users can work on the database at the same time, thank you for the info,

 

[Geekmomz]

If you mean can two users enter data into the database at the same time, the answer is yes. However, there are particular steps that you can take to reduce the possibility of conflcts occurring, such as storing your tables (data) in a back end database and linking to them from a front-end database containing your forms, queries, reports, modules, and/or macros. The Access groups here are a great place to get help in the process as well.

 

[Transcend]

If you don't want your database to lock up while one user is using it, make sure you don't open it exclusively.

This procedure affects the way a Microsoft Access database is opened only on your computer. It does not affect the default for users on other computers.

On the Tools menu, click Options.

Click the Advanced tab.

If you want others to be able to open the Access database at the same time you have it open, click Shared.
If you want sole access to the Access database when you have it open, click Exclusive.

Transcend

 

[technotips]

thank you for the info,
on emore doubt, actually like i said in my project 2 people on the network will access the file at the same time, and i am gonna use forms and queries, tables, macros, etc, but i want to know if both of them will be able to work on the database at the time, for example, if they have form which check/updates some fields in the tables, will the both users be able to use it at the same for updateing/generating reports etc, thank you again

 

[Newposter]

As long as they don't try to edit the same record in a table, or edit the same form at the same time, yes, they can work on different objects and save each. Newposter
"Good judgment comes from experience. Experience comes from bad judgment."

 

[Geekmomz]

Just in case it's not clear, Newposter is referring to two users editing the design of the form at the same time. There is no problem with two users entering or editing data using the same form at the same time, as long as they are not editing the same record. Additionally, if one user simply needs to look up information, not add or edit, s/he can use a form that you have designed to open in read-only mode and can view records than another user is editing without causing a conflict.

 

[annsolomon]

Just one more thought. You'll have less trouble with users tripping over one another if you split the database. Put your back end (tables only) database on the server and put a copy of the front end (queries, forms, reports, etc.) on each user's PC.

Ann

 

[KenReay]

Hi

There is a databse splitter wizard.... Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[annsolomon]

Sorry, but it seems my email notification isn't working.

The database splitter wizard that Ken's talking about can be found at Tools, Database Utilities.

Or, if you like to do things the long way, you could do it manually by copying the database then removing tables from the one database and queries, forms, etc from the other database. If you do it this way, you'll need to link the tables to the front end database by going to File, Get External Data, Link Tables.

Ann