[AccessD] Upsize wizard MDB to SQL

Here is a list of considerations to look at  re conversion mdb be  to sql
and links to MS upsizing wizard white paper.

http://www.upsizewizard.com/index.cfm?fuseaction=browse&id=5036&pageid=22


Here is a method of relinking SQL Server via DAO ODBC via DSN-Less 
Connections
It also has a coding method to ensure SQL Backend tables have an Index.
A common problem otherwise your SQL tables are not updateable.

http://www.accessmvp.com/djsteele/DSNLessLinks.html

It is not so easy if you go with ADO and  SQL Stored Procedures, you 
will have to change forms etc.
and queries.

Easy . Well it is is easy to repair space shuttle heat tiles, if you 
have the right tool - an opposable thumb.
 
Also make sure you understand, how to do proper SQL Backup procedures.

This book might help SQL: Access to SQL Server (Paperback)
by Susan Sales Harkins, Martin W.P. Reid


Johncliviger at aol.com wrote:

>Hi all
> 
>I've asked to migrate an Access 2002 BE to SQL 2000 server. Not having  done 
>this before and not wanting fans and brown stuff to meet. So I 'm looking  for 
>a some documentation on this.
> 
>My initial view is to apply the upsize wizard to the BE and keep  the FE as 
>it is and link it via odbc to SQL BE. 
> 
>Comments and pointers most welcome. 
> 
>johnb
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada