I've asked this before, but haven't gotten a reason for
why this happens:
I upsize my AXP tables (no data transfer) to sql server
2000. I create the DSN to point to the sql server...do
the get external data, link tables...I link about 40
tables...
with just those link tables, my MDB file is almost 1MB.
Whereas if I did the same linking with the same Access
tables (before upsizing), it's less than 150KB.
Why is there such a disparity in the size? Other people
said they don't run into this, so why am I?
Does it matter if the sql tables were upsized from access
tables, vs being created from scratch?
That's the issue, I can't seem to think there is anything
in the file except the linked tables. I did the upsizing
without the data, using the wizard. So the SQL tables
don't have any data in them. I created a new MDB file from
scratch. Did the linking to the sql tables and that's
it. No forms/queries or anything more.
1MB is big for just linked tables, right?
Would having one-many relationships increase the size? Or
indexes (but the only indexes are the Primary keys)?
I've done this over and over and get the same results.
Didn't think it was that difficult to do.
I just want to keep the size of my FE to a minimum. Just
wanted to see why the size does increase so much with sql
linked tables and not with mdb linked tables. If that's
by design, then so be it.
I do care a bit because if my FE gets too big, it could
slow things down for users.
Ngan
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.