Marie If you have split your access database so that all the tables live in the mdb file, then MapInfo will not need to talk to the mde file at all. Simply create the MAP_CATALOGUE in the mdb file. Essentially, MapInfo and the mde files are applications accessing data in the mdb file.
This situation will be complicated if you have queries in your mde file which you need to access from MapInfo. In this case you can either move/copy the queries to the mdb file, write the queries in MapInfo, or create another MAP_CATALOGUE in the mde file. I do not recommend the later, as you can end-up with nasty dependencies which are hard to understand later. Hope this helps Matt Matthew Trigg Database Manager Geographers' A-Z Map Company Ltd. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Lilley, > Marie > Sent: 25 February 2002 08:06 > To: 'MapInfo List' > Subject: MI-L ACCESSING REMOTE TABLES IN A 'SPLIT ACCESS DATABASE' > Importance: High > > > Hi fellow mappers, > > I am going to install MapInfo 6.5 on Friday and linking to a remote MS > Access database which is split i.e. there is the .mdb and .mde > parts of the > database. the MapInfo guide and reference do not explain the procedure for > this. Is it a case of copying in the mapcatalogue table created > in the .mdb > into the .mde or is there something more? Do you perhaps have to do the > whole thing twice once in each part of the database? Can this be > done even? > > I would be grateful of any assistance please. > > Cheers Marie > > Miss Marie Lilley > Senior Analyst Programmer > Information Services Division > Town Hall > Room 6 Basement > Knowsley Street > Bury > BL9 0SW > > Tele: 0161 253 5345 > Fax : 0161 253 5070 > > e-mail [EMAIL PROTECTED] > or in case of difficulties please use alternative e-mail address > [EMAIL PROTECTED] > > > > > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > -------------------------------------------------------------------------------------- 1. This message and any files or other attachments transmitted with it is intended for the addressee only. They are private and confidential and are for the sole use of the intended recipient. Copyright in this message and any accompanying document created by us is owned by us. If you are not the intended recipient of this e-mail or any part of it please telephone Head Office at the number shown below or notify us by e-mail at: [EMAIL PROTECTED] You should not use or disclose to any other person the contents of this message or its attachments or files (if any), nor take copies. 2. We have taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses, but we cannot accept any liability for any loss or damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment or file. Please note as well that e-mails can be falsified: in circumstances where the content of this e-mail is important you should not rely on its integrity without checking it by telephone or fax. 3. This message and any files or attachments have been sent to you with the sender's knowledge that the contents may be intercepted, monitored and regulated by us in the course of transmission and in compliance with the Regulation of Investigatory Powers Act 2000. If you reply to this message and/or send a message to us in any other way you accept that the contents, including attachments or files, of that message may be intercepted, monitored and regulated by us in the course of transmission and in compliance with the Regulation of Investigatory Powers Act 2000. If for any reason you do not wish to consent to the above please contact us on the number below. GEOGRAPHERS' A-Z MAP COMPANY LIMITED Fairfield Road Borough Green Sevenoaks Kent TN15 8PP Telephone: 01732 781000 Fax: 01732 780677 -------------------------------------------------------------------------------------- _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
