Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Brampton, Ontario, Canada
    Posts
    27

    Unanswered: Problem with code after splitting MDB

    So I went and split my DB like almost everybody I spoke to recommended.
    But now I am having PROBLEMS with my code.
    The first thing that I notice doesn't work is when my
    code tries to set an index for a recordset.
    I get the following error.
    "Operation is not supported for this type of object."
    -----Following is the code...------
    Dim dbs As Database
    Dim rst As Recordset
    Set dbs = CurrentDb
    Set rst = dbs.OpenRecordset("Orders")
    rst.Index = "Client Id" THIS IS WHERE I GET THE ABOVE MENTIONED ERROR
    strSeek = Me.Client_ID
    etc...
    -------------------------------------
    Can someone offer any ideas as to what might be the problem/solution.
    And what other issues I might run into after having split my Access2K DB.

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Problem with code after splitting MDB

    hope you are using ADO to do the recordset. Check the cursor location and other parameters for constructing a recordset. Don' rely on the defaults.


    Originally posted by BradCO
    So I went and split my DB like almost everybody I spoke to recommended.
    But now I am having PROBLEMS with my code.
    The first thing that I notice doesn't work is when my
    code tries to set an index for a recordset.
    I get the following error.
    "Operation is not supported for this type of object."
    -----Following is the code...------
    Dim dbs As Database
    Dim rst As Recordset
    Set dbs = CurrentDb
    Set rst = dbs.OpenRecordset("Orders")
    rst.Index = "Client Id" THIS IS WHERE I GET THE ABOVE MENTIONED ERROR
    strSeek = Me.Client_ID
    etc...
    -------------------------------------
    Can someone offer any ideas as to what might be the problem/solution.
    And what other issues I might run into after having split my Access2K DB.

    Thanks

Posting Permissions

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