Recent content by GreenWinter

  1. G

    Cannot OpenRecordset on back-end database

    Thanks for your advice. I will change the table structure as what you said. But I'm still unsure about the issue in my post. Could you please explain the mechanism behind?
  2. G

    Cannot OpenRecordset on back-end database

    Yes. The query I used is to add fields to the table which I think cannot be implemented from FE. So I wanted to alter the BE table directly. I'm a beginner in ACCESS. Please point out if anything wrong with me. Thank you!
  3. G

    Cannot OpenRecordset on back-end database

    I split database into front and back ends. When I try to open the record in back-end, I get run-time error 3011 saying database engine could find the table "tbl_GL_0050_Daily" with the line Set rs = dbs.OpenRecordset("tbl_GL_0050_Daily") highlighted. If I comment the DoCmd.OpenQuery...
  4. G

    Hello

    I'm a fresh employee in NY who recently got in touch with Access. Wish to get help and discuss with you guys here.
See more
Back
Top Bottom