Jim Lawrence
accessd at shaw.ca
Tue Dec 28 01:41:21 CST 2004
Thanks Marty: ...But the question is to do with MS SQL not MySQL. The ODBC driver is actually Microsoft's driver. I am having an issue with the way it retrieves the table names from the MS SQL DB. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Monday, December 27, 2004 10:50 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Linking Tables from MS SQL using ODBC There is a "MYSQL/ODBC list" Join the mailing list from this page about 2/3 down. http://lists.mysql.com Some of ODBC drivers for MaxDB don't always work and you might have to go back a release from the latest one. At least it was that way a year ago. I had Access 97 with WinXP connected at that time to MaxDB not MySQL Maybe look through the archives when you are subscribing to the list Jim Lawrence wrote: >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 > > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com