functions

  • Thread starter Thread starter JOHN SMITH
  • Start date Start date
J

JOHN SMITH

Hi,

On my Client DB i would like to run a Function on the Server DB??

Function getData()
On Error GoTo Err_UpdateServer
Dim objAccess As New Access.Application
Dim TS_Server
TS_Server = Application.CurrentProject.Path & "\TS_Server.mdb"
With objAccess
.run my function????
.CloseCurrentDatabase
End With
Exit_UpdateServer:
Exit Function
Err_UpdateServer:
MsgBox Err.Description & " " & Err.Number

End Function

Thank you all
 
Hi John,

does the function exist in the server side mdb and you are running a
client-side mdb as well (front-end /back-end access configuration)?, the way
I get this to work is actually execute the server mdb on the server (from
the server console), have a worker table waiting for work, in the back-end
have the server mdb view that table every x seconds/minutes with a hidden
form, looking for work to do, there may be other ways to get this to work, I
have been using the above method for years and it gives the appearance of
the client/server model without being one, e.g. execute small code on the
front-end and process large amounts of data on the server. This method can
cut down the network traffic considerably.

I hope I have answered your question.
 
Back
Top