Security / Exclusive mode/ Compact and Repair

[TinkerMan]

Hi all

I'm planning to use the "compact on exit" functionality to keep my db's neat. I have understood that I also have to grant "Exclusive mode" to the database object to the users of my db (not to Users group, but my own users group). Does this have a security implication?

As I'm running a FE/BE solution, does the compact and repair only do my FE or both. If only the FE, is there a good way of triggering the BE to be C&R as well?

(should apply to 2K, XP and 2003)

Thanks

 

[workmad3]

compact on exit will only run on the FE. To do the BE, I would suggest scheduling a time (probably about once a week or once a month depending on usage) where you open it exclusively and compact it.

 

[comptechbranden]

I just did that today! This link helped show me a movie of the process of doing it right and fast the first time i tried it.

Look for link to movie called compacting and repairing...there are a lot of movies here.
http://www.datapigtechnologies.com/AccessMain.htm

Hope that works out for you!

 

[TinkerMan]

Thanks for your feedback

The only thing that still is unclear, is that my database has implemented full security, which means that nobody can access my db without authenticating. This means that the shortcut must also be able to log in...Is there a good way of solving that?

Also, any idea if the exclusive mode opens up some security "holes"?

Thanks

 

[comptechbranden]

It does a password I think but I dont know about a username login...

I have forms that login people but it bypasses that, I dont have high security issues...