Which version of Access should I set up my Security In

[627dmp]

I've created a database in 2003, but also have 2007 which is where the
database will be running, which version is better as far as setting up
user-level security?

 

[Tony Toews [MVP]]

2003. 2007 doesn't have ULS anymore...

That's wrong. Access 2007 does support ULS if you use the MDB file
format. If you use the ACCDB file format then you are correct., ULS
isn' support for the ACCDB file format.

you need to use some version of SQL
Server for that. (can be Express, which is free).

Which is going to be more work, require the IT department involvement
but would also be more secure.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/