Can't open my .mdb

[Guest]

Can't open my .mdb
I was experimenting with opening an access database in IIS. For
experimenting, I have an .mdb called HasbaraSample. In this case I copied it
to the C:\Inetpub\wwwroot\Access folder.

I had various problems trying to get it to open in IIS. I went to asp.net
forums and was told to right_click the app_data folder and click the security
tab.

To make a long story short, that never worked out.

Now to my great horror, when I try to open any of the dozen or so
HasbaraSample.mdb's on my computer, I get a login box with the username
dennist685 on it with a blank password. Nowhere have I defined a password,
except for sqlserver 2005, mixed authetification.

I tried no password and got the message, 'not a valid account name or
password'. I tried my password for sqlserver, got the same message. Tried,
Admin, Administrator, etc. all giving me the same message.

I am really stuck now. I've got to open these other HasbaraSample.mdb's.
Never in my wildest imagination did I consider playing with an App_Data
security tab end up disabling all the far flung HasbaraSamples on my
computer. I don't know how the security settings could possibly have
proliferated.

I had no security settings before. My intention was just to design my
database in Access, then upsize it to sqlserver.

Can anybody help me? This is urgent.


dennist685

 

[David Lloyd]

One possible scenario is that you (or someone) inadvertently changed the
system database that Access uses. Access uses a separate database, normally
referred to as a system database to enforce security. If you open Access
without opening a database and then select the Tools menu, Security,
Workgroup Administrator, you can see which system database Access is using.
You can either browse to another system database (*.mdw, using the Join
button) or create a new one in the Workgroup Administrator. The default
system database (System.mdw) is generally stored in the following path (for
Access 2003 anyway).

C:\Documents and Settings\<UserName>\Application Data\Microsoft\Access

By using a system database with no security settings, you will not be
prompted for a username and password.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Can't open my .mdb
I was experimenting with opening an access database in IIS. For
experimenting, I have an .mdb called HasbaraSample. In this case I copied
it
to the C:\Inetpub\wwwroot\Access folder.

I had various problems trying to get it to open in IIS. I went to asp.net
forums and was told to right_click the app_data folder and click the
security
tab.

To make a long story short, that never worked out.

Now to my great horror, when I try to open any of the dozen or so
HasbaraSample.mdb's on my computer, I get a login box with the username
dennist685 on it with a blank password. Nowhere have I defined a password,
except for sqlserver 2005, mixed authetification.

I tried no password and got the message, 'not a valid account name or
password'. I tried my password for sqlserver, got the same message. Tried,
Admin, Administrator, etc. all giving me the same message.

I am really stuck now. I've got to open these other HasbaraSample.mdb's.
Never in my wildest imagination did I consider playing with an App_Data
security tab end up disabling all the far flung HasbaraSamples on my
computer. I don't know how the security settings could possibly have
proliferated.

I had no security settings before. My intention was just to design my
database in Access, then upsize it to sqlserver.

Can anybody help me? This is urgent.


dennist685

 

[Paul Clement]

¤ Can't open my .mdb
¤ I was experimenting with opening an access database in IIS. For
¤ experimenting, I have an .mdb called HasbaraSample. In this case I copied it
¤ to the C:\Inetpub\wwwroot\Access folder.
¤
¤ I had various problems trying to get it to open in IIS. I went to asp.net
¤ forums and was told to right_click the app_data folder and click the security
¤ tab.
¤
¤ To make a long story short, that never worked out.
¤
¤ Now to my great horror, when I try to open any of the dozen or so
¤ HasbaraSample.mdb's on my computer, I get a login box with the username
¤ dennist685 on it with a blank password. Nowhere have I defined a password,
¤ except for sqlserver 2005, mixed authetification.
¤
¤ I tried no password and got the message, 'not a valid account name or
¤ password'. I tried my password for sqlserver, got the same message. Tried,
¤ Admin, Administrator, etc. all giving me the same message.
¤
¤ I am really stuck now. I've got to open these other HasbaraSample.mdb's.
¤ Never in my wildest imagination did I consider playing with an App_Data
¤ security tab end up disabling all the far flung HasbaraSamples on my
¤ computer. I don't know how the security settings could possibly have
¤ proliferated.
¤
¤ I had no security settings before. My intention was just to design my
¤ database in Access, then upsize it to sqlserver.
¤
¤ Can anybody help me? This is urgent.

How are you attempting to open the .MDB? Where does the user ID dennist685 come from? Is it a
Windows logon user ID?


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

That's exactly what happened. Steven Cheng solved the problem for me in a
thread in the office newsgroups -> Access.Security.

dennist685

 

[Guest]

Paul,

Thanks for trying to help. As you read, the problem was solved. dennist685
is my windows login, with no password.