Ability to use LocalDB with removable disk
Tagged: Files not found;
@xkatMember3 months, 3 weeks ago
Hi all: after buying and using the LAN version (3 machines, only 1 used at a time) for some years, i decided that i needed a portable solution that didn’t depend on the unique disc #.
Still, the issue i am confronting is regarding the machinename.
My data location, on any machine, is the portable drive @ A:\AARCHIVE
Is it possible to subvert the machinename so one doesn’t need to do “rename” query every time one uses a different machine with this set-up?
i did notice that when i choose DISK INFO (ADVANCED > See which disk contains this file) that “Computer name (optional)” is part of the identification.
Does that mean that [machinename] can actually be eliminated?
. . . or . . ‘NULL’ ed ?
@MaurizioKeymaster3 months, 2 weeks ago
xkat, sorry, I don’t know what you are talking about. 🙂
unlike tabbles 3, tabbles 4 does not use the unique disk id anymore. it uses paths. in the database, you will have the path A:\foo\bar
so where’s the problem?
- This reply was modified 3 months, 2 weeks ago by Maurizio.
@fonetvalMember2 months, 1 week ago
I have just sent a similar message (just before browsing the forum : sorry 🙁 ) about a “similar” problem.
I think that the feature of tabbles4 doesn’t do the job on disconneced (but mapped as a local drive letter at file tagging time) volumes.
In my case, it’s a network installation of only 2 computers (sql server express on a lan machine to which my other computer is connected).
I’ve make a screenshot to explain (here)The test is the same with a removable media or a local drive of a other machine than the one on wich Tabbles is used : the drive letter isn’t “linked” with the machine name (or volume name for removable media) on which the file is: in both case, it’s the machine name on which I use Tabbles that is displayed as part of the “location attribute” that Tables uses.
Sorry if there is something I didn’t understand, but : how can I use Tabbles on multiples computers if the centralize database doesn’t identified them in a unique manner ???
@xkatMember1 month, 3 weeks ago
Hi, Maurizio — thanks for your reply
That’s why i put all my data on a portable drive with PATH:
*Note that my test machine is: “DV7” and the TABBLES database lists files from 3 machines, DV7, Giga2500K, BlueTurtle – all files were resident on the same (single disk id) portable drive, merely ‘referred to’ by different drive letters when used separately on different machines, not networked.
the problem i experience is that the files are listed by different machinename in the TABBLES4 db and cannot be updated in the interface
SELECT [id],[path],[isDir],[machineName],[idTaggable],[idOrganization] FROM [tabbles4].[dbo].[file2] *,A:\AARCHIVE\6\610\Inspection of foods, medicines.mht,*,DV7,*,* *,L:\AARCHIVE\6\614\Sanitary Inspection and control.mht,*,Giga2500K,*,*
Procedure using the TABBLES interface:
Search (Ctrl F) for “food” > several files are listed (with associated tag: Nutirition)
(File view NORMAL, with tags, folders, thumbnails]
A:\AARCHIVE\6\610\Inspection of foods, medicines.mht (the 'lost' file) "-" L:\AARCHIVE\6\614\Sanitary Inspection and control.mht
then: right-click > “Locate in windows explorer” > “Specify current location”,
and successfully “Files Found:” > “Update the tags to point to . . . ”
“Info – files were found and . . . ”
Close interface; repeat search; file still shows previous location “L:\”
and has not been updated.
Curiously, right-clicking “Info” when hovering over ‘lost’ filename shows ‘date mod:’ and ‘size:’ are empty, but “Computer: DV7” even though the db always lists machinename: Giga2500K
You must be logged in to reply to this topic.