Syncronize Access Schema & Data - VB.Net

Is there a component (free or paid, does not matter) that Can help sync the schema and data of 2 access databases?  I would need to do this on users machines that do not have access installed.

I have searched and am coming up short.

Thanks!
LVL 1
vwallaAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I believe that you do. Sorry, but I'm not aware of any standalone utilities that would do this. It's possible to do with DAO (just loop through the Tables and examine the Fields, Indexes, etc, and then do the same on your target machine and make sure that the Target matches the Source).
0
 
eugenbvCommented:
You must have Access installed on user machine in order to open the db.
Here is a tool that I use (free trial 30 days) http://www.altova.com/databasespy.html
0
 
vwallaAuthor Commented:
I am thinking JRO??  Messing with that right now and will see where it takes me.  Thanks.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
<<You must have Access installed on user machine in order to open the db.>>
That is not true.

You do need the JET or ACE database engine files. You can use ASP, VB or >NET to open and the database and make scheme changes.  

Note: I use ASP to create and update JET (.MDB) databases on a web server that has never had  Access installed.

With VB.NET I would use  ADO.NET  to do what you need.

0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Also are the databases JET 4 (.mdb) or ACE (.accdb)?
0
 
vwallaAuthor Commented:
What about Microsoft Sync Services...had any experience with that?  I have used it a long time ago for SQL server to SQL CE, but not access to access.
0
 
vwallaAuthor Commented:
They are Jet 4 (.mdb)
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Is this a new application you are developing or is it already in production?

JET 4 does have built in  Replication.  It is not something that you can just turn on.

Are the two databases on the same LAN?







0
 
vwallaAuthor Commented:
I have one that is deployed on one of my sales guys machines and one that is local here.  New development (beta).  I can make these changes now if need be before I take it live.

The question is does replication fully replicate, or can you pick and choose the tables.  Some tables will only need column updates to the schema (no data), and other schema and data changes.
0
 
vwallaAuthor Commented:
Oh yeah, and some just data changes...
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
FMS has some tools that can manage this: www.fmsinc.com

There's also the stuff from SSW: http://www.ssw.com.au/ssw/DataPRO/

JRO _could_ be used, but then so could DAO, which would be a better choice for working with Access databases.
0
 
vwallaAuthor Commented:
Looks like you have to have MS Access for all of these, correct?  I cannot gurantee that my clients have this.
0
 
vwallaAuthor Commented:
Would you rec. DAO & iterating the tables and indexes, vs. replication?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
It's worked for quite a lot of people, and DAO is still the best way to manage an Access/Jet/ACE database. I've used it myself for just such a thing.
0
 
vwallaAuthor Commented:
Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.