I have a bound form in Access 2000

[yaya013]

I have a bound form in Access 2000 Project to table In SQL 2000 when the user try to Delete a record in the form Access is freeze
and i must use ctl + alt + delete

In My computer its working just fine

Any sugestions?

Thanks,
Yair

 

[Kocheace]

yaya013:

Make a copy of the form and paste it with a new name. It's simple I know, but it works sometimes!

You mention " In my computer its working just fine". Do you mean on the pc where SQL Server is installed? Please clarify.



Say 'ello..... to my little friend!

 

[yaya013]

in my Office, on 3 different pc its working ok.
Each pc has the SQL installed.
I will try you'r idea.

Thanks

 

[Nowell]

Hi,

So it works on three machines and not on your one.

Check the versions of MDAC on each machine.

XP comes with MDAC 2.7, also check the office service packs.

You should not need to install SQL server on each machine only Office.