Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock db in AccessXP

Status
Not open for further replies.

Dina01

Programmer
Mar 26, 2002
204
CA
Hello

I was wondering if anyone can help me. I have a little program that I did in Access 97 that locks all the database....

But since I got upgrade to Access XP, I converted the program , but it does lock the databse, but then at the bottom of my screen, on the toolbar I can still have access to the tables, and all the forms that are open......

I also add the following code in one of my form, but AccessXP, opens all the forms at the bottom of the screen, does anyone know hoe to remove this....


DoCmd.ShowToolbar "Menu Bar", acToolbarNo
DoCmd.ShowToolbar "Database", acToolbarNo
DoCmd.ShowToolbar "Table Design",acToolbarNo
DoCmd.ShowToolbar "Form View", acToolbarNo


Thanks Dina

 
first, get rid of those vba commands, go into the database, click on tools, then on startup options... in there, there is options to hide command bars on startup....

try that...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.
 
Hello James,

I followed your steps but that still didn't work. I still have access to my forms and table from the bottom of the screen on the menu Bar.
 
ok, now try clicking on tools, then options...

in that there is an option for windows in task bar. Turn that off...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top