Update database multiple users

[jump25a]

Can multiple users update the same database at the same time?

 

[Joe4]

Sure. You can also set different level of record locking also.

However, if you are going to have multiple users updating the same database simultaneously, it is recommended that you split the database into a back-end and front-end. The back-end contains all the data, and the front-end contains all the forms, queries, and reports. Each user would have their own copy of the front-end.

If you look in Access' built-in help files, it will tell you how you can split a database.

 

[Olyn]

After splitting the database is there a way to automatically update the front ends when you make a change to a form, report, etc...

 

[Joe4]

You want to keep one master copy of the front-end. Then when you make a change to it, you can re-distribute it to your user group.

I automate this task by having my users click a shortcut to a batch file rather than on the front-end database directly. My shortcut checks for the lastest front-end, copies it over to their workstation, then opens it.

 

[Joe4]

Here is a link to a thread where I posted what my batch file code looks like: http://www.mrexcel.com/forum/showpost.php?p=1843554&postcount=5

 

[Olyn]

How do I go about creating a batch file?

 

[Joe4]

Create a file using any Text Editor (i.e. NotePad).
Type in the code like I referenced in my previous link.
Save with a ".bat" extension. Then it will run automatically when double-clicked on.