This might be a difficlt question to answer without seeing the layout of my tables. But, I will give this a try and hopefully some basic suggestions will help. I am importing quite a bit of data into an Access 2007 database through ODBC and after about 250 MB of data is imported my ODBC connection times out. I suspect that this has to do with Access, but it could be the ODBC connection.
What can I do to improve performance with the Access 2007 database and/or ODBC connection? I do have indexes and the tables are linked together by ID (if that helps).