For some reason when i try and create a new MS Access database(.mdb), i get prompted for a login/password even if the database isn't protected. Any ideas as to how to get rid of this? Note i'm using MS Access 2007. I tried to add a password to database by going into "Database Tools", "User and Group Accounts", "Change Logon Password".
A:
Is the Access database connected/linked to other (for instance SQL) databases?
rdkleine
2010-06-21 14:46:05
not it's not linked to any other database, i'm trying to create a from a blank database. I tried to add a password to database and from then on, it's started prompting me to enter a password. I've edited my response to show what i did.
Kojof
2010-06-21 14:56:09
+2
A:
Did someone make changes to system.mdw? What, if anything, is returned if you paste this:
?CurrentProject.Connection.Properties("Jet OLEDB:System database")
Into the immediate window?
Response to recent edit:
Using the above line, you can find the system.mdw. If you delete it, it will be recreated, but be careful, because you could lose your ability to access some mdbs, depending on exactly what you did.
Remou
2010-06-21 14:57:18
i can't get past database logon prompt to get to immediate window. Note edits i have made to original request above
Kojof
2010-06-21 14:59:38
A:
Thanks for helping guys. I realise the mistake that i made. When i created password, it must have joined me to a workgroup. Hence when i was prompted for a password, my network ID was displayed, so when i entered new password, i was denied access. When i tried logging in using Admin and password , that allowed me to login.
Kojof
2010-06-21 16:00:55
You're always joined to a workgroup with Jet -- the default logon is "admin" with no password. You don't see a logon prompt until you put a password on the admin account. This is Jet ULS 101. Anyone using Jet should know all of this, and if you don't, you really need to spend some time learning about the basics of the db engine you're using.
David-W-Fenton
2010-06-22 01:40:54