I need to run a macro in an access database on a server from vb.,net.
The following code works if the macro is in a local database. If it is on the server.I get: Microsoft Office Access can't open the database because it is missing, or opened exclusively by another user.
What do I need to do to get this to run the macro from the mdb on the server?
Private Sub RunPickAccessMacro(ByVal sMacro As String)
Dim oAccess As Object
oAccess = CreateObject("Access.Application")
oAccess.Visible = False
Catch e As Exception
sErrNo = Err.Number.ToString
sError = "RunPickAccessMacro " & vbCrLf & Err.Description & " " & "ErrNo: " & sErrNo
oAccess = Nothing