MS Access

Compares and synchronizes SQL database content.

MS Access

Postby graffiti » Mon Feb 05, 2007 7:04 am

Do you support MS Access?
Posts: 1
Joined: Mon Feb 05, 2007 5:43 am

Postby Dave Mellors » Mon Feb 05, 2007 10:27 am

No, Data Compare does not support Microsoft Access.

Data Compare is supported on SQL Server 7 and above.
Dave Mellors
Technical Support Engineer
Red Gate Software Ltd.
Tel US and CAN: 1-866-RED GATE
Tel World: +44 (0)870 160 0037 ext 43
Dave Mellors
Posts: 30
Joined: Thu Feb 01, 2007 5:03 pm

MSAccess And SQL Data Compare

Postby lc6529 » Wed Apr 18, 2007 6:52 pm

You can get around the access limitation by doing the following:

#1: Setting up the Access database as a LINKED server to your SQL server.

#2: Setup a SQL Database that consists of VIEWS to each table in your access database.

I have done this and can sync the access database to my sql database.
Posts: 20
Joined: Wed Apr 18, 2007 6:32 pm

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests