Access Database

S

Scott

Quick question anyone know how to make a Access database multi user with out
splitting it. I know about usging A SQL server, but my boss seems to think
that you can make it multi user with just access and without spliting in and
I have never done it that way.
 
J

John Vinson

Quick question anyone know how to make a Access database multi user with out
splitting it. I know about usging A SQL server, but my boss seems to think
that you can make it multi user with just access and without spliting in and
I have never done it that way.
Click to expand...

Access is multiuser by default. You don't need to do ANYTHING to it to
make it so.

That doesn't mean it's a good idea. A single database shared by
multiple users will bloat faster, be more susceptible to corruption,
perform poorly, and general be a major pain in the neck. Your boss's
opposition to splitting is misguided; multiuser databases are better
split than not.

John W. Vinson[MVP]
 
S

Scott

I was not aware that two users could access the same database at the same
time unless it was split. I have never did a database without splitting it.
Just make much more sense to me. Thanks for the post.
 
Top