Sharing Ms Access

V

virlinz

Hi
I have a winform application with Ms Access as its database. It is a
single user application. Now there are more than one PC having the same
application installed in it, therefore I need to share this database so
that all the updates made to the database are available to all users.
I've read about replica but I think it is inconvenient to synchronize
each time updates are made. I was thinking to store this database in a
PC and let others PCs have access to it, something like what SQL Server
can do. Is this possible for Access? Can someone suggest what is the
best approach to tackle this problem. I thank you in advance for your
help
 
T

Tom Wickerath

Are all of your users on a local area network (LAN)? If so, then you don't
need replication. You just need to split the database. Access, by itself, is
not really suitable for a wide area network (WAN). See MVP Albert Kallal's
paper on this topic:

Using a wan with ms-access? How fast, how far?
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

Here are some papers on the topic of splitting a database:

Split the Database
http://www.access.qbuilt.com/html/gem_tips.html#SplitDB

Splitting a access database, or how to run ms-access in a multi-user mode.
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

Split your MDB file into data and application
http://allenbrowne.com/ser-01.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi
I have a winform application with Ms Access as its database. It is a
single user application. Now there are more than one PC having the same
application installed in it, therefore I need to share this database so
that all the updates made to the database are available to all users.
I've read about replica but I think it is inconvenient to synchronize
each time updates are made. I was thinking to store this database in a
PC and let others PCs have access to it, something like what SQL Server
can do. Is this possible for Access? Can someone suggest what is the
best approach to tackle this problem. I thank you in advance for your
help
 
V

Van T. Dinh

If I read your description correctly ("winform", i.e. it sounds like a .Net
Front-End application), you are only using the JET database to store data
and NOT Access.

JET database can certainly be accessed by mutiple users (max 255? but in
practice, it is much less) but certainly, you will need to adjust your .Net
application to access the JET database / MDB file on a shared directory.

Suggest you contact the original developer of your "winform" application ...
 
Top