update query on external database

[accessproblems]

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 code after a button click if that makes a difference.
thanks.

 

[accessproblems]

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 am getting states:

"Unexpected error: Too few parameters. Expected 1"

 

[jardiamj]

I have done this with a MySQL database, with another Ms Access database it should be just easier.
Add to your database a table linked to the table in the external database that you want to update, and build and update query to update the records in the linked table just as you do with any other table.
I hope it will help you.
Cheers!