Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Issues after splitting data tables (97)

    I have inherited a project that contains code behind the event of a control. This one is a real challenge for me. I have an mdb and an mde that both work fine when the data tables are a part of the mdb or mde. But once split I get the following error message:
    "Error 3219:Invalid operation"

    when running this line of code:
    Set rst = dbs.OpenRecordset("tblRates", dbOpenTable)

    Why will this work when the tables are not split, but doesn't work when the tables ARE split? I don't profess to be "Access proficient" but this doesn't seem rational to me. I used Access' Database splitter to split the data.

    Any ideas?

    Thanks.

    Ken

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Issues after splitting data tables (97)

    You can only use dbOpenTable on local tables. Use dbOpenDynaset on linked tables.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Issues after splitting data tables (97)

    Charlotte,

    You are awesome. Will the dbOpenDynaset also work on local tables, or does it require the dbOpenTable always on local tables?

    Thanks again for your help.

    Ken

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Issues after splitting data tables (97)

    dbDynaset opens an editable recordset. It will work on local or attached tables. If you don't need to edit the recordset but just want to read it, use dbOpenSnapshot, which takes fewer resources.
    Charlotte

Posting Permissions

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