hi, i know how easy it is to create a command button that opens a table, but is it possible to create a button that opens the table in design view? i want it because i need an administrative side to my program that allows easy deletions of records etc...any ideas?
i also need aministrators only to be able to access the admin form...so how do i set a password on the command button that opens the admin side of the program?

For the password side, an easy way to do this is to do it this way

Dim strPassword as String

strPassword = Inputbox("Please enter password for admin form")

If strPassword = "YourPassword" then
-true statements
Else
Msgbox "Password Incorrect"
End if
End sub

If you need to change the password build yourself a table to hold the password and instead of "YourPassword" perform a Dlookup statement to retrieve the password value.

Why do you need to give the user access to the table design? If you want the user to be able to delete records just build datasheet form with additions etc..set to no and the AllowDeletions set to yes.

Hope that helps.