Access DB synchronisation over network

[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

 

[Douglas J. Steele]

Access should be able to handle it.

 

[David W. Fenton]

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.

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.