ODBC Error

[Louise Kavanagh]

Dear All,

 

I am using ODBC to connect to a MS Access database.  I am a complete novice in using external databases in MapInfo in this way so apologies for possibly very basic questions but any advice gratefully received!

 

When I attempt to open the live table I get the following error:

 

 

The size of the database is approximately 35MB and the table I am attempting to open has approximately 80,000 records.  Therefore I don’t think the query size can be larger than 2GB – can it?!  I also have plenty of temporary storage space so not sure why I am getting this error.

 

If I link to the table then it opens up without a problem. What are the advantages or disadvantages of only linking to a table?

 

Finally, ultimately this database will be placed on a centralised location with multiple users accessing and editing the table.  If the table is only linked what issues may arise?

 

Thanks in advance for your help!

 

Best wishes,

Louise

 

Louise Kavanagh

Managing Director

 

 

  |  louise....@apogeedata.co.uk | +44 (0)7736 438822 | Subscribe

 

 

 

[Peter Horne]

Hi Louise,

can't comment on the error message, your information seems to indicate that  file size, storage space should not be an issue.

My advice regarding Live Vs Linked is that unless you ABSOLUTELY need live data, then opt for linked tables. There have been a lot of posts over time regarding this issue. Attached link is just one of them.  https://groups.google.com/g/mapinfo-l/c/ZAQI45P3Tpg/m/866n6ddZBQAJ.

If you search the MAPINFO L for linked tables, live tables OBDC, etc you will  find many more posts that will go a long way to answering your querys.

hope that helps some what.

Thanks
peter h

[Martin Hodder]

Hi Louise,

 

The error seems to indicate you are trying to open a query. If that is right then when the error appears - have a look in you user temp folder and see if there is a file there that is 2GB.

 

I have come across this issue in the past and it seems to me that the Jet engine used by ODBC does a full table join first of all and then filters from this joined query. So even if the result is just a few rows it still does the full table join. A quick scan of the temp folder will reveal if that is the case.

 

You might be able to get around it by linking to the tables that make up the query and then using the SQL in MI to filter out the rows.

 

Regards

 

Martin Hodder

Higher Mapping Solutions

www.highermappingsolutions.com

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/008901d921c6%24d919acc0%248b4d0640%24%40apogeedata.co.uk.

[Louise Kavanagh]

Thanks Peter – I’ll take a look.

--

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/09200568-1bad-404a-a80e-e24c6358e7fcn%40googlegroups.com.