hi everybody!
i have a question
can i access an access database that is not on my computer (in a network) and can do it with more than 1 computers in the same time (like sql server)?
thanx , zolko

Hello. Yes, you can, but the performances won't be optimal, as MSAccess is not the best for multiuser usage. You only have to specify the network path of the .mdb within your connection string. And of course, you got to manage of all the multiuser topics, like locks, permissions and so on.
Hope it helps.

____________________________
Real Programmer can count up to 1024 on his fingers

From experience at a company once, anytime there were more than 5 people using the access database, it ended up corrupt (and had to be repaired).  Problem there was, there were always over 5 users accessing it, and it "went down" almost daily.

But it can be done.


____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

Hi,

Desktop databases(Access database) perform all the the database tasks on the client side.

For example, if an Access user requests a customers list from the table, the entire index comes across the network and the search and retrieval takes place within the client process.

Multiuser desktop databases tend to make heavy demands on the network.

Desktop databases try to optimize the operation by opening only a portion of the database file. If multiple clients are working with the dtabase, portions of the database files are constantly flying across the network.

In a Client/Server database (Sql server) , all the database work is performed with in the dtabase server. If the client requets a database, the dataset is prepared within the server and copy of the data is sent to the client. The actual data and indexes never leave the server.

Database programming using Visual Basic 2005