Access 97 Secure App in XP OS

[Guest]

Some years back I created a secure database application in Access 97.
It is on a network drive and users have had NT as their OS.

We decided to enter the 21st century and upgrade our OS to XP. To access
the database, users must click on a shortcut and enter their username
and password. When they do so they get an error and it will not open.

Does the shortcut have to be reconfigured in some way for it to work? Is
the C: drive path in the shortcut still:
C:\Program Files\Microsoft Office\Office\MSACCESS.EXE?
Thanks
Steve B.

 

[Joan Wild]

What error message do they get?

The shortcut shouldn't need changing unless the network setup changed.

 

[Guest]

The login window re-appears with their network context before their user name.

So if the user name is:
Admin3

The login window reappears with:
PARKNET-NT\Admin3

The window just keeps re-appearing and the DB nver opens.

 

[Joan Wild]

Are you talking about the Access login dialog or a windows dialog?

Did you upgrade the server OS, or just clients?

 

[Guest]

The Access login. As far as the server, it has not changed. It is the
client that is being upgraded.

 

[Joan Wild]

If I understand you, the Access login shows up with their network login
name. Just change that to their Access login name, enter the password -
does that not work?

The first time you open a secured Access mdb on a computer, it will populate
the username with the network name (and since you upgraded the OS, this is
considered the first time).

 

[hireagenius via AccessMonster.com]

Steven B,
The complete shortcut should be as follows:
"path to msaccess.exe" "path to your database" wrkgrp/ "path to your
workgroup file"

Include the quotations'

for example
"C:\Program Files\Office\Office11\MSACESS.EXE "
"C:\MyDocuments\MyDatabase.mdb"
/wrkgrp "C:\MyDocuments\MySecureWorkGroup.mdw"

Charlie Horse

 

[Guest]

Good morning Joan!
Anyway, the Admin3 is the User Name. PARKNET-NT is not a user name, it is
their network context. It is like the area of the network they can access (I
believe!).

So normally I put in the User Name Admin3 and then the password and it opens
fine. Now with XP as the OS, I put in the User Name Admin3, then the
password, hit enter and then the login prompt comes back with
PARKNET-NT\Admin3 in the User Name field.
Thanks
Steve B.

 

[Joan Wild]

Good morning Joan!
Anyway, the Admin3 is the User Name. PARKNET-NT is not a user name,
it is their network context. It is like the area of the network they
can access (I believe!).

But isn't Admin3 their network login name?