Access help - Tools>Security>Workgroup Administrator

[tometom]

Here is the situation. I have a database that opens with a specific workgroup information file. The problem is that some of my users are getting disconnected from the file, so the database won't allow that user to run anything (specifically reports).

Is there a way to reconnect them to the correct file without having to go through the menus? (Some of my users aren't extremly computer savy, thus even if I explain the reconnection process 100 times, it won't sink in)
I was hoping to maybe just add a button inside the initial form that pops up.

A better question might be: Is this even possible through Access or would I be looking at a Windows VB program or some other program that I don't have any experience with?

Thanks in advance for help and ask questions if further explanation is needed.

 

[SydneyGeek]

You can provide the users with a shortcut that they use to open the file. In the shortcut you define the workgroup file, so users automatically join the workgroup if they use the shortcut. Example:

C:\MSOfficeXP\Office10\MSACCESS.EXE c:\data\Northwind_be.mdb
/wrkgrp c:\developer.mdw /user editor

The first 2 sections are the path to Access and the path to the target file; the /wrkgrp and /user switches define the workgroup file and the user login name.

Denis

 

[tometom]

Denis, I want to thank you for your help, but I frankly don't understand.

I understand the use of a shortcut and I understand the first two pieces, but I can't wrap my finger around the last 2 pieces. I just don't understand what to do with that information.

Thanks again.

 

[SydneyGeek]

Try this:

I have a database that opens with a specific workgroup information file

The full path to the workgroup file is what goes after the /wrkgrp switch. This tells Access that this file uses a specific workgroup and not the default one.
You can probably leave off the /user switch because the users will be prompted to log in when the database launches.

Denis

 

[tometom]

Denis, hopefully we can get this right.

Here is the code I put in the shortcut, but it doesn't open the mdw.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Experience\Experience Database.mdb" /wrkgrp C:\Experience\system.mdw

If I try adding " "(quotes) aroung /wrkgrp C:\Experience\system.mdw, I at least get an error message that says

Access couldn't find file: 'C:\Experience\system.mdw"' This file is required for startup.

The odd thing is the extra quote on the end of the statement, that makes me think that I am getting closer but I have some silly mistake.

If I add quotes just around the C:\Experience\system.mdw, nothing happens.

Thanks again for the help.

 

[SydneyGeek]

Try creating the shortcut without any quotes. The samples that I have seen don't use them.
See, for example, point 19 of the Access Security FAQ.

Denis