linking tables

[Guest]

If a table is linked vs imported is the size of the database less Currently I
have several imported tables and I have exceeded the 2 gb limitation. I am
wondering if the size of the database is decreased if the tables are linked.

 

['69 Camaro]

Hi, Judy.

Currently I
have several imported tables and I have exceeded the 2 gb limitation.

Export some of the tables to another database if you can, then compact the
other database, then link to those tables, then compact the current
database. The new size of the database will be smaller, but not necessarily
2 GB less the size of the exported tables, unless to the original database
was already compacted to begin with.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

If a table is linked vs imported is the size of the database less Currently I
have several imported tables and I have exceeded the 2 gb limitation. I am
wondering if the size of the database is decreased if the tables are

linked.

 

[Douglas J. Steele]

Definitely.

Linking to a table simply puts a pointer in your front-end database, which
adds virtually nothing to its size.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

If a table is linked vs imported is the size of the database less Currently I
have several imported tables and I have exceeded the 2 gb limitation. I am
wondering if the size of the database is decreased if the tables are

linked.