Multi user

[vilmarie]

How I make that my database could be multi user?

 

[EPT]

Kind of a cryptic question but??
I would split the database into a front end (FE) which would contain your forms, reports, modules, etc., and a back end (BE) which would contain your tables. You can do this easily with the database splitter wizard. I would put the BE on a network drive and and copy the FE onto your users PCs. Use the Linked Table Manager to make sure that your users are pointing to the correct network drive where the BE is located. Also, make sure your users have the appropriate permissions on the network drive, read/write. Finally, make sure you are opening the database in Shared Mode, check this under Tools--->Options Advanced tab. That should get you started. REMEMBER to backup your database before you do anything.

 

[vilmarie]

If I realize this steps all the users that access this application could be saved all the information that make in the form?

 

[EPT]

I'm not really sure what you are asking but multiple users could be accessing the database at the same time and the data will be saved. However, multiple users can not access the same record at on time.

 

[psemianonymous]

Actually, they can--Access pops up a confusing messagebox that no one seems to understand--but it does allow two users to edit the same record. vilmarie, you should try and test out Access' multiuser capabilities. Here's how:

1. Open up your database.
2. Go to the desktop, open up a new Access window, open up your database AGAIN.


Now go into the first window and change a record. Now go into the second window and look at that record. You are now 'simulating' multiuser Access. There are some differences when you put it on a LAN file server, but often there are no new problems. So just test out the multiuser capabilities yourself.