advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Please assist with MS Access' MESHUGGE permissions crud
Posted by: Greg the dogsitter
Date: December 15, 2005 10:19AM
A database contains bunches of information. Permissions are set up so different users can do different things with this information.

MS Access creates two files: the database file and the permissions file.

Here at work, there are several ongoing projects, each with their own databases and permissions files.

If a person wants to switch to another database, they first have to go through this goofy process where they switch to the associated permissions file. Otherwise, the database won't let them in.

Is there a way to automatically have Access open the appropriate permissions file when switching databases? Or is this just a crummy way of doing things?

(There's a lovely way to do this when using Excel to extract data from an Access database, but the trick doesn't work when opening the database itself.)

GtDS
Options:  Reply • Quote
Re: Please assist with MS Access' MESHUGGE permissions crud
Posted by: Greg the dogsitter
Date: December 15, 2005 09:24PM
(26 views later)

See? No one knows. It's a stupid arrangement.
Options:  Reply • Quote
Re: Please assist with MS Access' MESHUGGE permissions crud
Posted by: rgG
Date: December 15, 2005 09:27PM
And here I checked back thinking you were going to post that you figured it out on your own.





Roswell, GA (Atlanta suburb)
Options:  Reply • Quote
Re: Please assist with MS Access' MESHUGGE permissions crud
Posted by: Greg the dogsitter
Date: December 15, 2005 09:32PM
At the point, so did I. :-)
Options:  Reply • Quote
Re: Please assist with MS Access' MESHUGGE permissions crud
Posted by: Greg the dogsitter
Date: December 16, 2005 01:54PM
Found it, thanks to Google Groups.

Make a shortcut to the database file. Get Properties.

Change the Target field so it includes:
/WRKGRP <full path to workgroup file>

Phew! I knew there had to be a good way to do this!



---
Use Excel? Can I interest you in saving some time with Excel? Listifier.com!
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 208
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 5122 on October 03, 2020