Associate .MAT shortcut with workgroup file

[Catalina Diver]

If you right-click on a table or query, one of the options is to create a
shortcut to that object. The result of this is a .MAT file. I have a user
trying to recreate such shortcuts, but the database is associated with a
wrkgrp file and he does not know how to modify the .MAT file to tell it which
wrkgrp file to use. Does anyone know how to edit this shortcut?

Thanks for your help.

 

['69 Camaro]

Hi.

Does anyone know how to edit this shortcut?

You can edit the Access shortcut in any text editor. There's a line for the
database path and file name, but none for the workgroup information file.
The workaround for this is to already be logged into the workgroup file when
opening the Access shortcut. The user will then be prompted for his user ID
and password before the Access object is opened in Access.

Alternatively, a Windows shortcut can be created with the necessary path and
file name of the Access executable, the necessary path and file name of the
database file, the necessary path and file name of the workgroup information
file, and either a startup form can automatically open the table or a macro
with the /x command-line switch can be added to the shortcut to run a
specially created macro to open the table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.

 

[John Nurick]

AFAIK the options are

1) create a Windows shortcut whose target is a command line that
launches Access with the correct workgroup (using the /WRKGRP switch)
and the .MAT file

2) in My Computer, go to Tools|Options|File Types and alter the way .MAT
files are opened (click Advanced, select the Open action, and click
Edit). This of course will affect all .MAT shorcuts, not just this one.
But the command line shown here may be relevant for what you need to do
in (1) above.