Splitting & more

  • Thread starter Thread starter Ruben Granados
  • Start date Start date
R

Ruben Granados

Hi,
I build a new database (for the first time) I'm very
worried on what will happen when users start using it.
I have read a lot but still having some issues pending.
First:
When to Add groups, administrators,etc (Security) before
splitting, after splitting??
Second:
When converting to MDE, after Security is up (do I need
Security if users will work on an MDE?)
Third:
I will save the developed database .mdb on my own
harddisk. Then put the tables on a shared hard disk and
give the front end copies (I understand that these contain
reports, forms and queries)to users. What else should I
give to them in order to the database work properly? I
have a Tree View control, do I need to create de Reference
on every computer?

Yes I know that my questions might be too stupid, but is
my first DB.
Please any help, tips, etc., will be greatly appreciated.

R. Granados.
 
I personally, am not a fan of Access security, so try to avoid using it.

Whether you need security or not depends on what security measures you need
to implement. An MDE file will not allow users to make changes to form &
report objects. They will however, be able to modify queries. Assuming it is
split, they will not be able to modify the tables.

Regarding deployment, you might want to look at the Packaging wizard. It
should automatically add any dependency files to a nice installation program
which it creates. The users can then simply run the installer...




--
Cheers,


James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures
 
Back
Top