First make several copies of the database file, then build another database
and move about half the data to it, then compact both of them.
Now you can breathe.
You can link the Excel files by simply storing the path to them. Have a look
at my database DogMgr:
http://www.datastrat.com/Download/DocMgr_2K.zip
which will catalog the paths to Excel, Word, and text files. You can then
limit the files by either changing the code, running a query, and/or
deleting the data you don't want.
You can use a hyperlink as shown by using a label as a hyperlink and
grabbing the filepath with something simple like:
Me![txtPath] = Me![FilePath] & Me![FileName]
Me.lblPath.HyperlinkAddress = Me.txtPath
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9608
After doing this, you'll find that your database is probably less than
1/1000 the size.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com http://www.mvps.org/access
"Jurrasicway"
wrote in message
news:4861F929-C43A-46C5-8FAE-D1C38B0EAEBA@microsoft.com...
> Hi,
>
> I have created a database that records visists to stores and also the
Excel
> document/report completed at the visit is linked in an OLE field in each
> record. After linking/attaching 400 of these my database started to creak
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9608
> because it was 2GB. What is the best way to solve this problem? Does a
> hyperlink field take up as much space or is it better to split my
databases?
>
> Any help would be much appreciated.
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
