ms access with sql server

[Nandini]

My access database is based on Access 2003. I want to split the database into
back-end and front-end. I want to keep tables and queries at the back-end
database, which is to be migrated at sql server 2005. The front-end part will
contain only the forms, macros, modules, reports. The reason is to overcome
some limitations of ms access regarding storage space an jet database engin.
Is it possible? If so, what is to be done? Anyone can help me anyway?
With best regards

 

[Armen Stein]

You can use the SQL Server Migration Assistant for Access tool (SSMA for
Access). Microsoft provides video tutorials.

http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx

Chris

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Armen Stein]

You can use the SQL Server Migration Assistant for Access tool (SSMA for
Access). Microsoft provides video tutorials.

http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx

Chris

Yes, and after it's migrated there are some techniques you should
consider to get the most out of SQL Server and avoid performance
issues.

I've written a slideshow on techniques for using Access as a
client-server front-end to SQL Server databases. It's called "Best of
Both Worlds" at www.JStreetTech.com/Downloads.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com