UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Last Ms SQL Version To Connect From Ms Access 2.0, Any Versions    
 
   
tohas
post Jan 24 2020, 06:36 AM
Post#1



Posts: 70
Joined: 9-July 10



Hi

I am migrating an old MS Access 2.0 16 bit DB to MS SQL Server 2016. But there is only 64 bit.
I want to export my tables directly (without text export and bcp import, or without other tools)

So, I am planning to use an older MS SQL version (32 bit) for temporary transfers and development.



Q1:
What is the highest MS SQL 32 bit version that I can use for this purpose?

Q2:
Can I backup and restore with ms SQL backup to a 64 bit ms SQL server?


thanks
This post has been edited by tohas: Jan 24 2020, 06:39 AM
Go to the top of the page
 
jleach
post Jan 24 2020, 07:58 AM
Post#2


UtterAccess Administrator
Posts: 10,441
Joined: 7-December 09
From: St. Augustine, FL


Hi,

While SQL Server itself is 64bit, you should be able to use a 32 bit ODBC driver to connect to it (assuming you can do so with 16 bit Access... not positive on that one, but for sure just because SQL itself is 64 bit doesn't mean we need to run 64 bit Access: 32bit ODBC works fine)

Restoring to newer versions of SQL is generally a non-issue. For restoring to older versions, you have to set the compatibility level on the database accordingly. I'm not sure how far back they're supported.

I can't help but state the obvious question here: have you considered updating Access itself?

--------------------
Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
 
tohas
post Jan 24 2020, 12:33 PM
Post#3



Posts: 70
Joined: 9-July 10



It's my aim to do it all from MS Access 2.0 without any intermediate steps.
This post has been edited by tohas: Jan 24 2020, 12:35 PM
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th February 2020 - 07:23 PM