Access DB synchronisation over network

  • Thread starter Thread starter Enda Mannion
  • Start date Start date
E

Enda Mannion

Hi,

I want to share an access mdb file on a network share and access it over the
lan using say ADO.net in a c# win forms client. If multiple clients write
to the same table at the same time can access handle this or is there some
way I can set up a locking mechanism. Or should I look at a different DB
than access as my server db.

Thanks,
Enda
 
I want to share an access mdb file on a network share and access
it over the lan using say ADO.net in a c# win forms client. If
multiple clients write to the same table at the same time can
access handle this or is there some way I can set up a locking
mechanism. Or should I look at a different DB than access as my
server db.
Click to expand...

The Jet/ACE database engine handles multiple users by default.

"Access" is not a database -- it's a platform for building an
application for editing data in a database.

The default database engine in Access is Jet/ACE and that's most
likely what you mean. Jet/ACE is not a server database, so if you
actually need a server database, then you've chosen the wrong tool.
 
Back
Top