Junction Points?

Topic

New Reply

Here at work our sales force uses a home grown sales application written preVISTA, that gets installed at C:PROGRAM FILESapplication. The database is in a folder named DATA under application. At least when using XP that’s where it’s stored. Now, after a new install under 7, and running it the first time, the actual db gets saved to C:UsersuserAppDataLocalVirtualStoreProgram FilesapplicationData. There are db utilities that wont work because of this, and it’s caused me a great deal of frustration the last two days as it’s the first I realized it. The application works fine until we try to use one of the utilities or have to move the db to a new machine. (my ‘ah ha’ moment)

I will mention that the person before me whose position I filled a few short months ago had a solution for this. But of course it’s not documented anywhere.

How can I stop the OS from moving the data base? Thanks, I appreciate any help I can get.

Reply | Quote

Replies

Apparently this had nothing to do with junction points. Disabled UAC (User Account Control) and it works as it should. Imagine that…

Reply | Quote

Be aware that putting data files into “Program Files” or “Program Files (x86)” is not a good idea with Windows 7 and later. You will almost surely have to modify the security attributes to allow users permission to make modifications.

Joe

--Joe

Reply | Quote

One way to get around the problem is to leave the DATA in the folder C:UsersuserAppDataLocalVirtualStoreProgram FilesapplicationDATA and create a symbolic link to it in C:PROGRAM FILESapplication.
To do this, open a command prompt as an Administrator, make sure that you do not already have a directory called
C:PROGRAM FILESapplicationDATA then:
CD C:PROGRAM FILESapplication
mklink /d DATA C:UsersuserAppDataLocalVirtualStoreProgram FilesapplicationDATA

Because the directory C:UsersuserAppDataLocalVirtualStoreProgram FilesapplicationDATA can be modified by the user you can leave the UAC properly enabled protecting the user from bad behaviour.

Reply | Quote