Migration Access97 *.mde db 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 db problems (for example, freezing), could possible to migrate
access97 *.mde db 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.

 

[Sylvain Lafontaine]

A97 is supposed to have an Upsizing Wizard somewhere but I think that this
was as a separate download. For the rest, sure you can upgrade to A2003 and
then use the SSMA; however, probably that you can do the job yourself if you
want to: all you have to do is to recreate the tables on the SQL-Server,
link them and then copy the data over using the now ODBC linked tables.

As to your second question about X64, in most cases, you won't have any
problem at all. However, you'll have to try by yourself to be 100% sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Adem GULER]

Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail informations and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a little bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I learn, when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my second
question. It is solved.

I am going to waiting your respond over questions?

BR

 

[Sylvain Lafontaine]

Maybe you could start by first installing Access 2003 and then opening your
Access 97 MDB database file using Access 2003? After that, you check if
everything is OK.

Access 97 is now old stuff, so I'm not sure if Access 2003 has the
capabilities of importing an Access 97 MDB database file; you'll have to try
by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail informations
and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a little
bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I learn,
when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my second
question. It is solved.

I am going to waiting your respond over questions?

BR.
--------------------------------------------------------------------------------

A97 is supposed to have an Upsizing Wizard somewhere but I think that
this
was as a separate download. For the rest, sure you can upgrade to A2003
and
then use the SSMA; however, probably that you can do the job yourself if
you
want to: all you have to do is to recreate the tables on the SQL-Server,
link them and then copy the data over using the now ODBC linked tables.

As to your second question about X64, in most cases, you won't have any
problem at all. However, you'll have to try by yourself to be 100% sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Sylvain Lafontaine]

Also, if your intention is to use Access 2003 only for the upsizing step and
keep Access 97 as the frontend of your application, then you don't really
need to use Access 2003 or the Migration Assistant at all as you can
recreate the tables on SQL-Server, create ODBC links to them, export the
data - if necessary - and that's all.

Many people prefer to do their upsizing process manually instead on relying
on either the Upsizing Wizard or the Migration Assistant.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Maybe you could start by first installing Access 2003 and then opening
your Access 97 MDB database file using Access 2003? After that, you check
if everything is OK.

Access 97 is now old stuff, so I'm not sure if Access 2003 has the
capabilities of importing an Access 97 MDB database file; you'll have to
try by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail informations
and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a little
bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I learn,
when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my
second
question. It is solved.

I am going to waiting your respond over questions?

BR.
--------------------------------------------------------------------------------

A97 is supposed to have an Upsizing Wizard somewhere but I think that
this
was as a separate download. For the rest, sure you can upgrade to A2003
and
then use the SSMA; however, probably that you can do the job yourself if
you
want to: all you have to do is to recreate the tables on the SQL-Server,
link them and then copy the data over using the now ODBC linked tables.

As to your second question about X64, in most cases, you won't have any
problem at all. However, you'll have to try by yourself to be 100%
sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)


Dear All,

I have two questions regarding on Access97.

1. q: We are using an application which have developed on access97, to
prevent db problems (for example, freezing), could possible to migrate
access97 *.mde db 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.

 

[Adem GULER]

Dear Sylvain,
Please excuse me, could you please forward that my questions to some one else?
I need exactly answare and step by step instruction.

BR.

Also, if your intention is to use Access 2003 only for the upsizing step and
keep Access 97 as the frontend of your application, then you don't really
need to use Access 2003 or the Migration Assistant at all as you can
recreate the tables on SQL-Server, create ODBC links to them, export the
data - if necessary - and that's all.

Many people prefer to do their upsizing process manually instead on relying
on either the Upsizing Wizard or the Migration Assistant.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Maybe you could start by first installing Access 2003 and then opening
your Access 97 MDB database file using Access 2003? After that, you check
if everything is OK.

Access 97 is now old stuff, so I'm not sure if Access 2003 has the
capabilities of importing an Access 97 MDB database file; you'll have to
try by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail informations
and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a little
bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I learn,
when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my
second
question. It is solved.

I am going to waiting your respond over questions?

BR.
--------------------------------------------------------------------------------


:

A97 is supposed to have an Upsizing Wizard somewhere but I think that
this
was as a separate download. For the rest, sure you can upgrade to A2003
and
then use the SSMA; however, probably that you can do the job yourself if
you
want to: all you have to do is to recreate the tables on the SQL-Server,
link them and then copy the data over using the now ODBC linked tables.

As to your second question about X64, in most cases, you won't have any
problem at all. However, you'll have to try by yourself to be 100%
sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)


Dear All,

I have two questions regarding on Access97.

1. q: We are using an application which have developed on access97, to
prevent db problems (for example, freezing), could possible to migrate
access97 *.mde db 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.

 

[Sylvain Lafontaine]

You can repost your question in a more appropriate newsgroup such as
microsoft.public.access.sqlupsizing or
microsoft.public.access.odbcclientsvr.

This one here (microsoft.public.access.adp.sqlserver) is about problems
related to ADP in connection with SQL-Server and don't really deal with the
upsizing process or with ODBC linked tables.

However, in all cases, you'll have to do some work and studying by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Dear Sylvain,
Please excuse me, could you please forward that my questions to some one
else?
I need exactly answare and step by step instruction.

BR.

Also, if your intention is to use Access 2003 only for the upsizing step
and
keep Access 97 as the frontend of your application, then you don't really
need to use Access 2003 or the Migration Assistant at all as you can
recreate the tables on SQL-Server, create ODBC links to them, export the
data - if necessary - and that's all.

Many people prefer to do their upsizing process manually instead on
relying
on either the Upsizing Wizard or the Migration Assistant.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Maybe you could start by first installing Access 2003 and then opening
your Access 97 MDB database file using Access 2003? After that, you
check
if everything is OK.

Access 97 is now old stuff, so I'm not sure if Access 2003 has the
capabilities of importing an Access 97 MDB database file; you'll have
to
try by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)


Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail
informations
and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a
little
bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I
learn,
when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my
second
question. It is solved.

I am going to waiting your respond over questions?

BR.
--------------------------------------------------------------------------------


:

A97 is supposed to have an Upsizing Wizard somewhere but I think that
this
was as a separate download. For the rest, sure you can upgrade to
A2003
and
then use the SSMA; however, probably that you can do the job yourself
if
you
want to: all you have to do is to recreate the tables on the
SQL-Server,
link them and then copy the data over using the now ODBC linked
tables.

As to your second question about X64, in most cases, you won't have
any
problem at all. However, you'll have to try by yourself to be 100%
sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and
SQL-Server
(French)


Dear All,

I have two questions regarding on Access97.

1. q: We are using an application which have developed on access97,
to
prevent db problems (for example, freezing), could possible to
migrate
access97 *.mde db 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.

 

[Sylvain Lafontaine]

Also, here's a some links that have been published by Alex Dybenko as an
answer to another thread about upsizing problems:

http://accessblog.net/2009/01/migration-to-sql-server.html


And here are others by 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.aspf...ifferences-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

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Dear Sylvain,
Please excuse me, could you please forward that my questions to some one
else?
I need exactly answare and step by step instruction.

BR.

Also, if your intention is to use Access 2003 only for the upsizing step
and
keep Access 97 as the frontend of your application, then you don't really
need to use Access 2003 or the Migration Assistant at all as you can
recreate the tables on SQL-Server, create ODBC links to them, export the
data - if necessary - and that's all.

Many people prefer to do their upsizing process manually instead on
relying
on either the Upsizing Wizard or the Migration Assistant.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Maybe you could start by first installing Access 2003 and then opening
your Access 97 MDB database file using Access 2003? After that, you
check
if everything is OK.

Access 97 is now old stuff, so I'm not sure if Access 2003 has the
capabilities of importing an Access 97 MDB database file; you'll have
to
try by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)


Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail
informations
and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a
little
bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I
learn,
when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my
second
question. It is solved.

I am going to waiting your respond over questions?

BR.
--------------------------------------------------------------------------------


:

A97 is supposed to have an Upsizing Wizard somewhere but I think that
this
was as a separate download. For the rest, sure you can upgrade to
A2003
and
then use the SSMA; however, probably that you can do the job yourself
if
you
want to: all you have to do is to recreate the tables on the
SQL-Server,
link them and then copy the data over using the now ODBC linked
tables.

As to your second question about X64, in most cases, you won't have
any
problem at all. However, you'll have to try by yourself to be 100%
sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and
SQL-Server
(French)


Dear All,

I have two questions regarding on Access97.

1. q: We are using an application which have developed on access97,
to
prevent db problems (for example, freezing), could possible to
migrate
access97 *.mde db 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.

 

[wei jing ping]

Dear Sylvain,
Please excuse me, could you please forward that my questions to some one else?
I need exactly answare and step by step instruction.

BR.

Also, if your intention is to use Access 2003 only for the upsizing step and
keep Access 97 as the frontend of your application, then you don't really
need to use Access 2003 or the Migration Assistant at all as you can
recreate the tables on SQL-Server, create ODBC links to them, export the
data - if necessary - and that's all.

Many people prefer to do their upsizing process manually instead on relying
on either the Upsizing Wizard or the Migration Assistant.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Maybe you could start by first installing Access 2003 and then opening
your Access 97 MDB database file using Access 2003? After that, you check
if everything is OK.

Access 97 is now old stuff, so I'm not sure if Access 2003 has the
capabilities of importing an Access 97 MDB database file; you'll have to
try by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail informations
and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a little
bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I learn,
when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my
second
question. It is solved.

I am going to waiting your respond over questions?

BR.

------------------------------------------------------------------------- -------

:

A97 is supposed to have an Upsizing Wizard somewhere but I think that
this
was as a separate download. For the rest, sure you can upgrade to A2003
and
then use the SSMA; however, probably that you can do the job yourself if
you
want to: all you have to do is to recreate the tables on the SQL-Server,
link them and then copy the data over using the now ODBC linked tables.

As to your second question about X64, in most cases, you won't have any
problem at all. However, you'll have to try by yourself to be 100%
sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)


Dear All,

I have two questions regarding on Access97.

1. q: We are using an application which have developed on access97, to
prevent db problems (for example, freezing), could possible to migrate
access97 *.mde db 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.

 

[edith zamorano]

who i will

Dear Sylvain,
Please excuse me, could you please forward that my questions to some one
else?
I need exactly answare and step by step instruction.

BR.

Also, if your intention is to use Access 2003 only for the upsizing step
and
keep Access 97 as the frontend of your application, then you don't really
need to use Access 2003 or the Migration Assistant at all as you can
recreate the tables on SQL-Server, create ODBC links to them, export the
data - if necessary - and that's all.

Many people prefer to do their upsizing process manually instead on
relying
on either the Upsizing Wizard or the Migration Assistant.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Maybe you could start by first installing Access 2003 and then opening
your Access 97 MDB database file using Access 2003? After that, you
check
if everything is OK.

Access 97 is now old stuff, so I'm not sure if Access 2003 has the
capabilities of importing an Access 97 MDB database file; you'll have
to
try by yourself.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)


Dear Sylvain,

Could I have possibility to request from you to be more enlightening?
Because to be able to go to the solution I need more detail
informations
and
specifications. So,

You are mentioning on my first question that, for sure I can upgrade
Access97 to Access2003 and after then use the SSMA. Please write a
little
bit
more details. How can I start?

Exactly question is:
[workstation side]- > [server side]

Could possible to update the existing *.mde database from

*.mde (access97)- > sql2000

to

*.mde (access97) - > sql2005 or
[*.mde (access97)- >*.mde (access2003)] - > sql2000 or
*.mde (access2003) - > sql2005
with the help of SSMA?

For second question: the result of my successfully researching I
learn,
when
Microsoft develope new version of some software, advanced version is
configured to support earlier versions. It is enought answare to my
second
question. It is solved.

I am going to waiting your respond over questions?

BR.
--------------------------------------------------------------------------------


:

A97 is supposed to have an Upsizing Wizard somewhere but I think that
this
was as a separate download. For the rest, sure you can upgrade to
A2003
and
then use the SSMA; however, probably that you can do the job yourself
if
you
want to: all you have to do is to recreate the tables on the
SQL-Server,
link them and then copy the data over using the now ODBC linked
tables.

As to your second question about X64, in most cases, you won't have
any
problem at all. However, you'll have to try by yourself to be 100%
sure.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and
SQL-Server
(French)


Dear All,

I have two questions regarding on Access97.

1. q: We are using an application which have developed on access97,
to
prevent db problems (for example, freezing), could possible to
migrate
access97 *.mde db 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.