Hyperlinks getting #deleted unable to edit record afterwards

[Robyn_P]

Hello,I don't know if anyone can help, I've got a weird bug that I can't reproduce and am looking for pointers on getting started.

I have a form with a field called txtDirectory. This is a text box with isHyperlink set to Yes. It is a bound form, bound to a textfield called Directory in the underlying table. It's a text field not a hyperlink field because I find them easier to work with.

This form allows you to change the status of a task, and when you do it moves the directory to a new location and updates the hyperlink. 99% of the time it works fine and in my attempts to recreate the problem have all failed. Occasionally (it's happened about 6 times for users), when they update the item's details and then click the link (I'm not sure it's always after clicking the link), the link disappears and changes to #deleted. From here there is no way for me to restore the information except going into the back end, copying the whole record, making a copy of it, deleting the original and then putting back in the corrected hyperlink.


I thought this may be due to long file names, maybe an edge case where it was less than 237 characters (max length mkdir) when the file was created but just over this when the directory was moved, but the directory paths affected are much shorter than this. I've also wondered if it may be due to a document in the drive being open at the time but I've tested that with an open Word document and it causes no problem (Strangely it allows me to move the directory even though the document is open, which I also find odd)

Any ideas?



Robyn

[Robyn_P]

From an extensive Google search, I've not found anything concrete, but one post suggested this could be a sign of database corruption and to compact and repair. I do this often, but have never thought before. Does a compact and repair effect a linked back end or do I have to go into the back end directly and do it there too?

[June7]

Although corruption on BE would probably mean unrecoverable loss of data, C&R can sometimes reduce file size.

Would have to review code and maybe even db to analyze issue.

[Robyn_P]

Thanks, It's a pain posting code on this computer but I'll try. Essentially it's these few lines, everything before this is just string manipulation

        newLoc = Replace(currentPath, findstring, replacestring, , , vbTextCompare) 

               'Move the folder - In the real code there are checks before this to check the original folder exists and the new one doesn't already exist
       fso.MoveFolder Source:=FromPath, Destination:=ToPath
                ' Update the hyperlink stored in the database
        ' The Move_Rename_Folder command strips off the trailing "\", put it back on.  
      If Right(newLoc, 1)  "\" Then newLoc = newLoc & "\" 
       Me.ACS_Dir = newLoc
   End If   

     'Save the record
     If Me.Dirty Then Me.Dirty = False

Our IM security settings won't let me upload the database, Christ, they don't even let me format text! But thanks for the offer.

[June7]

CODE tag should be forward slash /.

Looks like missing <> sign

If Right(newLoc, 1) <> "\"

However, would expect a compile error and code not run at all.

Take file home and upload?

[Robyn_P]

Woohoo, silly Robyn on the code tags. Thank-you. Also good spot, that's a direct copy of the code, so when I get a second, I'll look at that. Thanks for your input