GG asked ... Fix food processor motor?    |    T asked ... How do I turn the delay off on Electrolux DX302 dishwasher?    |    Helen asked ... How can I mend my Kenwood Gourmet FP505?    |    Roy Turner asked ... Kohlangaz Gosford HE fire?    |    Peter asked ... How can I mend a Powerwasher PRO PRO1800PWE?    |    Click here to ask your question

I am unable to open any data base in Access 2003?

I am unable to open any data base in Access. Even when trying to start a new database. A subwindow opens with my user name and a place for a password. The data base I am trying to open is not password protected. When trying to start a new database the same subwindow with user name filled in and asking for a password. I have not password protected anything on this computer.
The same file opens correctly on another computer.
AJ Fate, January 2009
To the best of your knowledge are the databases you used administered by someone who may have set up user group security? the reason I ask is that you may have had security set up before for another database, this security would then have been saved to your workgroup information file (this is a file that access creates the first time you open it) once user group security has been set up by a database administrator the details of your permissions e.t.c. are strored in this file, everytime you start access and try to open or create a new database access will look to this file for security details.

When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros. By using passwords and permissions (permissions: A set of attributes that specifies what kind of access a user has to data or objects in a database.), you can allow or restrict the access of individuals, or groups of individuals, to the objects in your database. Security accounts define the users and groups of users allowed access to the objects in your database. This information, known as a workgroup (workgroup: A group of users in a multiuser environment who share data and the same workgroup information file.), is stored in a workgroup information file (workgroup information file: A file that Access reads at startup that contains information about the users in a workgroup. This information includes users' account names, their passwords, and the groups of which they are members.)if you have not assigned a new workgroup that you control, then access will look to the default workgroup information file.

J Moore, July 2009