Jim Lawrence
accessd at shaw.ca
Tue Dec 28 08:47:54 CST 2004
Thanks for your help Gustav. I will set up a function to do that. In the place that I am currently working their application was originally designed in Access. When it came to updating the system to work with larger DBs the solution cobbled together was a non-Access front-end and an Access MDB backend that uses ODBC to connect to all the data. Scary :-( Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, December 28, 2004 12:58 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Linking Tables from MS SQL using ODBC Hi Jim It is normal, but no big deal. Just loop through the DAO.TableDefs collection and adjust the Name property if this begins with "dbo_". /gustav >>> accessd at shaw.ca 28-12-2004 05:08:00 >>> Hi All Never having used an ODBC connection, to MS SQL, since pre 1997, I am having some issues when linking the tables, to Access. The tables link OK but each table is prefixed with the owner code, in this case DBO. Example table 'test' becomes 'dbo_test'. Is this normal? Did I miss some flag? Any help would be greatly appreciated as the prospect of manually renaming 250 odd tables does not excite. MTIA Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com