I haven't futzed much with DBMS/ODBC connections and whatnot through MI much, but it sounds like it is indeed opening it exclusively. when you re-open the connection after access has opened the database, the MI connection attempt is forced to re-open in shared mode.
are you able to supply a connection string within the MBX app or does it have to be done explicitly through the MI dialogs? given that we use MI 7.0 here now which I can't seem to find any database related stuff in, I can't find a way to try and replicate it exactly, but similar problems will occur when attempting to connect two instances of access to the same JET back-end if you don't have the connections setup correctly. -----Original Message----- From: Chris Prescott [mailto:[EMAIL PROTECTED] Sent: Tuesday, 22 February 2005 12:40 PM To: [email protected] Subject: RE: MI-L 'opened exclusively' problem with Access 2003 Christopher Prescott Thanks Ash, I can open as many instances of MI (with my Access table open) as like without any problems but when I then try to open Access I get locked out. This is what I'm trying to do. In my MapBasic app. I have several Access tables open retrieving data from the Access db. My MB app. lets me select a MapInfo object and then(using it's ID) it starts up the Access application, opens a particular form and goes to the relevant record. This part is failing since I get locked out of Access. HOWEVER, in saying this I may have found a work around. If I issue a 'Server Disconnect' statement before my app. sarts Access it works correctly - except for one problem. For some reason that I am yet to figure out, the buttons on my custom buttonpad all become disadbled - and I cannot enable them. This also occurs if I use the 'File > Close DBMD Connection..' option. If I open a new DBMS connection my button pad comes active again. I don't know what the link is. Chris. -----Original Message----- From: Simmonds, Ashley (DTUP) [mailto:[EMAIL PROTECTED] Sent: Tuesday, 22 February 2005 11:58 AM To: [email protected] Subject: RE: MI-L 'opened exclusively' problem with Access 2003 heya chris, just checked mine and we have version 7.0 here now, but I can't even seem to find an ODBC drivery thing anywhere, however I can select MDB as a file type directly from the file-open dialog. I guess 7.0 supports access natively through OLEDB or something. dunno. anyhoo, are you able to open multiple instances of MI pointing at the db? one of the other annoying things I've come across with access (not related to MI) is that when logged in as someone else, it sets the "owner" of the mdb file to the last person who closed it. something about the meta-information of the file is then saved in that user's TEMP directory, meaning anyone else who logs on and tries to open the file gets the dreaded "database can't be found" deal to it. what I'm getting at is that if MI is opened through a different user/account to the user opening access, that temp data will not be readable by them. to get around this I had our I.T. section set a common and openly readable/writable %TEMP% directory so it didn't matter who was playing in it. may not be relevant to your stuff, but it's an annoying problem that took me years to figger out. ash -----Original Message----- From: Chris Prescott [mailto:[EMAIL PROTECTED] Sent: Tuesday, 22 February 2005 10:41 AM To: [email protected] Subject: MI-L 'opened exclusively' problem with Access 2003 I open some tables from an Access 2003 database in MapInfo (6.5) without any problems. If I then go and try to start my Access 2003 application I get the following error: "Microsoft Office Access can't open the database because it is missing, or opened exclusively by another user." The only other user is MapInfo. The ODBC driver being used does not have the 'Exclusive' option checked and the default open mode in the database is set to shared. I also get this message if I open a table from Access using 'File > Open Table' and selecting MS Access as the file type. Any clues as to how I can operate both applications at the same time. Closing MapInfo and then opening the Access database is not an option. Thanks in advance for any help. � CHRISTOPHER PRESCOTT [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15370 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15371 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15372 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15404
