access question

[slip]

in a access database that has alot of people loging in to it and geting data will it be a problem to just access the data directly or should I use datasets and update the database with the oledb adapter?

[HJB417]

if the data is mostly static, and the application containg the datasets is long lived, use datasets.

[slip]

am I correct in saying that access will only allow one open connection at a time?

[FZelle]

You are not working with MS-Access.

You are just working with a file in the DB-Format MS-Access is useing.

You are useing the JET-Driver via the OleDb-Provider.

 

And this is able to handle multiple accesses to that file.

[bri189a]

The driver will allow 10 connections, but I've heard it get's flakey after 5, that's by word of mouth (the flakey connection part, not that it maxes at 10), haven't seen documentation on it or seen it myself.