convert from 2000 to 97 - Microsoft Access / VBA

Tony Gambee

I have a system that we have had running for many years. We keep our
file in 2000 format, but develop in 2003 environment... ussually we
use our test computer with 2000 loaded to convert back to 97 and then
open our 97 test computer and fix references etc. recently once we
convert to 97 we can open the file but many forms are corrupt. Does
any one have any advice on this?

Tony

Nov 13 '05 #1

Subscribe Reply

1880

Allen Browne

The backward conversion process should work okay. I'm guessing that the
corruption is already present, and is just being exposed by the conversion.

To avoid the corruption:
1. Make sure all your databases have Name AutoCorrect disabled. Explanation:
http://allenbrowne.com/bug-03.html

2. Decompile a copy of your database before you convert it back to A97.
That's a matter of entering something like this at the command prompt, while
Access is not running. It's all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.mdb"
Then compact: Tools | Database Utilities | Compact.

3. Make sure you have SP3 for your Office 2000 machines, and JET 4 SP8
installed on both your Office 2000 and 2003 machines. The service packs can
be downloaded from:
http://support.microsoft.com
and the JET s.p. is downloaded and applied separately.

4. More general ideas on avoiding corruption:
http://allenbrowne.com/ser-25.html

The other important factor is that you must use the DAO 3.5x library in A97,
not 3.6. More info on references:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tony Gambee" <to**@camptrak. com> wrote in message
news:eb******** *************** ***@posting.goo gle.com...

I have a system that we have had running for many years. We keep our
file in 2000 format, but develop in 2003 environment... ussually we
use our test computer with 2000 loaded to convert back to 97 and then
open our 97 test computer and fix references etc. recently once we
convert to 97 we can open the file but many forms are corrupt. Does
any one have any advice on this?

Tony

Nov 13 '05 #2

Similar topics

67390

How to convert datetime from text/char to datetime

by: Loi Tan Vo | last post by:

Hi, I have a text file that contains a date column. The text file will be imported to database in SQL 2000 server. After to be imported, I want to convert the date column to date type. For ex. the text file look like Name date Smith 20003112

Microsoft SQL Server

26303

How to convert to regular text, data stored in Image data type field ????

by: SD | last post by:

Hi, This is driving me nuts, I have a table that stores notes regarding an operation in an IMAGE data type field in MS SQL Server 2000. I can read and write no problem using Access using the StrConv function and I can Update the field correctly in T-SQL using: DECLARE @ptrval varbinary(16) SELECT @ptrval = TEXTPTR(BITS_data)

Microsoft SQL Server

7702

convert Access 2000 db back to Access 97

by: Gary Dale | last post by:

I have a database that was originally set up in Access 97 (because that was what we had in the office). We had a copy of Access 2000 set up on one machine for a brief period to get at another database that required it. Unfortunately someone used that machine and "upgraded" the Access 97 database to Access 2000. Now I'm trying to get it back to Access 97 but the "convert to prior version" function keeps telling me that it can't convert...

Microsoft Access / VBA

7227

Convert Access 97 to 2000

by: Derek Riley | last post by:

I have been using Access97 for some time now and decided to upgrade to 2000, the problem is when I convert it to 2000 I get the following message "There were compilation errors during the conversion" it looks like it is due to the DAO 2.5/3.5 reference. Is there a conversion utility that I can run to convert it to DAO 3.6 to run in Access 2000 There seems to be a lot of changes required in the module where it is using

Microsoft Access / VBA

2213

A2003 - option to convert

by: dixie | last post by:

Can someone familiar with Access 2003 please answer this question? I am asking because I don't have the use of A2003. When Access 2003 finds an Access 2000 database, does it come up with some sort of question/suggestion indicating that you can convert this datbase into the new format? I am trying to trouble shoot a remote site where a big error message indicating the database was converted using the wrong method comes up when they try to...

Microsoft Access / VBA

2024

Convert (sorted) list of dics to nested list ?

by: shearichard | last post by:

Hi - I want to take something like ... lstIn = lstIn.append({'COM_AUTOID': 1, 'PRG_AUTOID': 10, 'LEA_AUTOID': 1000}) lstIn.append({'COM_AUTOID': 1, 'PRG_AUTOID': 11, 'LEA_AUTOID': 2000}) lstIn.append({'COM_AUTOID': 1, 'PRG_AUTOID': 11, 'LEA_AUTOID': 2001}) lstIn.append({'COM_AUTOID': 1, 'PRG_AUTOID': 11, 'LEA_AUTOID': 2003}) lstIn.append({'COM_AUTOID': 1, 'PRG_AUTOID': 12, 'LEA_AUTOID': 3000}) lstIn.append({'COM_AUTOID': 1,...

Python

2577

Periodic prompt to Convert database

by: melickas | last post by:

We designed a custom application using Office Developer Tools '97 which included a Run-time version of Access--- so it would not matter if our customer even had any version of Access on their computer. The application ran without problems on our customer's computer for 2-3 years. Then our customer bought a new computer and we had to reinstall the application. Everything was ok for approximately 6 months until our customer was "cleaning up"...

Microsoft Access / VBA

5735

Convert Date to Short formate

by: aqmaiya | last post by:

Hello, there is string value 'Dec 06, 2000' I want to convert that string date to SHORT FORMAT like '2000-12-06-. Please help me how do I do that? I'm new in Jython. Thanks, aqmaiya

Python

2230

Convert A97 to A2000 or A2002 ?

by: tombsy | last post by:

Hello Group. I work for a company who is about to embark on a long awaited Office upgrade from Office 97 to Office XP. Office XP comes with Access 2002. I am an accomplished Access developer so I have read up on the complexities of upgrade in the corporate environment. Also the need to carry out a full MDB audit to get rid of the redundancy etc etc

Microsoft Access / VBA

9453

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10099

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9904

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8929

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7451

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6710

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4007

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3607

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2849

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General