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...
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...