[AccessD] Upsize wizard MDB to SQL

The wizard is acceptable, but I have usually found that I need to almost
start from scratch.  The tables migrate beautifully, but the best way to
handle most everything else as far as data sources and pulling specific data
is different.  Concentrate on data handling, that is where the biggest
differences are.  Take advantage of triggers to handle hard data validation
rules, they are more robust than code in forms.  Do as much filtering as
possible on the server side.  Pass through queries can help with this a lot.

Debbie

-----Original Message-----
From: Johncliviger at aol.com [mailto:Johncliviger at aol.com] 
Sent: Saturday, August 13, 2005 6:13 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Upsize wizard MDB to SQL


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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.