Posted by Bon on 10/31/05 13:34

Hello all

Would it be possible to migrate the MS Access 2000 to MS SQL Server
2000?

My application is using MS Access 2000 as database and as user
interface such as forms. Now, I want to migrate the backend database
from MS Access 2000 to MS SQL Server 2000. However, I want to keep the
MS Access 2000 interface. Would it be possible?

If I migrate the MS Access to SQL Server, would the queries, back-end
VBA, macro, tables and forms be affected? Do I need to change the MS
Access data type to SQL server supported data type?

Which tool I can use to do the migration? Upsizing wizard or exporting
the Access database and then importing it to the SQL server?

Thanks in advance

Cheers
Bon

• Next in forum: Re: DTS Table Import Issue
• Prev in forum: Re: Creating Tables on the Fly
• Thread view: Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?

[Reply to this message]