Distibute FE Updates

abbaddon223

Registered User.
Local time
Yesterday, 22:55
Joined
Mar 13, 2010
Messages
162
Hello all - I'm hoping someone can help me please?

I have a terminal server with multiple users working on an FE / BE database. Each user has their own FE (I know they can work off one on terminal services - I won't bore you with why they each have one).

When I make a change to an FE, I need to currently get all users to logout, delete the old FE then paste in the new one (sigh).

Is there a way I can create 1 FE (say FE_Master), and make changes to this. When users logout then back in on their own FE, it picks up the updates....?

Thanks in advance for any help.

(PS. it's full Access 2010 - not runtime)
 
Hi Paul - I've not no. Thank you for responding - I'm off to take a look now
 
Hi Paul - this looks really good and I've just put it onto my TS - however at the enclosed lines in the utility:

Private Declare Function SHGetPathFromIDList Lib "shell32.dll" Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long

Private Declare Function SHBrowseForFolder Lib "shell32.dll" Alias "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) As Long

the following error

Compile Error:

the code in this project must be updated for use in 64-bit systems. Please review and update declare statements and then mark with them with the PtrSafe Attribute.

I take it this was written for 32-Bit - but not I'm not sure how to fix this if you can help at all please?

Thanks,

Phil.
 
The 64-bit version uses a Pointer Safe declaration.. Nothing much.. Just Declare the functions PtrSafe..
Code:
Private Declare [COLOR=Red][B]PtrSafe[/B][/COLOR] Function SHGetPathFromIDList Lib "shell32.dll" Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As [COLOR=Red][B]Long[/B][/COLOR]
Private Declare [COLOR=Red][B]PtrSafe[/B][/COLOR] Function SHBrowseForFolder Lib "shell32.dll" Alias "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) As [COLOR=Red][B]Long[/B][/COLOR]
Are you using the systems on both 32 and 64 or just 64 bit? If so you might have to use If Else directive..
 
Right - well that got rid of the error - thanks very much again for your kind help - off to do the fun bit now and try to get it going!

Thanks again!

Phil.
 
Glad to hear you got it working Phil.. Good Luck..
 

Users who are viewing this thread

Back
Top Bottom