Workgroup administrator and Access 2007

[T Menacher]

The "new" computer in my client's office came with Office 2007 installed.
Everyone else is using Office 2000 or Office 2003. The company database is
an Office 2000 application shared on the network. There is a company MDW
file so everyone has a log-in through the workgroup administrator.

Using the advice I found in article KB918583, I managed to set this Office
2007 computer up, and the user could log in to the database. We made a
short-cut on her desktop and everything was fine that day. The next day, she
said it was no longer working.

Is she clicking the wrong desktop icon or does Access 2007 have more issues
with the workgroup administrator that I am unaware of?

 

[aaron.kempf]

Access 2007 doesn't support User Level Security.

If you want to secure your data-- you need to move to SQL Server.

Sorry-- I've been warning people all decade.

-Aaron Kempf

 

[Rick Brandt]

Access 2007 doesn't support User Level Security.

Incorrect. The accdb file format doesn't support ULS. When using an MDB
then ULS works as before.

 

[aaron.kempf]

Well it doesn't really -work- it just kinda functions right?

It's not secure-- it's not reliable-- that's why MS pulled it out.

-Aaron

 

[Rick Brandt]

Well it doesn't really -work- it just kinda functions right?

It's not secure-- it's not reliable-- that's why MS pulled it out.

I'm not a fan of ULS. That is why I said that it worked "as before".

 

[Graham R Seach]

You say the users are logging in via the Workgroup Administrator. That says
to me that the desktop shortcut does not specify the workgroup file to use.
Is that the case? If so, then you need to setup each shortcut to point not
only to the database itself, but also to (a) msaccess.exe, and (b) the
workgroup file.

Open the shortcut's properties, and examine the Target box. It should
contain:
"path to msacess.exe" "path to database" /wrkgrp "path to workgroup
file"

Just make sure that the workgroup file is in a shared location.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia