I have a Ms Access database which is not so big. But now I am attaching a PDF file around 60 or 70 kb file to each Record in the database.
My question is makes any problem to the database?
Four answers:
Capt Crasher
2010-12-20 08:19:55 UTC
As long as Your attaching via "Hyperlink" field You will be fine. The "Hyperlink" is really just the network Path to the object. I havn't worked with 2010 yet, but previous versions won't store actual files internally, hence the need for "hyperlinks".
If You CAN store the PDFs in the DB itself, Be aware of the 2GB limit. The DB itself (Forms, Queries, Tables, Reports, Scripts, Data all combined) cannot exceed 2GB. LINKING to tables/files is the only way to get around it.
2010-12-18 19:42:43 UTC
Yes. Store the location and name of the pdf file in the database. Store the file on the hard drive.
2010-12-22 17:27:12 UTC
MS Access 2007 and 2010 have new Attachment feature and amazingly can reduce any file size significantly.
pafel
2016-12-13 18:08:25 UTC
it really is unusual. i have not had that ensue earlier. have you ever tried the "restore" function contained in the database? If that doesn't paintings, have you ever tried arising a sparkling table contained in the "Tables" section and then arising a sparkling one-to-one courting? Are you utilising subforms?
ⓘ
This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.