We use a 3D program that uses access for it's data base. For reasons I have yet to figure out when the data base is accessed tables are creted called "at_(random number)". For example at_31789. These tables sometimes contain no information or duplicate information of other tables. How can I prevent this from happening and what causes this?

Mickey :rolleyes:

The only way to answer this is to find the part of the code that creates the table. Access doesn't create a table just on a whim. It does so 'cause some piece of code told it to do that.

The good news: You can look for this pretty easily. Search your SQL strings to see if any of them are going to create a table. If not, then you must look in the code. Look for something that manipulates TableDef objects and does a .AddNew to that object.

Somewhere in there is your culprit.