Make User See Only Certain Form

[NickG1]

Is there a way to set up an Access application so that the user will only see
a certain form? What I want is to separate the main form that will be used
from all other objects - I want to ensure no one mucks around with the
tables, queries, etc.

I think what I am asking in some way touches upon security. But I vaguely
recall reading once that Access allows for "splitting" objects across
different files - e.g. - I could have the form in one file and everything
else in another. Not sure about this though.

Nick

 

[AJ]

What we have used at our office is splitting our databases into a front end
and a back end. The back end will have all of the "meat" ie, tables. The
front end would contain the forms, queries, reports, etc. We have it set up
so when the users brings the application up the switchboard comes up and they
have no access to modify the forms, queries, or reports. All they see is the
switchboard and the data entry forms they can enter info into. One thing to
make sure if you do this is that any front end user has to have
"Read/Write/Execute/Delete" permissions to the folder where the back end is
kept. Then we also have a set up in the front ends that has a "Division"
table that lists all approved users and what level they can view (we have
some users that can enter payments while others have no access to this area).
There is a lot of info on this site about splitting db's. I can send some of
the coding we use for the division tables ie, getting the users log in id
etc. if that would be helpful.
Good Luck,
AJ

 

[NickG1]

Thanks AJ. Can you point in the right direction, a website, a topic I should
research?

 

[AJ]

You can do a search on "splitting a database",also here are some links that I
have found helpful on the subject.

http://www.allenbrowne.com/ser-01.html
http://www.granite.ab.ca/access/splitapp/index.htm
http://www.databasedev.co.uk/split_a_database.html
http://support.microsoft.com/default.aspx/kb/304932

These will give you some insight on why to do it and how to do it.
Good Luck,
AJ