Access Database Synchronizing

[Guest]

Hi, I have developed a software which is to run on multiple PCs on a network
sharing the same database on an inhouse server. There is another database
which has some similar tables that sites on a server where the website is. I
need to have the common tables synchronized. How is this possible and what
issues will I have in doing this?
Well there be a problem if the synchronization happens when someone is using
our software which is making some changes to that table at the same time? Or
if someone on the website is entering some information that updates the
database?

I am using Visual Studio 2005 with C#. Access Database.

 

[Guest]

anyone?????

 

[Alex Dybenko]

Hi,
Not sure that Access replication can work here, so I think you have to make
your own proc to synch databases. Process depends on your business rules,
but in general - this is a set of update/append/delete queries

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Access dosen't have any way to be synchronized?

Hi,
Not sure that Access replication can work here, so I think you have to make
your own proc to synch databases. Process depends on your business rules,
but in general - this is a set of update/append/delete queries

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Alex Dybenko]

There is - it is called replication, but not sure it will fit your needs

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thank you.

I found this article. This is what I needed.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/intrjet4.asp