Database size

[Landor]

I understand the maximum data storage size for Access 2007 is 2GB. I have a
database to store video clips, photographs and sound as you can imagine this
will seriously limit the amount of data I can store on my database.

Does anyone have any suggestions as to how I can save more data on my
database?

cheers

Landor

 

[Daniel Pineault]

Do not embed the files into the database itself but rather only add the
path/filename in the database (as was the technique for database prior to
2007)

For the latter see:

http://www.microsoft.com/office/com...&p=1&tid=f60acaa6-7cb0-4992-a3b6-dcc3b7c88661
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[Landor]

Many thanks Daniel.

Do not embed the files into the database itself but rather only add the
path/filename in the database (as was the technique for database prior to
2007)

For the latter see:

http://www.microsoft.com/office/com...&p=1&tid=f60acaa6-7cb0-4992-a3b6-dcc3b7c88661
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.