Develop in 2003 - Deploy in 2000

[Robert Robichaud]

I've converted an Access 2000 mdb application to Access 2003 ADP with SQL
backend on Window XP SP2 platform. Deployed to client's Win 2000 running
Access 2000.

On the client's workstation when the application is adding a new record and
setting value on a database field on the main form, a series of Current
events are triggered on the 2 subforms and the main form. When control is
returned back to the next statement in the main program, it appears that
I've "lost" the record as I'm no longer able to reference any field (tied to
the database) on the form. The form displays #Name? in all the fields.

Any suggestions on what's happening or recommendations?

Thanking you in advance.

 

[Sylvain Lafontaine]

If your problem about Access 2003 or about Access 2000?

For Access 2000, don't expect any miracle: ADP 2000 is full of bugs and I
forbid my clients to use any (of my) ADP applications with it or with ADP
2002.

In your case, if you make a direct transfert from A2003/WinXP SP2 to
A2000/Windows 2000, then you must not forget to decompile the application
before using it. However, even after the decompilation, the chance are high
that you will still have a lot of problems with ADP 2000.

 

[Robert Robichaud]

Sylvain,

Thank you for your input. My issue is with Access 2000 and based on your
comments, I'm on my own.

Thanks again.