Making a enduser version of the database?

[nicksource]

How do I make my database so only the creator (myself) can edit the tables, forms etc and other users see an interface starting with the switchboard, which they can't use any database tools except what the forms allow them to do?

Basically some kind of user permissions.

Thanks.

 

[David Eagar]

Do a search on Security / workgroups and be prepared for some hard work

 

[JBurlison]

Bob Larson has a great tool found here:

http://www.access-programmers.co.uk/forums/showthread.php?t=111132

 

[nicksource]

Is there no easy work arounds?

 

[Rabbie]

Is there no easy work arounds?

No gain without pain

 

[nicksource]

Damn.

I just remember in Access 98 that it was easy to make a form based interface where the user couldn't see the tables, just forms. Although, that was a long... long time ago.

 

[Rabbie]

I think you could be referring to .mde files.

 

[nicksource]

Ah I found it, it's ACCDE in 2007 I think, although it doesn't restrict much it'll do.