asked on

Microsoft Access User and Group command are not available

In our .accdb version of the database, the User and Group account and User and Group permissions are displayed on the top ribbon, but not available. Why?

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

J.R. Sitman

ASKER

We are selling this to Animal Control Shelters and need the security. Can I just change the extension or should I import the existing into a new database as .mdb?

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

J.R. Sitman

ASKER

thanks

J.R. Sitman

ASKER

thanks

Jim Dettman (EE MVE)

Just as an aside, you should move away from using ULS security as soon as you can so you don't get stuck.

You can do your own, or using something like this:

http://www.peterssoftware.com/las.htm

Right now, Access 2013 and up only supports JET 4.0 format (the last version of the MDB format). I don't know when that will end (if ever as JET was used for a lot of things besides Access), but you should be considering other options.

Jim.

J.R. Sitman

ASKER

We do use Peters Software on our version, but I cannot include that when we sell a version. I am sure that would be a license violation.

Jim Dettman (EE MVE)

That would depend on the license you have. If you have a single license, then you'd need to upgrade for $275:

But it's good your already using it. At least now you know what's involved should it come to the point where you can no longer support the MDB format.

Jim.