|
|
Conversion between Access 2002 and 2003 only via 2000?
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: rkraft@ns.merlinus.com
--Remove ns from address--
=======================
|
|
0
|
|
|
|
Reply
|
Renee
|
8/6/2004 10:52:18 PM |
|
|
0 Replies
111 Views
(page loaded in 1.998 seconds)
Similiar Articles: Save As 2002-2003 in 2007 - microsoft.public.access.conversion ...Save As 2002-2003 in 2007 - microsoft.public.access.conversion ... it, it will only save as a copy and defaults to Excel 93-2003 ... ... the Access 2000 or Access 2002 - 2003 ... Conversion from access 97 to 2002/ DAO 3.51 to 3.6 - microsoft ..."Michael Jones via ... Library, then you can only open databases in the JET 3.5 (Access 97 ... ... Access 2000, 2002, and 2003 let you convert a ... DAO 3.51 Library ... The current user account doesn't have permission to convert or ...... enabled group visible only ... Access 2002 (XP) to Access 2003 - microsoft ... have no permission to convert or enable the database when you open a database in Access 2000 ... How to programmatically convert a database - microsoft.public ...... wants to upgrade from Access 97 to 2003 and they need to convert ... user computer withOUT ACCESS-2000 installed (JetEngine and MDAC 2.8 ONLY) ? ... sort" programmatically via ... Access 2007 problem with 2003 database - microsoft.public.access ...... user access on MS Access 2003 ... Current problem is that only 1 ... can convert a database that was created by using Microsoft Office Access 2003, Access 2002, Access 2000 ... Access 2003 Upsizing Wizard does not work. - microsoft.public ...I can link them to Access via ODBC and it works. ... Access 2000 Controls Wizard Not Working... - microsoft ... Upsizing Wizard in Access 2002, Access 2003 or Access 2007 ... Distributing MDE Front-End / Access 2007 - microsoft.public.access ...... access 2007, it not possible. You an ONLY ... Access 2007: 1. Save as 2002-2003 ... via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion ... Upgrade from Access 2003 to 2007 - microsoft.public.access ...... several users from either Office XP and 2003 Pro to Office 2007 Pro via the ... To convert an Access 2000 or Access 2002 - 2003 database (.mdb) to the Access 2007 file ... Save 2007 Database in 2003 format with VBA - microsoft.public ...Save As 2002-2003 in 2007 - microsoft.public.access.conversion ... ... Compact Access Database from Excel via VBA ... either the Access 2000 or Access 2002 - 2003 ... converting the digits to indian currency format digit - microsoft ...... End Function John Spencer Access MVP 2002 ... The same I tried in Access 2000, but it produc ... Scientific Notation ... 1st of all, only the first 15 digits will convert. Convert a database to the .accdb file format - Access - Office.comConvert an Access 2000 or Access 2002 - 2003 database to the .accdb format. To convert an Access 2000 or Access 2002 - 2003 database (.mdb) to the .accdb file format, you ... Access File Formats: ACCDB vs MDB - About Databases: Microsoft ...... upon the version of Access used to create the file, you may be required to convert. Here are the specifics: Access 2002-2003 ... Access 2000 databases may be ... Access 2007... Access 2003, the database can only be opened by Access 2002 or Access 2003. To convert an ... To convert an Access 2000 or Access 2002 ‐ 2003 ... Transitioning Your Existing Access Applications to Access 2007You should not convert a database to the .accdb format if people who are using Access 2003 ... write Access 2000, Access 2002, and Access 2003 ... you know that only Access ... Convert access 2003 to access 2010I'm planning a conversion of access 2003 to access 2010 and I ... UI is significantly different from 2000/2002/2003, so ... only convert to .accdb format if you need features ... 7/30/2012 12:02:25 PM
|
|
|
|
|
|
|
|
|