-
Howdy!
When I run my program on a Term-Server (Win-NT,CITRIX)
I get an "Unspecified Error" when trying to open the database.
If I am logged in as the ADMIN it works fine, but if I log in as anyone else I get the error.
What is wrong with this code?
Dim Cn As New ADODB.Connection
Dim Cmd As New ADODB.Command
Dim rs As New ADODB.Recordset
Cn.Open "Provider=Microsoft.Jet.OLEDB.3.51;DataSource=C:\Test.mdb"
rs.Open "select * from Table1", Cn, adOpenForwardOnly, adLockOptimistic
Thanx
-
Do the other users have CHANGE permission to the directory in which the DB resides in?
-
yes, I still can't figure this out
