Ability to use LocalDB with removable disk
Schlagwörter: Files not found;
@xkatMitgliedvor 7 Monate, 4 Wochen
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 ?
@MaurizioKeymastervor 7 Monate, 3 Wochen
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?
- Diese Antwort wurde geändert vor 7 Monate, 3 Wochen von Maurizio.
@fonetvalMitgliedvor 6 Monate, 2 Wochen
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 ???
@xkatMitgliedvor 6 Monate
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
Du musst angemeldet sein, um auf dieses Thema antworten zu können.