Solved

Login dialog box on creation of new DB?

Posted on 2004-09-28
5
215 Views
Last Modified: 2006-11-17
Hello, experts,
    I'm on a new PC in a new company and am running into something I've never seen before.  The OS is Win2K, Access version is Access2K.

I start Access, then cancel out of the open dialog box.  I click on the New DB button on the toolbar and try to create a vanillia flavored DB in My Documents  (db1.mdb).  When I click the create button a Login dialog box appears.  It puts my user name in the Name: field and then asks me to enter the password.  The title in the title bar is simply "Logon".  I haven't a  clue as to what is going on.  I already have administrator rights on this PC.

RichNH
0
Comment
Question by:RichNH
  • 3
5 Comments
 
LVL 8

Accepted Solution

by:
JonoBB earned 125 total points
ID: 12170389
Can it be that your pc is connecting to an access workgroup file?

Go to C:\Program Files\Microsoft Office\Office and run the file called MS Access Workgroup Administrator

This should tell you if are connected or not...
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12170395
Sounds like the user profile on that PC has joined a different workgroup.

Check on a PC that does not exhibit this behaviour - go to Tools->Security->Workgroup Administrator. Check what the workgroup file is. On your PC, go to Workgroup Administrator, click Join and join the same workgroup file. If the files are the same and local to your hard drive (and called something like System.mdw), someone may have altered the workgroup on your PC to include user groups - in which case, just delete it and Access will recreate it when you log in. Make a copy of the file before you delete it though!
0
 
LVL 1

Author Comment

by:RichNH
ID: 12171748
JonoBB, I found the shortcut you referred to, when I run it it shows me a dialog box that has Name & Company blank with the Workgroup set at C:\PROGRA~1\COMMON~1\System\SYSTEM.MDW.  There's this paragraph that explains my options.  I have three options available to me, Create, Join or Exit.

So I should rename this system.mdw file and then reboot?

RichNH
0
 
LVL 8

Expert Comment

by:JonoBB
ID: 12171826
Yup, try that and see what happens
0
 
LVL 8

Expert Comment

by:JonoBB
ID: 12171843
You should probably Exit as well...otherwise its going to look for the system.mdw file that isnt there anymore
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now