Thanks
Teri
You can split your database into multiple databases of a
few tables each and then link all of them into one front-
end database.
(File|Get External Data|Link Tables)
hth
chas
>.
>
2 Gb is very large. Do you have a lot of images? You don't want to
embed graphics into a table as this causes significantly bloating of
the database. Frequently about one Mb per graphic.
For more info see the Image Handling Tips page at my website.
http:\\www.granite.ab.ca\access\imagehandling.htm
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm