Database size using linked tables?

S

SirPoonga

I have a FE that links to several tables in different databases as part
of a project to import data from a mainframe. I have the code to
import in this database. Why does this database file size change when
the data is going into the linked tables? Before import the database
was 20megs. After it was 2 gigs. And now I am trying to compact and
repair but I get the error "Invalid argument".
 
G

George Nicholson

Are you creating any temp tables in "CurrentDB" for some sort of interim
data transfer step? That could be one cause.
 
S

SirPoonga

Nope, everything should be going straight to the linked tables.
There's only a couple of table in the main database that are just look
up tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to a mainframe database 10
Linked Table Manager Errors 12
linking tables and relationships 3
Size of database 6
Linking Forms 6
2 gb limit and linked tables 2
Database file size and linked tables.... 4
Building a database with multiple linked tables from other databas 2

Top