Issues on upsizing Microsoft Access to SQL Server

[Chris Asaipillai]

I have been given an Microsoft Access application to upsize into MS SQL
Server.

I would like to know what are the issues that I should consider during this.

- What fields should I look at that wont upsize?

- Will all Validation Rules upsize?

- What parts of VBA code wont work within MS SQL?

- What Acess queries wont work in MS SQL?

Many thanks

Chris

 

[Douglas J. Steele]

See whether http://support.microsoft.com/?id=330468 helps.

(Don't worry if you're not using Access 2002: it applies to all versions)

 

[Tony Toews]

I have been given an Microsoft Access application to upsize into MS SQL
Server.

I would like to know what are the issues that I should consider during this.

- What fields should I look at that wont upsize?

- Will all Validation Rules upsize?

- What parts of VBA code wont work within MS SQL?

- What Acess queries wont work in MS SQL?

Do a search at the Knowledge Base at support.microsoft.com using the
keywords "upsizing" to review the various white papers on upsizing
Access to SQL Server as well as to ensure you have any updates
required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm