June 2025

S M T W T F S
1234567
891011121314
15161718 192021
22232425262728
2930     

Style Credit

Expand Cut Tags

No cut tags
Thursday, May 20th, 2004 06:44 pm
We're currently having joy with a database that's playing up, and the person to blame for credit with creating this has decided to change the way it's set up. Previously, each volunteer had a desktop shortcut to the server copy of the database on their PC (we're ruining Windoze 2K, btw). However, the new cunning plan is to put a front end .mdb on each PC, and replace the current shortcut with the appropriate for the new database.

Copying the .mdb to the individual pcs is no problem (nice shared C: drives, stroke, stroke), but she's in a bit of a quandary with regard to how to be able to manage the shortcut change, without requiring someone to wander around each PC and do it by hand (there are several PCs in Macclesfield and Bristol). If I was going to take the time, I'd use VNC to do it remotely, but I'm not in the office next week (due to the joys of revision).

I've scavved a couple of vb scripts that can create and delete shortcuts on the local PC, but not quite sure how to get them to run remotely on the other PCs. Alternatively, would a simple command line "erase \\machine01\c:\blahblah\desktop\blah.lnk" do the job in a reliable fashion. And would a similar copy instruction do the trick for adding the link (once a sort of template shortcut had been created)?

You see, I truly know nothing! And I'm tired.
Thursday, May 20th, 2004 10:52 am (UTC)
*hugs* because there were whole swathes of that I didn't even understand at all.

You're clever, you'll work it out. And on Sunday there's a picnic and I will feed you chicken.
Thursday, May 20th, 2004 12:00 pm (UTC)
Yeah, Windows shortcuts are just .lnk files, you can copy/delete them from the command line no problem. Presumably you can create them with VB.
Thursday, May 20th, 2004 01:04 pm (UTC)
it has vbeen awhile since I used accss, but when i did it, i put an executable only fromt end on the pc (i think they are mdx files) linking it to a mdb on the back end which contained all the data (it makes change maangement easier and gives youa bit of security0, but just linked the tables in the back end system to the front end, hence no need for shortcuts at all. Or am i missing something here.