Migration Access97 (*.mde) database in SQLServer2005

[Adem GULER]

Dear All,

I have two questions regarding on Access97.

1. q: We are using an application which have developed on access97, to
prevent database problems (for example, freezing), could possible to migrate
access97 *.mde database from access97 through access2003 to sqlserver2005
with the help of "Microsoft SQL Server Migration Assistance (SSMA) for
Access"?

2. q: Could possible to run the application "which have developed on
access97" in 64-bit Standard Edition of Windows Server 2003?

I am going to waiting your respond over questions?

Best regards.

[John W. Vinson]

On Wed, 1 Apr 2009 08:36:02 -0700, Adem GULER

Post by Adem GULER
Dear All,
I have two questions regarding on Access97.
1. q: We are using an application which have developed on access97, to
prevent database problems (for example, freezing), could possible to migrate
access97 *.mde database from access97 through access2003 to sqlserver2005
with the help of "Microsoft SQL Server Migration Assistance (SSMA) for
Access"?

No. You will need the original .mdb database from which the .mde was compiled.
You will need to make design changes which cannot be done in a compiled .mde.

Post by Adem GULER
2. q: Could possible to run the application "which have developed on
access97" in 64-bit Standard Edition of Windows Server 2003?

That I don't know for sure but I expect that you could.

Here are some resources from a post by former MVP, now Microsoft expert Mary
Chipman:


TechEd Online Panel (video):
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for: "Are we there yet? Successfully navigating the bumpy road
from Access to SQL Server"

Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx or
download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/SQLAccessWhatsRight.doc

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446