New database asking Name and Password:

[teja]

Hi all,

I am new to MS Access. I have a Access database which is opened using a BAtch file because it has a user security file. It asks user name and password while login for the database.

But now I have deleted the database and application and my system does not have any access database.

My problem is I need to create a new database and it is asking for user name and password when I try to open it. I am unable to understand why it is asking for the credentials even though I have deleted the old database.

Also, when I got that security fiel and opened the database I am able to open the database. I should not use that Security file for this new database as it belongs to another database.

So how to open my new database without it asking for username and password??

Kindly help. Thanks in advance.

[RuralGuy]

Maybe this link will shed some light on the subject: http://support.microsoft.com/kb/305542

[teja]

Maybe this link will shed some light on the subject: http://support.microsoft.com/kb/305542

I have gone through the content and it says that Access opens the new database using the old security file itself. It says to run the following command

docmd.RunCommand acCmdWorkgroupAdministrator

after this it asks to select the System.mdw file present in the path C:\Documents and Settings\219962\Application Data\Microsoft\Access

I have followed the same and still it is asking for the password and username. Kindly help.

[RuralGuy]

Does this happen with *any* new db you create?

[teja]

Does this happen with *any* new db you create?

yes it happened with all my new databases (access dbs)

[RuralGuy]

I don't suppose you still have a copy of the old mdb and mdw file around, do you?

[teja]

I don't suppose you still have a copy of the old mdb and mdw file around, do you?

I have them in another drive in my system itself

[RuralGuy]

I know it is reaching but I'm going to suggest this link: http://office.microsoft.com/en-us/ac...005188240.aspx

[teja]

I know it is reaching but I'm going to suggest this link: http://office.microsoft.com/en-us/ac...005188240.aspx

Also, is there a possibility to not split the database and have both DB and application in same Access in shared drive and use in multi user environment. Because the size is very small

[RuralGuy]

Also, is there a possibility to not split the database and have both DB and application in same Access in shared drive and use in multi user environment. Because the size is very small

The OP stated this is happening on new db's which are not split by default.

[teja]

The OP stated this is happening on new db's which are not split by default.

I have cretaed a new system.mdw file for the new access database and i want to add new users to it apart from the admin which is provided by default. Any help or link which will provide that info.

[RuralGuy]

Maybe this link will help: http://www.headwaysystems.com/accessSecurity.htm
Have we corrected the original issue yet?

[teja]

Maybe this link will help: http://www.headwaysystems.com/accessSecurity.htm
Have we corrected the original issue yet?

I asked the new user creation issue to solve the first thing as i have changed the work group file to the new system2.mdw file. Noe i am trying to add new users and groups to that file and set a password.

[RuralGuy]

The new accdb format for ac2007 does not support ULS. Are you still using the mdb format?

[teja]

The new accdb format for ac2007 does not support ULS. Are you still using the mdb format?

What is uls. I have given the database as test.mdb