Unsecuring a database

garyd1234

Board Regular
Joined
Apr 17, 2003
Messages
103
Ok,
We have a secure database that we wish to remove security from. The way it was originally secured was kind of by trial and error. When the database comes up there is no log in box, just the main form comes up. But, you can't go into design view. It will say you don't have permission. We need to go into design view. How can I remove the security or get a log in box? Thanks

Gary
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Hi garyd1234


Try this and see if this helps you...

Creating Changing Passwords


Start Microsoft Access by using the workgroup the user account is stored in, and log on using the name of the account for which you want to create or change the password.
You can find out which workgroup is current or change workgroups by using the Workgroup Administrator.

Open a database.
On the Tools menu, point to Security, and then click User and Group Accounts.
On the Change Logon Password tab, leave the Old Password box blank if a password hasn't been defined previously for this account. Otherwise, type the current password in the Old Password box.
Type the new password in the New Password box.
Retype the password in the Verify box, and then click OK.



Guide lines for passwords:

User names can range from 1 to 20 characters, and can include letters, accented characters, numbers, spaces, and symbols, with the following exceptions:
The characters " \ [ ] : | < > + = ; , . ? *
Leading spaces
Control characters (ASCII 10 through ASCII 31)




To clear a security account password:


To complete this procedure, you must be logged on as a member of the Admins group.

Start Microsoft Access by using the workgroup information file in which the user account is stored.
You can find out which workgroup information file is current or change workgroups by using the Workgroup Administrator.

Open a database.
On the Tools menu, point to Security, and then click User and Group Accounts.
On the Users tab, enter the user account name in the Name box.
Click Clear Password.
Repeat steps 4 and 5 to clear any additional passwords, and then click OK when you have finished.



Hope this helps you


Gemini32
 
Upvote 0

Forum statistics

Threads
1,221,537
Messages
6,160,401
Members
451,645
Latest member
hglymph

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top