Results 1 to 3 of 3

Thread: Another ADO -Error

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    May 2000
    Posts
    148
    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

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    Do the other users have CHANGE permission to the directory in which the DB resides in?

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    May 2000
    Posts
    148
    yes, I still can't figure this out

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width