Phantom request for username and password.

[Glen]

Let me start by saing that my knowledge of networking is very basic. Another
IT person setup Windows Server 2008. The server allows remote access to
Access databases. There are 20 users at this time. Two of the users have
started experiencing an "odd" problem.

In the beginning they had no problem logging on and clicking on a desktop
shortcut to start up a non-password protected database. Now when they log on
and click on the shortcut it requires a username and password. I can log on
remotely... go to their desktop and click on the shortcut without any prompts.

The IT person is certain it is a database problem... as to be expected I'm
not convinced. HELP!

 

[Jeanette Cunningham]

I have a client running a database on Windows Server 2008.
This database is not password protected and none of the users are prompted
to enter a password.
My client runs an IT business and in a past life developed access databases.

In your case, if the database is not password protected, they will not need
a password to open the database.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tom Wickerath]

Hi Glen,

The symptoms you describe sound to me like these two users are joined to a
non-default workgroup file, or this file, System.mdw, has somehow been edited
to require a username and password. When you log on remotely, are you logged
in as one of these two users, or are you logged in as yourself? I suspect you
are logged in as yourself, and your copy of Access is properly joined to
System.mdw.

Have these users open any other .mdb file, such as the sample Northwind.mdb,
or create a new database. Are they receiving the security prompts when they
do this? If your answer is "yes", have these users close Access and search
their hard drives for "System.mdw". When they find it, have them rename it as
System.mdw.old. If you are running Access 2002, 2003 or 2007 (with a .mdb
file), the default System.mdw file should get re-created automatically, if
Access does not find it during startup.

You can also open Access, press <Ctrl><G> to open the Immediate Window, and
then issue this command:

? application.DBEngine.SystemDB

You should see something like this:

C:\Program Files\Microsoft Office 2000\Office\SYSTEM.MDW

The server allows remote access to Access databases.

Hopefully, you are running split applications, so that a given database is
split into two databases: a "back-end" (BE) data database, and a "front-end"
(FE) application database. Each user *should* be running their own local copy
of the FE file (.mdb/.mde or .accdb/.accde) that is located on their local
hard drive, such that no two users can ever be running the same copy of the
FE file:

Split the Database
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________