Red Gate forums :: View topic - MS Access
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

MS Access

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
graffiti



Joined: 05 Feb 2007
Posts: 1

PostPosted: Mon Feb 05, 2007 8:04 am    Post subject: MS Access Reply with quote

Do you support MS Access?
Back to top
View user's profile Send private message
Dave Mellors



Joined: 01 Feb 2007
Posts: 31

PostPosted: Mon Feb 05, 2007 11:27 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
lc6529



Joined: 18 Apr 2007
Posts: 20

PostPosted: Wed Apr 18, 2007 7:52 pm    Post subject: MSAccess And SQL Data Compare Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group