Database size

[Guest]

I'm creating a database that has ~500 records in several different tables,
each record having a PDF document attached to it as an OLE Object. The
database is nearly 2 gB and will most likely be around 6gB when finished. I
know the max .mdb file size is around 2gB so I am getting worried.

Is there a way to split a table up into several different .mdb files, but
still have them act as one 'virtual' table? (that can be searched by a single
form)

Thanks in advance,
Joe

 

[Guest]

Why not link to the .pdf rather than storing it in the db?

Sharkbyte

 

[Chaim]

A table column can be referenced as Database.Table.Column. So, although I
have never had to split a database in this fashion, the individual tables
can be referenced this way.

Is it necessary to store the entire document in the table? How about storing
a reference/hyperlink to the document and storing the physical document in
the file system?