Access DB synchronisation over network

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

Access should be able to handle it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Enda Mannion" wrote in message
...
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

=?Utf-8?B?RW5kYSBNYW5uaW9u?=
wrote in :

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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/