Solved

Login dialog box on creation of new DB?

Posted on 2004-09-28
5
217 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

840 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