front and back ends

[swin]

Hi guys,
I need help with security settings and that. I have a database which i want available on a shared server. Basically i only want people to beable to see one form but not beable to see anything else or make any changes to this form.

Do i need to split and make a front and back end? I will want to make occasional changes to tables etc.. and so would want this to automatically update on the database seen by everyone else.

Sorry, not making much sense but am bit confused about it all!

Any help from some clever peeps?
Ta

 

[rnutts]

If you have multiple users at the same time then you really have no choice other than to split your database.
Tips

Make sure you keep a copy of the front end for yourself so that you can make changes and check they work before copying the revised front end to each user.

If you make changes to the tables in the backend then this will automatically be seen by the users, so long as they are all pointed to the back end with the linked table manager.

Are all the users using the same form. If so then use the Switchboard manager to create a start form which will only have the forms you want the users to see available.

Hope this makes some sense

Richard

 

[swin]

Hiya Richard,
Thanks for that. I need to try making a back end front end again, last time i tried it didn't seem to work! I assume the front end is the one you started with in the first place?

Yep, everyone will just be using one form (linked to other forms), it's more of a lookup kind of thing, so they wont need to make any changes. I think ive managed to make a start form, so that's what comes up when you open. The only other thing is there a way of removing the menu bar from view, so there are no options to use file/edit/view etc..? So all they will see is the startup form.

Cheers

 

[manix]

To remove the menu bar from view on start up, you need to change your start up options:

Go to Tools, Start Up.

There you can check and uncheck all the toolbars and whether the Database window (the one with all your tables, forms, macros etc..) appears etc.....

Then when you open whatever is unchecked won't be displayed. If you need to make changes and you want the tool bars and the database window to be displayed so you can make these changes, simply hold down Shift, when opening the database.

Hope that helps.

 

[swin]

Cheers manix,
Ive now actually managed to make a front and back end and the tables are linked.

I made the front end a mde file hoping that would make it read only, but nope, anyone can still make changes in that and it updates the backend.

So looks like i'm gonna have to try this security settings palarva, booo! last time i tried it i managed to lock myself out of the database. I've now got billions of copies incase this happens again!

Or i could ask everyone nicely not to make any changes on the form! mmmm dont think that'll work!

Thanks again

 

[boblarson]

Or i could ask everyone nicely not to make any changes on the form! mmmm dont think that'll work!

If you give them an MDE file it will lock down design changes to your forms, reports, and code.

 

[GaryPanic]

whoa......

on the form you wish people to see only - set properties to allow edits no allow additions . no allow creations. no

that will make this a read only form