Develop in 2003 - Deploy in 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Robichaud - 19 Mar 2006 07:26 GMT

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.

Reply to this Message

Sylvain Lafontaine - 24 Mar 2006 05:14 GMT

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.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> 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
[quoted text clipped - 11 lines]
>
> Thanking you in advance.

Reply to this Message

Robert Robichaud - 25 Mar 2006 04:25 GMT

Sylvain,

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

Thanks again.

> If your problem about Access 2003 or about Access 2000?
>
[quoted text clipped - 22 lines]
>>
>> Thanking you in advance.

Reply to this Message