Can't open my .mdb

[dennist685]

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\wwwr oot\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.m db'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.m db'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\<UserN ame>\Applicatio n 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.
"dennist685 " <de********@new sgroup.nospam> wrote in message
news:FC******** *************** ***********@mic rosoft.com...
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\wwwr oot\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.m db'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.m db'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]

On Wed, 30 Nov 2005 04:38:02 -0800, "dennist685 " <de********@new sgroup.nospam> wrote:

¤ 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\wwwr oot\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.m db'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.m db'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)

[dennist685]

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

dennist685

"David Lloyd" wrote:

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\<UserN ame>\Applicatio n 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.
"dennist685 " <de********@new sgroup.nospam> wrote in message
news:FC******** *************** ***********@mic rosoft.com...
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\wwwr oot\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.m db'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.m db'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

[dennist685]

Paul,

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

"Paul Clement" wrote:

On Wed, 30 Nov 2005 04:38:02 -0800, "dennist685 " <de********@new sgroup.nospam> wrote:

¤ 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\wwwr oot\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.m db'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.m db'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)