Administrator
administrator at it.glasgow.gov.uk
Wed Jan 29 02:49:01 CST 2003
-SQL string's built in code need to be T-SQL, this can be very time consuming and tricky the first few go arounds -Temp tables or local tables (for reports or menu driven forms) no longer exist -Filtered recordsources can give problematic error messages, something along the lines of "The data record will be saved but is not part of the data set and will not appear". These are just a few that pop to mind, there are plenty of gotcha's in upsizing, but after you've been through it a few times it's not that bad. Chris Mackin Denver Database Consulting, LLC chris at denverdb.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Mwp.Reid at Queens-Belfast.AC.UK Sent: Saturday, January 25, 2003 4:03 AM To: AccessD at databaseadvisors.com Subject: [AccessD] ADPs Was wondering What sort of problems have those of you using ADPs come across when upsizing existing databases. Martin _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd