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

User Permission

P: 2
Hello everyone!
I am new to Access as well as to the forum.......I am facing a problem in which i want the user to enter data into the table but i don't want the user to be able to see the table and its design.But when i give permission to user to insert data in the table,Accsee automatically permits the user to access table and it design which is against the requirement.
Is there any solution to it through which the requirement can be fulfilled.

waiting for the reply..........
Thanx
Oct 3 '06 #1
Share this Question
Share on Google+
2 Replies


P: 2
Hello everyone!
I am new to Access as well as to the forum.......I am facing a problem in which i want the user to enter data into the table but i don't want the user to be able to see the table and its design.But when i give permission to user to insert data in the table,Accsee automatically permits the user to access table and it design which is against the requirement.
Is there any solution to it through which the requirement can be fulfilled.

waiting for the reply..........
Thanx

is there anyone who can help me with this problem???????????
Oct 4 '06 #2

PEB
Expert 100+
P: 1,418
PEB
Hi Shalini,

So You permit of your users to have access to your database Window?

And you don't have a startup Form that guides your users trought the database?

So I think You should create first a start up Switchboard that guieds your users...

In access for this there is a template... See tools menu...

Then either from tools enter in startup options and disable the view of the database window... Assign your form to be opened when your database is open!

This should be enough to protect your tables... There is also a lot of trucs... but in case if this isn't enough

Best regards!
Oct 8 '06 #3

Post your reply

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