Admin tools / Maintenance

[George J]

I am trying to think of what someone with Admin rights to my database may want or required.

I have it set up so that they can add to or deleted from tables. This is so they can 'edit' combobox dropdowns.

What else would be reuired?

All i can think of is deleting records and possibly to compact the backend.

Are there other things that i should be looking to include?

thanks
George

 

[Catalina]

How about access to only certain reports.

Catalina

 

[jdraw]

You may want an Admin form with specific options. I wouldn't want an Admin to be adding/deleting records directly at the table level. An Admin Form with some options could include some basic logging routine to show When the Admin logged on, which Admn, what they did (execute procedures??) and when they logged off.
BUT it depends on your environment, the number of Admins, What they might want to do, and how much discipline the "business' requires.

 

[George J]

Just lost my post.

I can have a basic user that can input and create reports
Advanced user with extra report types available

Admin - wasn't sure what admin is required in what will be a fairly large database. The eventual plan is to have this on a cloud with various offices using it (possibly 80 users). I was going to allow admin to deleted records by entering the record number and verifying their password.

Not sure what else is required to keep a database running smoothly.

Thanks for the replies guys

 

[jdraw]

Some quick thoughts.

You don't necessarily want to delete records physically. You can add a flag/switch/boolean/Yes-No field to a table. When it is On, True whatever, that can signal this record is "logicallly" deleted. (We used to call this shadow delete). Nothing gets lost (just in case there is a major mix up). You design it in, and all your queries etc make use of this known feature.

Admin type stuff:
You may have to do Compact and Repairs (garbage collection..)
You may have to reload/reset certain tables or variables.
You may need to run "management" reports.
You may need to do "special queries/reports".

You may find more info at Martin Green's site - he has lots of tutorials and examples of menus, parameter driven forms...
see http://www.fontstuff.com/access/index.htm