Hi,
I'm new to db programming and need some advice...

I have a windows application that I want to be running on several networked computers and accessing the same db (ms access file). I'm worried that there may be times when two user will access the db file at the same time and give an connection open error. I've played around a little bit and have noticed that using the DataAdapter to Fill and Update does not give any connection open errors (even if the connection is open by mistake or if another Fill is happening).

So what's the best plan...
If I have a situation of multiple users of a db, should I try and use the DataAdapter as much as possible to avoid db open errors?

Thanks for any advice you can give,
Ron

If you haven't had any problems yet with the method you are using I'd suggest you stick with that.

The data adapter method is probably safer because it will provide disconnected data such that you'll execute bulk data retrieval then disconnect. This should minimize problems.

-Peter

The Database connection will be open only when you need to use DataAdapter to fill or to run DataCommand.
Besides those, the database is operated in DataSet which is just a temp database and later will be updated with the Server Database