[AccessD] Upsize wizard MDB to SQL

Couple of  other books that might come in handy
Good explanation on how to use SP's from Access
Microsoft Access Developer's Guide to SQL Server (Paperback)
by Andy Baron, Mary Chipman

Don Celko's series on SQL for Smarties I think there are 4 in series
Good if you need to anything complex in SQL like storing hierarchial 
structures
ie relational tables to XML.

I see Mary Chipman has gone to work at Microsoft, along with Michael Kaplan.



MartyConnelly wrote:

> 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