Re: Blob in Access

(PeteCresswell) wrote:
Per Tony Toews [MVP]:
I've been meaning to write a simple routine that
1) clears a flag on the document table
2) runs down each file mentioned in the document table verifying
that it exists on the hard drive.
2a) It might be nice to store date/time and size of file to see if
there were any changes since the time the file was initially saved
3) display any that are missed.

Then do the same thing the other way. Go down the list of files
looking for the file in the table.

That seems to address the original question to some degree:
sounds like even the stars store their docs in the file system
rather than JET....

How about SQL Server? Same deal? Or is it workable?

Related story: at a client site I interface some Access systems with a doc
mgmt system from Hummingbird - now owned by OpenText I believe. It uses a
document metadata library hosted in SQL Server (Oracle option), but the
documents themselves are renamed/obfuscated - Certificate of Occupancy.doc
becomes A451O3 - and stored on the server file system.


I've got an agenda here.... got my guys talked into moving to SQL
Server if testing shows a performance increase and I'm wondering
if I should change my document storage strategy.



.

Relevant Pages

  • Re: Blob in Access
    ... clears a flag on the document table ... runs down each file mentioned in the document table verifying that it exists on ... 2a) It might be nice to store date/time and size of file to see if there were any ... How about SQL Server? ...
    (comp.databases.ms-access)
  • Re: commiting the transaction log?
    ... How much data is stored in memory ... As long as SQL Server has a file open for a long time, ... Is that the reason for the log file (in the file system) having time ... But even if I run the FULL backup, and then the T-log backup, I can see ...
    (microsoft.public.sqlserver.server)
  • Re: Atachments in File System
    ... If you can afford MOSS 2007 you can afford to use SQL Server. ... If you are looking for the cheapest solution, use WSS 3.0 with its built-in ... I think he wants MOSS 2007 to store attachments in the file system - ...
    (microsoft.public.sharepoint.portalserver)
  • Re: FTS and PDFs in row
    ... and the reference the file in the file system and extract its ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... I've read here and there that storing PDFs in row is frowned upon, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Blob in Access
    ... runs down each file mentioned in the document table verifying ... 2a) It might be nice to store date/time and size of file to see if ... I did one application where the attachments table did originally ... The DBA admin at work won't allow blobs in SQL Server. ...
    (comp.databases.ms-access)