Access Forms buttons will not work in XP

[Kevin Mendonsa]

I have migrated an Access application from Access97 to
Access 200 and it worked fine on the 2000 Professional.
Hoever if I use the application in the XP operating
systems with Access 2002 the buttons do not work and most
of it fails to function properly.

Any ideas what the problem might be.

Thanks,
Kevin

[John Vinson]

On Tue, 29 Jul 2003 16:52:32 -0700, "Kevin Mendonsa"
<kevin.mendonsa@itt.com> wrote:

>I have migrated an Access application from Access97 to
>Access 200 and it worked fine on the 2000 Professional.
>Hoever if I use the application in the XP operating
>systems with Access 2002 the buttons do not work and most
>of it fails to function properly.
>
>Any ideas what the problem might be.

Something wrong with the code.

Care to share with us what error messages you're getting, or the
symptoms? "Doctor, I don't feel good" isn't going to get you an
accurate diagnosis!

One thing to check is References. Open the VBA editor and select
tools... references from the menu; be sure that Microsoft DAO 3.6
Object Library is checked, if (as is very likely given that this came
from A97) you're using the DAO object model. AccessXP (like 2000)
defaults to the newer ADO object model; if you're not intentionally
using ADO code, uncheck the ActiveX Data Objects reference.

Compile the program (with Debug... Compile <yourdatabase>) and correct
any compilation errors; then compact and repair the database. See if
that helps!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]