databases on password protected folders
Does someone have a solution?
Does someone have a solution?
I have the following problem:
Windows XP won't remember passwords (that is the real problem and i know cardbox cannot solve that)
We have databases on a network drive.
Are there workarounds around this?
For example store Folder passwords in macro's or workspaces?
Hope somebody can help.
Open the file by a macro.
Store in the macro something like this (not tested):
Acces is than ok, the file can be openened.
Looking through Google I have come across a couple of ways that this might be done programmatically through a macro.
The key is that if you map a network drive (for example, E: --> \\anothermachine\resourcename) then you are allowed to specify user names and passwords in this process, and the password is then remembered (at least, according to the documentation!) whenever you access that network drive EITHER through the drive letter OR through the resource name..... which sounds exactly what you need.
There is an object called WSHNetwork that you can create from within VBScript, and it has a method called MapNetworkDrive that lets you map the drive and specify a password. You can read a description of it at http://codeproject.com/books/1578701392.asp?df=100&forumid=2007&exp=0 or on Microsoft's own site.
The drawback is that this requires you to have a spare drive letter available and it requires your macro to know which it is (although WSHNetwork has methods that let you discover what drive letters are being mapped). As far as I know, once you have actually opened the file you should be able to unmap the drive letter again.
At the Windows command line, the NET USE command also maps network drives to drive letters, but the drive letter is in this case **optional**, so you don't need to use up a drive letter (or worry about what letters are available to be mapped). You could construct a NET USE command in your macro and use the Run method within VBScript to run that command.
This is all based on a reading of the documentation -- other people here may have practical experience of this.
To be honest, I believe the problem shouldn't exist at all. If you have a network, then there must be someone who acts as an administrator. And he or she should see to it, that shared folders are shared without the need to supply extra passwords, unless there's a very good reason to do so. You haven't told us what kind of network you use, but if you're in a network with a server you log into, then your user credentials should grant you access to the database folder.
Thanks to you all.
(even the one teaching how to do it your way, i will make a study of it)
the databases are on an old windows 98SE computer that has the old fashioned/simple / unsecure (secure enough for us) stucture from shared folders.
Windows XP Home does seem not like this structure and doesn't remember this kind of passwords.
Even mapping the drive in windows XP doesn't help (after restart XP does remember the mapping but forgets the password)
Macro's are maybe the only solution but I find them daunting.
All thanks for the reply.
|© 2010 Cardbox Software Limited|