Linking to SQL tables

[Ngan Bui]

I have a Access XP mdb file. I went ahead and linked to
the SQL tables via a DSN connection (dbo_tablename).
After compacting the mdb file that only has the linked
tables, the size of that file was 1.3MB.

If I do the same linking, but to a mdb file, the size of
the file is 135k.

The sql link tables was 10x the size of the access link
tables. Why is that? Any way around it?

 

[Ngan Bui]

Well, I did an upsize wizard on the tables, but told it to
not bring over the data. So my SQL tables doesn't even
have data in them.

I created a File DSN that connects to the SQL database
(operations.dsn). Then, I created a new database (mdb).
I went to File | Get External Data | Linked Tables. File
Type is ODBC databases and choose the operations.dsn.

It gives me a list of tables and I choose them all.
Afterwards, I compacted the database and the size is
1.3MB. All the link tables start with "dbo_".

If i delete one of the tables, it would say that i'm
deleting a linked table.

Am I doing something wrong?

I have Access XP with SQL 2k.
Ngan

 

[GVaught]

Did you link in the standard system database table files from SQL Server or
just the same tables you use to have in the mdb?
This might be part of the explanation for the different sizing. Speculation,
not scientific fact.

 

[Ngan Bui]

What do you mean by "standard system database table files
from SQL" ?

I upsized the tables from a mdb file. So the original
tables were created in .mdb. Are you suggesting I create
the tables from scratch within SQL server?

If so, why would the upsizing not do the linking properly?

Thanks.
Ngan