11-05-2012 04:46 PM
If I look in TBL_ATTACHMENT.FILENAME I can see the filename, however, TBL_ATTACHMENT.FILEPATH doesn't show me the path. Yet when I hover over attachments, a tooltip pops up showing me a path, i.e. C:\ACT\Databases\TESTDB-database files\Attachments\xyz.pdf
Where is this path kept in the db?
11-05-2012 04:47 PM
11-05-2012 05:16 PM
Normally, yes. (to my knowledge anyway).
However, a client has upgraded, and changed from having the database on C: to having it on P:
Now, attachments prior to the move don't open up, and hovering over the attachments shows a C:\ path where as attachments added after the move show P:\ and do open up.
So I was wondering where this path is kept....
11-05-2012 05:47 PM
11-05-2012 05:50 PM
11-05-2012 06:15 PM
Look for the Supplemental File Location in CTL_DBCONFIG (DATASTORE > ROOT)
11-12-2012 10:37 PM
So, back with this client today.
Indeed, the supplemental files value is set to C:\ACT\Databases\TESTDB-database files rather than P:\ACT\Databases\TESTDB-database files
I'm assuming I can safely just edit that value? (i.e. it should work).
05-27-2013 07:18 PM