Multiuser database issues - VB & Access

Hello.
I need to allow multiple users to get into the same Access database at the
same time accross a network.
The system will be importing and exporting data in the background as 4 or 5
users work with it.

What issues do I need to consider?
How and when do I use Table locking in ADO?

Any help on the matter much appreciated.

Ray.

"Ray" <news@quitealright.com> wrote in message <news:SyN_b.4526$rb.61884@news.indigo.ie>...

> I need to allow multiple users to get into the same Access database at the
> same time accross a network.
> The system will be importing and exporting data in the background as 4 or 5
> users work with it.
>
> What issues do I need to consider?

"Developing Multi-User Microsoft Access Database Applications" from
the July 2000 section should still be applicable, about 2/3 of the
way down:

URL:http://members.tripod.com/appdevissues/downloads.htm

> How and when do I use Table locking in ADO?

In multiuser situations, you probably don't want to lock whole tables.
"Optimistic" locking is your best bet to avoid most locking problems.

--
Joe Foster <mailto:jlfoster%40znet.com> "Regged" again? <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!

Multiuser database issues - VB & Access - basic.visual