access db replication on vb6

how can i use access db replication with vb6? please provide some code on how to make an existing db into design master, create replicas and sync.

thanks
LVL 26
ee_rleeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
This should get you started:

http://msdn2.microsoft.com/en-us/library/aa140024(office.10).aspx

http://office.microsoft.com/en-us/access/HP052167961033.aspx

There are several articles at this link from the Master of Replication ... Michael Kaplan:

http://www.trigeminal.com/usenet/usenet.asp?1033

mx
0
 
ee_rleeAuthor Commented:
is it possible to put a password on the master/replica databases?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I don't see why not. I'm wondering that if you put one on the Master, it would be replicated to the Replicas.  Or, maybe the pwd is completely independent.

mx
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ee_rleeAuthor Commented:
i tried to do that on access 2000 but i cannot convert it to design master if it has a password. i removed the password. but after it was made replicable, the set password option was unavailable for the design master and replicas. i have not tried it in code yet, i want to make sure that it is possible first..

if it is not possible, can you recommend on a workaroud? only the master database will be modified. replicas will be just for viewing purposes.

thanks
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I don't have a workaround, unless User Level Security would work in a Replication scenario.

mx
0
 
ee_rleeAuthor Commented:
ok thanks, i will just find another way to update the database
0
All Courses

From novice to tech pro — start learning today.