Recent content by accessproblems

  1. A

    update query on external database

    sorry i forgot to mention that: I am updating an external mde file not the one that contains the vba code. i currently have something like this: Dim dbname as Database Set dbname - OpenDatabase(Location, Nothing False) dbname.Execute("Update tblName Set tblField = "" 'Text' """) the error i...
  2. A

    update query on external database

    Hi, I am having a problem and i am pulling my hair out. what i need to do is: have an update query to update a 1 field in an external table. its really simple, no where clause no inner joins. but i just cant get it working no matter which way i try. has anyone done this before? i just run the...
Back
Top Bottom