By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

view forms only

AccessIdiot
100+
P: 493
Hello all,

I have built a database with a bunch of forms and queries for some fisheries guys that I work with. Now they would like to give a copy to THEIR client BUT they only want the client to be able to cruise through the forms (to look at their data) but NOT the tables or queries. They don't want the client to be able to enter data, or edit the data in any way.

How do I do this? I know I can change the startup menu to show only the "entryway form" but anyone who knows access can simply hit Alt+W+U and get the database. I also know I can change the properties to not allow NEW records but how do I make the current records in the forms view only and not editable?

Thanks for any help - I basically need to create a "read only" database (forms only) that no one can crack.

Cheers,
Melissa
Aug 8 '07 #1
Share this Question
Share on Google+
10 Replies


Expert 100+
P: 296
Hello all,

I have built a database with a bunch of forms and queries for some fisheries guys that I work with. Now they would like to give a copy to THEIR client BUT they only want the client to be able to cruise through the forms (to look at their data) but NOT the tables or queries. They don't want the client to be able to enter data, or edit the data in any way.

How do I do this? I know I can change the startup menu to show only the "entryway form" but anyone who knows access can simply hit Alt+W+U and get the database. I also know I can change the properties to not allow NEW records but how do I make the current records in the forms view only and not editable?

Thanks for any help - I basically need to create a "read only" database (forms only) that no one can crack.

Cheers,
Melissa
In the forms properties, under the data tab, change Locked to Yes and they won't be able to change the info in the form.
Aug 8 '07 #2

Rabbit
Expert Mod 10K+
P: 12,389
That no one can crack? That's impossible. Anyone who knows enough about Access can get by whatever you put in to stop them.

You can hide items but they can just check on option to view hidden items.
You can set up an Access security workgroup but they have to join it.
You can flick on a few settings so that you can't add, delete, or edit from the form. But you can just open the form properties and redo that.
You can make an mde but that doesn't prevent them from editing the data in the tables.
Aug 8 '07 #3

AccessIdiot
100+
P: 493
So in other words, you can make it challenging, but you can't make it foolproof?
Aug 8 '07 #4

Rabbit
Expert Mod 10K+
P: 12,389
So in other words, you can make it challenging, but you can't make it foolproof?
That's right, nothing is ever foolproof but Access is definitely not the best choice when it comes to security.
Aug 8 '07 #5

AccessIdiot
100+
P: 493
Thanks Rabbit.

So the guy I built it for want to have a pop up window that launches when the db is launched. The pop up would basically have a disclaimer on it with an "ok" button proceed and a "cancel" button to quit.

I am pretty much an Access noob and don't know how to create custom message boxes. Any hints would be much appreciated! (especially on how to get it to pop up at launch?).
Aug 8 '07 #6

Rabbit
Expert Mod 10K+
P: 12,389
Thanks Rabbit.

So the guy I built it for want to have a pop up window that launches when the db is launched. The pop up would basically have a disclaimer on it with an "ok" button proceed and a "cancel" button to quit.

I am pretty much an Access noob and don't know how to create custom message boxes. Any hints would be much appreciated! (especially on how to get it to pop up at launch?).
Are you wanting a MsgBox, because you can set the title and what buttons appear in a MsgBox ? Or a custom warning message with a different look?
Aug 8 '07 #7

AccessIdiot
100+
P: 493
Eep, I don't know? What's the difference? I'm basically looking for a way to give them the standard spiel disclaimer and then they have to say "ok" if they want to continue or "cancel" and it will quit the app. I guess thats more of a customizable message box?
Aug 8 '07 #8

Rabbit
Expert Mod 10K+
P: 12,389
A message box is that standard warning box that pops up in windows. You can set the title, text, and buttons that appear. So in all respects it can do what you want. You would use a form instead if you wanted something that looks different.
Aug 8 '07 #9

AccessIdiot
100+
P: 493
I think a message box is just what I need.

Thanks!
Aug 9 '07 #10

Rabbit
Expert Mod 10K+
P: 12,389
Not a problem.
Let me know if you need to know how to work certain aspects of the MsgBox.
Aug 9 '07 #11

Post your reply

Sign in to post your reply or Sign up for a free account.