[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

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!
0
vwalla
Asked:
vwalla
  • 8
  • 3
  • 3
  • +1
1 Solution
 
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
 
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )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
 
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

Featured Post

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.

  • 8
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now