Multiple users access at same time

  • Thread starter Thread starter bjclaywell
  • Start date Start date
B

bjclaywell

Hi - again. :) In my database, I will need to be able to
have several people adding info at once. If my
switchboard opens the forms in "add" mode, can several
users be in at the same time? If not, how can I manage
this?

TIA - BJ
 
Yes since each user use a *copy of the Form* on his/her
desktop.

However, for a multi-user database application, you should
(must, really) split the database into Front-End and Back-
End. The Back-End contains only Tables and resides on a
shared directory. The Front-End contains all other Access
objects and each user should have a copy of the Front-End
on his/her PC.

See Access Help on splitting a database.

HTH
Van T. Dinh
MVP (Access)
 
bjclaywell said:
Hi - again. :) In my database, I will need to be able to
have several people adding info at once. If my
switchboard opens the forms in "add" mode, can several
users be in at the same time? If not, how can I manage
this?

TIA - BJ
Click to expand...


As Van said, you split the database. It works great.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switchboard Manager - Multi Users 12
Same record/Primary key in multiple tables 0
Multiple access at the same time? 3
Modifying a DB from multiple systems at the same time? 3
Multiple users access at the same time 5
Users accessing same table 4
Multiple Users of an Access Database 2
Switchboard not access latest form 1

Back
Top