linking tables

J

Judy

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.
 
6

'69 Camaro

Hi, Judy.
Currently I
have several imported tables and I have exceeded the 2 gb limitation.
Click to expand...

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.)


Judy said:
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
Click to expand...
linked.
 
D

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)


Judy said:
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
Click to expand...
linked.
 
Top