Well, an mdb file cannot exceed 2 gigabytes - so it looks like that is your problem. Have you tried compacting the database?
You might find it best to store a path (as text) to the PDF file rather than link it, and write code to open the requested file via FollowHyperLink or similar method. When you link an OLE object, Access stores a "thumbnail" of the object as a bitmap - and that takes up a ton of space. If you embed the file, it's even worse. Good luck, John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: ms_access@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of schuh_ramos > Sent: Tuesday, May 03, 2005 4:59 PM > To: ms_access@yahoogroups.com > Subject: [ms_access] linking pdf files to a table troubles > > > I have been linking pdf files to a table and having no problem. I am > using the ole object. Now I keep getting an error message of invalid > argument, will not let me save my record and closes out the > table. My > mdb is 2,095,108 kilobytes. Can anyone tell me what the > problem might > be? I have the files on a cd and have tried linking them and have > also tried to link the file from my hard drive. Neither one > works. I > also went into my form with the attached table and it did the same > thing. > > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
