PDA

Click to See Complete Forum and Search --> : Another ADO -Error


hyme
Aug 30th, 2000, 09:29 AM
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

Clunietp
Aug 30th, 2000, 09:41 AM
Do the other users have CHANGE permission to the directory in which the DB resides in?

hyme
Aug 30th, 2000, 10:53 AM
yes, I still can't figure this out