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    
post Jan 24 2020, 06:36 AM

Posts: 93
Joined: 9-July 10


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.

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

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

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

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


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
post Jan 24 2020, 12:33 PM

Posts: 93
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
post Feb 21 2020, 05:11 AM

Posts: 93
Joined: 9-July 10


Access 2007 is the last possible Version to link Access 2.0 Tables.
From Access 2007 you can transform the data and pump it to MSSQL 2017

Go to the top of the page
post Feb 21 2020, 02:31 PM

UtterAccess VIP
Posts: 3,060
Joined: 12-April 07
From: Edmonton, Alberta Canada

If you have a working ODBC driver for access 2.0, then you should be able to connect to any recent version of SQL server. And that includes x64 bit versions of SQL server.

So, even the latest and newest version of SQL server, and even if that SQL server is x64 bits? It should STILL work with Access 2.0.

Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada

Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    27th May 2020 - 10:26 AM