I have a DB an a shared drive. Currently if one user at their computer is using DB no other users can open DB. How do I set it so that multiple users can have DB open at same time?
I have a DB an a shared drive. Currently if one user at their computer is using DB no other users can open DB. How do I set it so that multiple users can have DB open at same time?
Unless I misunderstand, it sounds like they're opening the database using the .accdb file rather than using a link to the form they need (I presume you have created a form for them to use). If so, drag and drop the form from the list in the navigation panel to the shared drive. Have them click on that icon instead of the accdb icon.
Is your database split into a front end (FE) and a back end (BE)? The BE holds only the tables. The FE holds everything else.... queries, forms, reports and modules. The BE is on the server. The FE is linked (the tables) to the BE.
Each user should have a *copy* of the FE .accdb on their workstation.
No one should be opening (running) the .accdb while it is on the server.
See
http://allenbrowne.com/ser-01.html
ssanfu,
The only problem with having a FE on each user's workstation is when it comes time to update code. If you have multiple applications, this becomes a big pain to update code for one specific application on everyone's workstation (I'm updating code in about 5-6 different applications on a daily basis).
I personally prefer to use this vb script:
https://www.accessforums.net/code-re...sier-7572.html
This vb script has made my work 100 times easier.
I totally agree, pkstormy. I am manually (client's request) updating 3 FEs for 3 people, sometimes a couple of times a day.
I sounded to me that the OP doesn't have a split database. So I was trying find out and gave an example of what a split database is - with a link to why the split db is more desirable for a multiuser db. Not to mention the corruption issue.......
I scanned the above link.. (and will download for later study). But the OP will still need to split the dB....if it already isn't....I personally prefer to use this vb script:
https://www.accessforums.net/code-rep...sier-7572.html
BTW, thanks fir the link.