Hi folks,

I have a add ins database called AddIns.mde which has a formA and a tableA.
When I added it to my new database via add-in manager. The formA cannot
update the data in tableA. It updated the data in tableB which is in new
database. Could anyone show me how to update the data in tableA via formA.
I spent couple days on the problem but in vain. Please help.

Thanks in advance.
Tim.

Hi Chris,

It works great. Thank you very much for your help.

Tim.

"Chris O'C via AccessMonster.com" wrote:

> Use codedb, not currentdb to update a table in the library db. All one line:
>
> codedb.execute "update tablename set field1 = 42", dbfailonerror
>
>
> Chris
> Microsoft MVP
>
>
> Tim wrote:
> >Hi folks,
> >
> >I have a add ins database called AddIns.mde which has a formA and a tableA.
> >When I added it to my new database via add-in manager. The formA cannot
> >update the data in tableA. It updated the data in tableB which is in new
> >database. Could anyone show me how to update the data in tableA via formA.
> >I spent couple days on the problem but in vain. Please help.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200808/1
>
>