Preparing for SQL Server

[hollyylloh]

I am planning the creation of a database in Access 2007. I will, in the
future, us SQL Server (probably 2008) for the backend. Can you direct me to
some reading on the best way to create the database now with the conversion
to SQL server in mind for the future?

I have read some conflicting articles and would appreciate an official
article on the history of the engines used in Access. Some articles make it
sound like Access still uses the JET engine when used out-of-the-box, and
some articles indicate that we have moved on to other engines. What has the
progression been through the years, and what is the out-of-the-box engine
used now? One article said that there was a DE that could be used that would
make the transition to SQL Server nearly seamless. Please, I need to know
about this.

Thank you for your time.

 

[Graham Mandeno]

This would be a very good place to start:
http://www.granite.ab.ca/access/sqlserverupsizing.htm

 

[Fred]

Make sure you tables are clean and holding regular table data. I.E. not
messed up by using any Microsoft in-table "features" that aren't in real
tables. (I.E. that can't be moved into SQL tables)