Converting to Sql

[s0rtd]

Hi Guys..

I am currently in the process of convervting our Access Dbase to Sql, and have a few question which I hope you wont mind answering?

Our dbase is split into a frontend and backend, and the backend is about 50mb.
Before i can upsize the backend i have to make all the names throughout it compliant with Sql - there are spaces everywhere.

What i am wondering is once i have converted all the names in the backend, do i have to do the same to everything in the frontend?? ie: queries, forms etc?? or will they dynamically update?

Also can anyone recommend a good book on SQL (i have never used it before and would really like to get a grip on it.)

cheers
Jurgen

 

[pbaldy]

Access versions 2000 and later include a feature called "Name Autocorrect". If this feature is turned on, it will probably handle many of your changes. I doubt it will catch them all; you'll probably need to change field references in code.

A book I like is "MS Access Developer's Guide to SQL Server", by Chipman & Baron. It's got a lot of info on converting to SQL Server, and getting the most out of it.

 

[wizcow2]

This ones good.
SQL:Access to SQL Server

Tom