Saving OLE Objects to SQL Sever table takes a long time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It takes five minutes when using object linking and embedding on a normal
form to save a record that contains a PDF file. The data type is image in an
SQL Sever table.

We are trying to keep track of the legal documents that we have purchased.
Is their a better technique to use, rather saving the PDF file .
Could we save the path to a text or varchar datatype.
 
so use SQL Server instead of MS Access

seriously

load it from the SQL Server side instead of the desktop--
and just use Access Data Projects

MDB is obsolete, completely
 
you could save the path and keep the file out of the database

where are you trying to use this on a webpage?
in a Access VBA form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

downloading OLE Object /BLOB data (.doc/.xls files) from SQL Server table to local machine through M 10
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
"OutputTo" an OLE Object in a table 1
How to display OLE Object (e.g. Word Doc) on form 1
Save files on SQL 2008. Need advice 3
Problems linking an OLE object to a form 1
save OLE Object to a file 1
OLE Object Data Type Question 8

Back
Top