Sharing an Access database

[cubi]

Hi,

I have an Access 97 database that I want to share with others on my network. Is it possible to share it so that other users can only open one object, a form in this case, and nothing else?

Any ideas appreciated. Thank you!

 

[upplepop]

Well, I'm using OfficeXP, so I'm not sure if this solution will work for you. But try going to Tools -> Startup -> Display Form/Page. In the combo box, select the form you want them to access. So now when the database starts up, it will just open up to that form. If you want to get into the database window, hold down the SHIFT key when opening your database--but don't tell them that!

 

[allepa]

Using 97 and XP for this is the same.
You could also use the Autoexec macro to ensure anything you need to run first is completed (unless you set this in the OnOpen property of the form), then open the form, not forgetting to hide the database window.
The StartUp and Autoexec do practically the same thing you require here.

To stop the SHIFT key working, simply use the AllowBypassKey property, but be careful so that you can still gain access to your data. I generally use this when completing a database and use a MDW file to sign into the database with a username to turn off the AllowBypassKey property (something along the lines of "if currentuser() = me then AllowBypassKey = True&quot.

Hope this helps you get going.

 

[cubi]

Thank you for your input! I will try them.