I am using the RSview32 VBA to write to a Access table. Works
great for me, however no one else can open it on the network.
Here is the code for opening and closing the DB.
Opening and writing is not a problem, for some reason i am
restricting for other users.
Any suggestions??
Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnectionString
objConnection.Open
Set objCommand = CreateObject("ADODB.Command")
With objCommand
.ActiveConnection = objConnection
.CommandText = strSQL
End With
objCommand.Execute
Set objCommand = Nothing
objConnection.Close
Set objConnection = Nothing
great for me, however no one else can open it on the network.
Here is the code for opening and closing the DB.
Opening and writing is not a problem, for some reason i am
restricting for other users.
Any suggestions??
Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnectionString
objConnection.Open
Set objCommand = CreateObject("ADODB.Command")
With objCommand
.ActiveConnection = objConnection
.CommandText = strSQL
End With
objCommand.Execute
Set objCommand = Nothing
objConnection.Close
Set objConnection = Nothing