How to make only a form visible to users and not the whole data base.

[Essnell]

Hi, I'd like to know if it is possible to have a form containing a number of buttons that run query searches for showing availability of members on specific days as the only visible part of the access DB.

This is for a small Museum and we don't want every one getting into the DB.

I have tried as in my previous question 2 weeks ago, which I cannot find, DoMenuItem and RunComd without success. I really don't want to go down the road of lots of accounts and passwords.
Could a macro of some type help?
Putting the form into a html page still opens the whole DB.
We are using Access 2003.
Help!!! Essnell

[vb5prgrmr]

It might have been moved to the Access VBA forum...

Click on Developement link at top or to the right of your post, scroll down and keep eyes right...



Good Luck

[Essnell]

Not getting anywhere

Hi

Thanks for the reply - at least someone has seen my question.

I haven't been able to locate anything other than this thread.
No answers yet.

Looks like it might be impossible?

Would it be more likely that Access in a more recent version like 2007 be able to do what I want?


Essnell

[patjones]

Hi

Thanks for the reply - at least someone has seen my question.

I haven't been able to locate anything other than this thread.
No answers yet.

Looks like it might be impossible?

Would it be more likely that Access in a more recent version like 2007 be able to do what I want?


Essnell

The form is always going to open within the Access database window. If you don't want anyone to have access to the tables, etc. then you need to make a locked version of the file which will display only the forms (but still inside the Access window).

Pat

[Essnell]

Thanks Pat,
will investigate this avenue. if i have aproblem i'll be back.

Essnell