Most recent version of Front End

[jsolutions]

I have a db split into frontend and backend. Frontends reside on each PC connecting to SQL backend. I have a master frontend on the server that I use to update and then copy to each PC. I have read Ben O'Hara's great article faq705-2010 regarding checking for most recent version.

The problem I am having is that my frontend is secured using a workgroup file. To keep users from complaining about the log in for every database they open, I am using the /wrkgrp command line switch in a shortcut to specify the workgroup only for the database that I want to secure.

This works fine; however, when I try to use the OpenDatabasecommand specified in faq705-2010, I am receiving an error message "You do not have permissions to access this database..."

My question is basically is there a way to use the OpenDatabase command (or any other command to open a database) and specify a workgroup file?? I have looked a little at connection options, but have come up empty.

Any ideas?

 

[oharab]

Hmm..
I've not used security much, so I'm flying blind here!
What I think you need to do is:
In a test database, create a link to the table in the secured database using the standard "Create New->Linked Table" option in the access window.
Now press ctrl&G to go to the debug window and type:

?currentdb.tabledefs("tblLinked&quot.connect

and you will get the full connect statement, including passwords, etc, that you need to specify in your opendatabase method.

If this doesn't work, then bypass this step totally by having the update routine look in a text file for the latest version number.
If you increase the number in the text file each time you create a new version, then that would do the trick.

HTH

Ben ----------------------------------------
Ben O'Hara
Home: bpo@SickOfSpam.RobotParade.co.uk
Work: bo104@SickOfSpam.westyorkshire.pnn.police.uk
(in case you've not worked it out get rid of Sick Of Spam to mail me!)
Web:

http://www.RobotParade.co.uk

----------------------------------------