Re: Should we Convert to Access 2007?

Re 1: Yes: use MDB format if you want Security.

Re 2 - 4: All I do is create a little unbound form, with buttons for the RunCommand code. This is in the database itself, so the user doesn't get to here unless they have user name and password to match the MDW. At this point, the MDW controls what they can and can't set.

If you wish, you can hide the form/buttons if the user doesn't have adequate permissions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"WPW07" <wwisnieski@xxxxxxxxx> wrote in message
news:2d42280d-a6ae-4adb-a7a3-f51f02864e7b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks Allen.

Just so I understand this correctly....

1. I keep the application in Access 2003. Users who have Access 2007
can open it and create new reports and queries in Access 2007?

2. If an administrator wants to use the MDW file, I should create a
module with RunCommand code?

3. How would I tie the RunCommand code to the MDW file?

4. How would the administrator call it? Should I create a form that
calls the RunCommand code in it?

Thank you,

William



On Feb 27, 7:36 pm, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx> wrote:
Hopefully someone else with Oracle experience will comment too.

As far as Access goes, 2007 has a new file format (ACCDB), and you cannot
use security (MDW) with that. But if you keep your MDB format file and use
it in A2007, you can continue to use Access security. You can fire up the
interface from within A2007 (in an MDB) with this kind of thing:
RunCommand acCmdWorkgroupAdministrator
RunCommand acCmdUserAndGroupAccounts
RunCommand acCmdUserAndGroupPermissions

Other info on converting to A2007:
http://allenbrowne.com/Access2007.html

"WPW07" <wwisnie...@xxxxxxxxx> wrote in message

news:3707bb54-e5cd-4fb0-a2a7-673c403c8f65@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> Hello,

> We have several complex applications developed in Access 2003 by
> various outside consultants. These applications link to a variety of
> Oracle tables and are used only for Access reports. User level
> security is also built in via the mdw workgroup file for all
> applications.

> I've been asked to research how viable it is to convert all of these
> applications to Access 2007. I understand 2007 discontinued user
> level security via the mdw file. On one hand, I see that Microsoft
> advises NOT to convert to 2007 if you need user level security:

>http://office.microsoft.com/en-us/access/HA102345611033.aspx

> But then it also says that you can use the Workgroup Administrator
> Utility in Access 2007:

>http://support.microsoft.com/kb/918583

> Which is a little confusing.....But the bottom line is we definitely
> need to continue with user level security. I'm interested in getting
> some feedback and opinions on what we should do. Also, we do not own
> SQL Server, but do have MySQL installed.

> Thanks for any and all feedback.

.

Quantcast