Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Database size

0 views
Skip to first unread message

@boeing.com > <joe.l.bingham <remove this>

unread,
Aug 23, 2005, 9:11:07 AM8/23/05
to
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

Sharkbyte

unread,
Aug 23, 2005, 9:47:12 AM8/23/05
to
Why not link to the .pdf rather than storing it in the db?

Sharkbyte

Chaim

unread,
Aug 23, 2005, 10:16:05 AM8/23/05
to
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?

--
----
Chaim
"Joe @ boeing.com>" <joe.l.bingham <remove this> wrote in message
news:630758F0-6F21-4713...@microsoft.com...

0 new messages