Problem with update and delete

F

Florin

Hi,

I'm building an aplicattion in access 2002 and function very well on three
PC.
Soon I installed on other PC (with access2002 also) and problem is that no
function delete and update!
Mention that is make with
DoCmd.OpenQuery "queryname"
and
DoCmd.UpdateQuery "queryname"
I verify in VB in Tools\References and everything is ok.

I repeat, is the same aplicattion !!


Any ideas?

Thanks,
 
J

John W. Vinson

Hi,

I'm building an aplicattion in access 2002 and function very well on three
PC.
Soon I installed on other PC (with access2002 also) and problem is that no
function delete and update!
Mention that is make with
DoCmd.OpenQuery "queryname"
and
DoCmd.UpdateQuery "queryname"
I verify in VB in Tools\References and everything is ok.

I repeat, is the same aplicattion !!
Click to expand...

Do you have the same permissions (read/write/create/delete) on the database's
folder on both computers? What happens when you try to run the query? If
there's an error message... what's the message? Or does it just do nothing, or
crash Access, or what?
 
F

Florin

Thanks,

I will check the permissions on the database's folder. The computer problems
is in another place.
No nothing happens when I try to run query , no crash , but no delete , no
update too.
 
Top