469,326 Members | 1,275 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Can't open my .mdb

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
Nov 30 '05 #1
4 1658
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.
"dennist685" <de********@newsgroup.nospam> wrote in message
news:FC**********************************@microsof t.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\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
Nov 30 '05 #2
On Wed, 30 Nov 2005 04:38:02 -0800, "dennist685" <de********@newsgroup.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\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)
Dec 1 '05 #3
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\<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.
"dennist685" <de********@newsgroup.nospam> wrote in message
news:FC**********************************@microsof t.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\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

Dec 3 '05 #4
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********@newsgroup.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\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)

Dec 3 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by ad | last post: by
6 posts views Thread by aomighty | last post: by
14 posts views Thread by Rochester | last post: by
5 posts views Thread by Usman Jamil | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.