I'm afraid that while people here will be happy to offer advice, I doubt
that anyone will be prepared to look at your database unless you are willing
to pay them.
Lots of bits and bobs have been added to Access between Access 97 and Access
2003, and none of them will work in Access 97 because they don't exist in
Access 97. Your challenge is to find out what later feature you have used
which doesn't exist in Access 97. It seems like you know which form is the
problem, so I would suggest (i) make a backup copy of the form with a
different name (ii) with the original form, start removing things one at a
time until the problem goes away. I would start with the code module, if
there is one. If the problem goes away, then reinstate the module and start
removing procedures one by one. When you find the offending procedure,
start commenting out lines until you find the problem.
If it isn't the code module, start removing controls one by one until the
problem goes away. Once you have found the offending control, open the form
in design view side-by-side in Access 97 and Access 2003, and compare the
property sheets for the control to see what's different.
Once you have found what it is that is causing the problem, I dare say
someone here will be able to advise on how to replicate this feature in
Access 97 (or at least suggest a workaround).
"murraystewart" <mu************@gmail.comwrote in message
news:11*********************@x35g2000prf.googlegro ups.com...
I have spent days building a database in access 2003 and the found it
needs to run on Access 97, I did the conversion but the form is not
opening with an error message "you loaded a form or report that has
control or properties that microsoft access does not recognize and
will ignore". have tried compacting and repairing and converting to
MDE but to no avail. Is there anyone out there who could take a look
at it. This is the first database I've ever built and it may be a
little ambitious as it is designed to link in with a Pocket PC
database built on Visual CE and sync data between. Its all working
fine except in 97.. Any help or advice would be much appreciated.