Access to SQL help

[travismp]

I have a big access database (300 MB, main table has 500,000 records) that needs to be switched over to SQL but I have no idea how to do this.

1.) Is there any great books or pdfs out there with step by step info?

2.) I want my backend to be SQL and my front-end to stay Access. Will any of the queries, forms, reports need to change?

3.) Once I find a way to convert the tables to my sql server how do I connect the frontend access db to the backend SQL? Will I need to do this on EVERY workstation?

I want the frontend DB to change as little as possible due to the amount of queries, reports, forms, ect already there.

Thank you for any and all help getting this project started. THANK YOU.

 

[boblarson]

1. I'd consider this a must have for any Access developer going to SQL Server (based on older version of SQL but still relevant for sure):
http://www.amazon.com/Microsoft-Acc...=sr_1_1?ie=UTF8&s=books&qid=1224627258&sr=8-1

2. Yes, some will have to change as it deals with it differently. It all depends on what your frontend does, data it gets, etc. as to how much it will have to change.

3. You can link via an ODBC connection (DSN) or use a DSN-less connection (search here on that as there are some examples).