Saving OLE Objects to SQL Sever table takes a long time

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.
 
A

Aaron Kempf

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
 
A

Aaron Kempf

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
downloading OLE Object /BLOB data (.doc/.xls files) from SQL Server table to local machine through M 10
Save takes long time 2
Access: Opening a file path stored in a text field from a form? 6
print embedded multiple page OLE objects 1
Saving form takes a long time 4
Form takes a long time to open 2
saving page locally takes long time 7

Top