Large Application - Many Tables

A

Alex Lifeson

I have a "large" financial application (Stocks and Mutual Funds). There
are approx 6400 tables and it is ~700Mb in size. It imports many csv
files and does some other table writes. It runs on an XP Home machine
running Office 2000.

The app is a one time run to process weekly data. The app ran fine when
we were running with approx 1/2 the number of stocks and Mutual funds.

Now that we have increased the number of symbols, I get weird messages
saying it can't find tables (that exist) and that tables are opened
exclusively by another process. It is a single user app. We let it run
and come back an hour and a half later. There are no other users or
processes.

I don't use any Transactions, but it is almost like I need a "commit" or
an update of the user tables in the catalog or change an Access setting?

Any thoughts or suggestions?

Thanks in advance.
 
J

Jeff Boyce

Alex

A database, Access or otherwise, with over 6,000 tables in it sounds
unusual. I've run across applications that had over 100 tables, but 6K+?

If you'll provide a bit more explanation about what entities those tables
represent, and what kind of data you are storing about the entities (not all
of them, please!), the newsgroup may be able to offer more specific
suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top