MartyConnelly
martyconnelly at shaw.ca
Tue Dec 28 11:22:00 CST 2004
Must be the Eggnog causing blurry vision.. Prepping for Hogmanay. Or just having answered 3 similar questions on MySQL. Jim Lawrence wrote: >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