MS Access and Multiple Users of a Database 1

[MChancellor]

I was wondering if there is a particular way to go about making a database that is stored on a network drive available to multiple users at a time. At present, only one person can get into the database at a time. Is this a licensing issue? or is there some way to code it to make it work? <br>
<br>
Thanks in advance,<br>
M. Chancellor

 

[DougP]

by default everyone can open the database<br>
Take a look at the settings in the tools menu<br>
click Tools, Options<br>
click Advanced TAB<br>
make sure Shared is checked not Exclusive.<br>
<br>
After you get several people in it OK<br>
Make the database a .MDE<br>
click Tools menu<br>
Database Utilities<br>
Make .MDE<br>
the users will use this new file<br>
There is previous post about this in more detail.

 

[MChancellor]

Does MS Access for Win 95 use MDE files? I can't find anything on it in the help file .. and there isn't a &quot;Save as&quot; for MDE ... only MDA and MDB. <br>
<br>
Thanks,<br>
M. Chancellor

 

[elizabeth]

It's not necessary to make an .mde, but since it compiles the programming code it may be faster and less error-prone. If you do make your file an .mde, be sure to save the copy of the original .mdb, because you can't make changes to an .mde. You have to make the changes to the original .mdb and then make a new .mde from that. <br>
<br>
Sometimes Access defaults to &quot;open exclusive&quot; as an open method when it is first installed. Once a db is opened exclusively, it continues to open in that mode every time, until fixed by the The Tools/Options/Advanced/Shared method DougP gives above.

 

[DougP]

do you mean Access '95<br>
Windows '95 does not matter<br>
Open your Access click Help<br>
click About<br>
it will tell you which version it is<br>
If you have the Access '95 version <br>
It would be best to upgrade it<br>
the upgrade as $99.00 or so for Access 2000<br>
Access '97 is no longer available.

 

[DougP]

PS I'm not sure if Access '95 has MDE I don't think it does but it's been so long ago.

 

[MChancellor]

I asked my boss if we could possibly upgrade (I just started here in November) but he said that we have to wait until the LAN unit does a global upgrade. Guess that's what happens when you work for a state dept. <br>
<br>
And, no, I don't think that Access 7.0 has .MDE's ... thanks for the help though. I really appreciate it. And I'll for sure be pushing for an upgrade here ASAP.. <br>
<br>
M.Chancellor