Hi, i've googled and found out that the max storage of MS Access 2007 is ~2GB. My database suppport attachment, so hypothetically, if the attachments after insert >2GB, how can I allocate more storage to the db? is there a way?
isumasama
0
Newbie Poster
timothybard
12
Posting Whiz
One possibility is to not store the attachments in the database, but rather save them in a specific directory and only store the location and filename of the attachment in the database. When you need to access the attachment, have the database look up the location of the file and open it directly instead of from within the database.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.