Multi User Access (1 Viewer)

[tlc1974]

I have created a combo box which will open another form based on the criteria selected in the combo box. I have multiple users wanting to access this form but when the 2nd user opens the form a combo box error appears. I am assuming this is because the other user has opened the same form the first user has opened and changed the criteria in the combo box. How can I avoid this?

 

[theDBguy]

Hi. Is your database properly split? Each user should have their own copy of the front end.

 

[tlc1974]

No it is just one database that they all access.

 

[theDBguy]

No it is just one database that they all access.

That's not good. Have a read at this article on how to properly share a database.

 

[tlc1974]

Thank you and I will split the database. With the database always being upgraded what is the easiest way to update on each pc with them all having their own front end?

 

[NauticalGent]

Thank you and I will split the database. With the database always being upgraded what is the easiest way to update on each pc with them all having their own front end?

Now there's a question!

If you have complete control over your network and can anything you want to it, there are a few utilities out there to do just that, FMS is a good one.

If you want to do it with Access, search through the Sample Databases on this site. Some of our members have provided some great examples.

I myself use a VB Script that installs, creates a desk-top icon and check for updates every time a user accesses the application. More than willing to share that with you if you choose to go that route.

 

[tlc1974]

John I think I would like to use a vbscript so it is automated please can you share your version? Thank you!

 

[NauticalGent]

Easy day. The code belongs to Bill Mosca (WrMosca) so please be sure to give him his due. The thread where it can be found is below with his comments to another user who was having issues with it.

https://www.access-programmers.co.uk/forums/showthread.php?t=207187&highlight=Mosca

If you get stuck, post back here and we will get you sorted out...