R
Renee Kraft
I've been developing an Access database (mdb) with a SQL Server backend. In
the end, the project will be installed on mostly Access 2000 systems and a
few Access 2003 systems. I'm developing in Access 2002. Until now I had no
problems running and compiling the program for any one of the three
versions. After adding some more functionality I'm having the following
problem:
--- I copy the version from A2002 to the A2003 system. As soon as I try
to run it in A2003, it crashes. If I bypass the startup options I can access
the database window, but as soon as I try to access the VBA code, it
crashes. I've tried it with a new database in A2002, imported all objects,
recompiled, repaired... same result in A2003.
--- There's only one way around it: I can copy the version from A2002 to
the A2000 system, open and compile it there, then copy this database from
A2000 to A2003 and open it in A2003. Bypassing the startup options I can now
access and compile the code in A2003. Everything works just as it should.
--- If I use this working copy from A2003 and try to run it in A2002 I'm
having exactly the same problems as when using the A2002 copy directly in
A2003. It immediately crashes; I can't access the code. Again, the only
work-around is via A2000.
All systems have the latest Office / Windows updates and Jet 4 SP 8. I've
tried it on two different A2003 machines; all versions are connecting to the
same SQL Server database; Access 2000 format.
Can somebody help me with this? Thank you.
--
=======================
Renee Kraft
E-mail: (e-mail address removed)
--Remove ns from address--
=======================
the end, the project will be installed on mostly Access 2000 systems and a
few Access 2003 systems. I'm developing in Access 2002. Until now I had no
problems running and compiling the program for any one of the three
versions. After adding some more functionality I'm having the following
problem:
--- I copy the version from A2002 to the A2003 system. As soon as I try
to run it in A2003, it crashes. If I bypass the startup options I can access
the database window, but as soon as I try to access the VBA code, it
crashes. I've tried it with a new database in A2002, imported all objects,
recompiled, repaired... same result in A2003.
--- There's only one way around it: I can copy the version from A2002 to
the A2000 system, open and compile it there, then copy this database from
A2000 to A2003 and open it in A2003. Bypassing the startup options I can now
access and compile the code in A2003. Everything works just as it should.
--- If I use this working copy from A2003 and try to run it in A2002 I'm
having exactly the same problems as when using the A2002 copy directly in
A2003. It immediately crashes; I can't access the code. Again, the only
work-around is via A2000.
All systems have the latest Office / Windows updates and Jet 4 SP 8. I've
tried it on two different A2003 machines; all versions are connecting to the
same SQL Server database; Access 2000 format.
Can somebody help me with this? Thank you.
--
=======================
Renee Kraft
E-mail: (e-mail address removed)
--Remove ns from address--
=======================