This DB needs to open to just one user at a time

[Bonnie A]

Hi everyone! Happy 2009! Using A02 on XP. My DB files are all multi-user
with user level security. This new one needs to be used by just one person
at a time. Is there a simple way to have the file either open exclusively or
open to a main form that will tell them it is currently in use?

Thanks bunches in advance for your time!

 

[John W. Vinson]

Hi everyone! Happy 2009! Using A02 on XP. My DB files are all multi-user
with user level security. This new one needs to be used by just one person
at a time. Is there a simple way to have the file either open exclusively or
open to a main form that will tell them it is currently in use?

Thanks bunches in advance for your time!

Tools... Options... Advanced; check Exclusive in "Default open mode".

 

[Arvin Meyer [MVP]]

Simplicity, like beauty is in the eye of the beholder. For me it's a couple
hours to write and debug code, for you it could be longer depending upon
your skills. Yes, it is simple. It can be very simple if you set everyone's
default open to Exclusive:

Tools >>> Options >>> Advanced >>> Default open mode >>> Exclusive

That opens all databases in Exclusive mode, so you may want something more
sophisticated.

 

[Clifford Bass]

Hi Bonnie,

Create a shortcut for everyone that has this as the Target:

"c:\program files\microsoft office\office10\msaccess.exe" /excl "c:\My
Folder\My Database.mdb"

Of course this won't prevent someone from opening it in shared mode it
directly while in Access.

Or on opening, it could check the lock file to see if anyone else is in
it. I have not done this, but a place to start for that information is
<http://www.mvps.org/access/general/gen0034.htm>.

Hope that helps,

Clifford Bass

 

[a a r o n . k e m p f]

Jet was not designed from the ground up-- as a multi-user database.

if anyone wants to use MS Access with multiple users, it is in your
best interests to upsize to SQL Server

 

[Larry Linson]

Jet was not designed from the ground up -- as a multi-user database.

That is a misrepresentation of fact. Microsoft Access with the default Jet
database engine is multi-user right out of the box, and has been since its
earliest days.

 

[a a r o n . k e m p f]

wow dude, you're not very well educated are you?

do you not remember what I've quoted previously??

maybe if you weren't delusional- then maybe, just maybe-- your opinion
would be worth something

 

[a a r o n . k e m p f]

in other words-- if you're having trouble with Jet-- which was never
designed to support multiple users-- then you should move to a real
database like SQL Server.

Only with SQL Server could you possibly set something like this so
that it woudl _NEVER_ be a hassle for you and your users
Only with SQL Server could you possibly set something like this so
that it woudl _NEVER_ be a hassle for you and your users
Only with SQL Server could you possibly set something like this so
that it woudl _NEVER_ be a hassle for you and your users
Only with SQL Server could you possibly set something like this so
that it woudl _NEVER_ be a hassle for you and your users

 

[a a r o n . k e m p f]

there is no such thing as a multi-user Jet database.

Move to SQL Server, if you know what's best for your
a) career
b) data
c) security
d) users

So if you give a shit about any of those 4 items-- then move to SQL
Server

 

[BruceM]

Your ability to copy and paste is unquestionable, as you have demonstrated
over and over in this forum, but don't expect that anybody pays much
attention.
Do you think attacking another poster is going to gain you credibility? If
so, it is clear where the "delusional" label needs to be applied.

message
wow dude, you're not very well educated are you?

do you not remember what I've quoted previously??

maybe if you weren't delusional- then maybe, just maybe-- your opinion
would be worth something

 

[a a r o n . k e m p f]

Bruce;

Look back to IIS 3.0 documentation and it is written clear as a bell
that 'Jet was never designed to be multi-user database'
I've seen it in a dozen places since then.

But it just re-affirms-- since jet crashes _ALL_ the time-- that it's
not ready for business (or professional developer) usage.

Only halfwits use Jet for pint-sized databases.
If your db is successful _THEN_ you need to upsize.. ROFL

what a joke

'build it nice or build it twice'

-Aaron