Access XP >> 2000 >> 97

I have on my machine Acc2003, AccXP, Acc2000 and Acc97. Each customer and
its needs...
I have written a small application in Acc2000 and it was also opened with
AccXP (Acc2000 File format) Then I realised my customer had only Acc97. I
did the conversion from AccXP AND from Acc2000 and every time I try to open
a form in Acc97 I get a crash message and Access closes.
Is there a way to convert it to prior Access version that works?

-- 
(�`�.��.���`�.��.->YmK<-.��.���`�.��.���)

Yaacov Klapisch
VB/Access Programmer - System Admin.
y@klapisch.net


0
YmK
3/2/2004 1:48:47 PM
access.conversion 3038 articles. 0 followers. Follow

5 Replies
674 Views

Similar Articles

[PageSpeed] 47

If you have ADO code in your 2000 app, it will not be converted backwards
into 97.  That means you would either have to re-write it in DAO or set a
reference to ADO in Access 97. I don't know if ADO was included in Access97.
Since I have 97 and 2000 on my system, I have them in the references.  You'd
have to find out if they have ADO on their system and if so, what version.
If it is pre-ADO 2.0, you still may have some coding issues.

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org

"YmK" <y@klapisch.net> wrote in message
news:OTXNE0FAEHA.1456@TK2MSFTNGP09.phx.gbl...
> I have on my machine Acc2003, AccXP, Acc2000 and Acc97. Each customer and
> its needs...
> I have written a small application in Acc2000 and it was also opened with
> AccXP (Acc2000 File format) Then I realised my customer had only Acc97. I
> did the conversion from AccXP AND from Acc2000 and every time I try to
open
> a form in Acc97 I get a crash message and Access closes.
> Is there a way to convert it to prior Access version that works?
>
> -- 
> (�`�.��.���`�.��.->YmK<-.��.���`�.��.���)
>
> Yaacov Klapisch
> VB/Access Programmer - System Admin.
> y@klapisch.net
>
>


0
Roger
3/2/2004 6:43:40 PM
Thanks for the reply.
I don't think it is an ADO problem. The bug is on my computer and I for sure
have the references.
Even if it was, I cannot get to the code window. I get the crash message
when I open the form or module.

"Roger Carlson" <NO-carlsoro-SPAM@hotmail.com> wrote in message
news:ODRDJZIAEHA.3400@tk2msftngp13.phx.gbl...
> If you have ADO code in your 2000 app, it will not be converted backwards
> into 97.  That means you would either have to re-write it in DAO or set a
> reference to ADO in Access 97. I don't know if ADO was included in
Access97.
> Since I have 97 and 2000 on my system, I have them in the references.
You'd
> have to find out if they have ADO on their system and if so, what version.
> If it is pre-ADO 2.0, you still may have some coding issues.
>
> -- 
> --Roger Carlson
>   www.rogersaccesslibrary.com
>   Reply to: Roger dot Carlson at Spectrum-Health dot Org
>
> "YmK" <y@klapisch.net> wrote in message
> news:OTXNE0FAEHA.1456@TK2MSFTNGP09.phx.gbl...
> > I have on my machine Acc2003, AccXP, Acc2000 and Acc97. Each customer
and
> > its needs...
> > I have written a small application in Acc2000 and it was also opened
with
> > AccXP (Acc2000 File format) Then I realised my customer had only Acc97.
I
> > did the conversion from AccXP AND from Acc2000 and every time I try to
> open
> > a form in Acc97 I get a crash message and Access closes.
> > Is there a way to convert it to prior Access version that works?
> >
> > -- 
> > (�`�.��.���`�.��.->YmK<-.��.���`�.��.���)
> >
> > Yaacov Klapisch
> > VB/Access Programmer - System Admin.
> > y@klapisch.net
> >
> >
>
>


0
YmK
3/3/2004 6:18:31 AM
Hello Yaacov,

Thank you for posting in the community.

First of all, I'd like to confirm my understanding of your issue. 

From your description, I understand that you have multiple versions of 
Access on your machine. The application/project was written in Acc2000 
and opened with AccXP. After that, you converted it from AccXP to Acc2000, 
and finally to Acc97 for your customers' benefits as they have only Acc97. 

Have I understood the issue correctly and completely? If there is anything I 
misunderstood, please feel free to let me know. 
 

I agree with Roger that you might meet with the code issue as the default 
interface for new database created in Access 2000 is ActiveX Data Objects 
(ADO) but the previous version used Data Access Object (DAO). For the 
first time Access allows you to convert to Acc97 from Acc2000. 

However, only modules that were written in Data Access Object (DAO) can 
be converted to an earlier version with no problem. We cannot guarantee 
the code written in ADO will work flawlessly if it is converted from Acc2000 to 
Acc97 even though the ADO library is referenced. 

If you have made sure that this was not the ADO problem, could you help 
create a new Acc97 database, import the objects into that new database, 
and reference the needed library to see if the form can be normally 
opened. 

On the other hand, please specify the crash message so that we can 
isolate the issue more easily and quickly. If there is any update or further 
information you can provide, please feel free to post them in the 
newsgroup. Thanks in advance!

Best regards,

Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.



0
v
3/3/2004 2:09:21 PM
Thanks for your care.
It is almost as you described it.
I didn't "Convert" it to AccXP but only opened it with AccXP as a Acc2000
file format.
This is the message I get:
Microsoft Access has encountered a problem and needs to close. We are sorry
for the inconvenience.

 The Error signature is:
AppName: msaccess.exe AppVer: 8.0.0.4008 ModName: msaccess.exe

ModVer: 8.0.0.4008 Offset: 001a24a2

Do you want me to send you the dump file?
There is no ADO code in these forms only the "MoveNext" code of standard
buttons created with the wizard.
Maybe it is the TabControl I have on the form that makes the problem?


-- 
(�`�.��.���`�.��.->YmK<-.��.���`�.��.���)

Yaacov Klapisch
VB/Access Programmer - System Admin.
y@klapisch.net

""Billy Yao [MSFT]"" <v-binyao@online.microsoft.com> wrote in message
news:6JLrkkSAEHA.612@cpmsftngxa06.phx.gbl...
> Hello Yaacov,
>
> Thank you for posting in the community.
>
> First of all, I'd like to confirm my understanding of your issue.
>
> From your description, I understand that you have multiple versions of
> Access on your machine. The application/project was written in Acc2000
> and opened with AccXP. After that, you converted it from AccXP to Acc2000,
> and finally to Acc97 for your customers' benefits as they have only Acc97.
>
> Have I understood the issue correctly and completely? If there is anything
I
> misunderstood, please feel free to let me know.
>
>
> I agree with Roger that you might meet with the code issue as the default
> interface for new database created in Access 2000 is ActiveX Data Objects
> (ADO) but the previous version used Data Access Object (DAO). For the
> first time Access allows you to convert to Acc97 from Acc2000.
>
> However, only modules that were written in Data Access Object (DAO) can
> be converted to an earlier version with no problem. We cannot guarantee
> the code written in ADO will work flawlessly if it is converted from
Acc2000 to
> Acc97 even though the ADO library is referenced.
>
> If you have made sure that this was not the ADO problem, could you help
> create a new Acc97 database, import the objects into that new database,
> and reference the needed library to see if the form can be normally
> opened.
>
> On the other hand, please specify the crash message so that we can
> isolate the issue more easily and quickly. If there is any update or
further
> information you can provide, please feel free to post them in the
> newsgroup. Thanks in advance!
>
> Best regards,
>
> Billy Yao
> Microsoft Online Support
> ----------------------------------------------------
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>
>
>


0
YmK
3/3/2004 8:36:47 PM
Hi Yaacov,

Thanks for your update and further information! 

The error signature seems to be no help on troubleshooting the issue. 
However, you confirmed you didn't convert the VBA project (or the whole 
database) to AccXP, instead you only opened it as the Acc2000 format.

Based on your clarification, I assumed that you convert the Acc2000 
database to Acc97 using AccXP, am I right? If that, I suspect that the VBA 
project was corrupt after you used AccXP to convert it to Acc97 version 
from Acc2000 file format.

I'm not sure if you have tried to import the form and its underlying data 
sources to a new created database, and what's result? If you haven't, we 
recommend you do this import operation to see if the form can be opened. 

For more methods to troubleshoot the database corruption issue, please 
read the following articles: 

279334 ACC97: How to Repair a Damaged Jet 3.5 Database
http://support.microsoft.com/?id=279334

209137 ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 
Database
http://support.microsoft.com/?id=209137


Please apply my suggestions above and let me know if this helps resolve 
your problem. Thanks for your patience and cooperation!


Best regards,

Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.


0
v
3/4/2004 1:57:05 PM
Reply:

Similar Artilces:

Hyper Link in Outlook 2000
We are using Microsoft Outlook 2000 as Mail Clients. If I sent an Excel file as hyperlink (Internally)and when the Recipient click on the hyperlink, the excel file opens in Internet Explorer. Is there any configuration that when the recipient click on the link it opens in excel? Thanks in advance Diwakar ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ...

Outlook Web Access AutoSignature
I would like to know if it's possible to have autosignature in Outlook Web Access, and if so how to implement it. If anyone can help, it would be greatly apreciated. Thank You. It depends on the version of Exchange - Outlook Web Access is a function of Exchange, not Outlook. Exchange 2003 does this natively, previous versions may have a third party add-in that will allow users to do this. For better information, post in an exchange group such as microsoft.public.exchange.admin. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due t...

Restricting access to note attachments
Hi all, is there a way to restrict access to attachments on notes to specified users. I know we can, using the Security Roles, define who can and can't read/ write the notes fields but we would like our users to be able to view the note, but not open the attachment(s) unless they are the owner of that note (or at least in the business unit, etc.). I know this could be done for Word/ Excel files in Office (Password protection) but are looking for something more encompassing for all attachments inside CRM. Thanks, -- Matt Pring On Oct 21, 3:54=A0pm, Matt Pring <MattPr...@discus...

Problem with latest version of Outlook under XP
This problem is occuring at a friend's local military medical facility: In outlook if you open a new e-mail message and want to task someone, there is a message flag (Red Flag Icon) option. Until recently, when we did this a new task would be generated in the sender's task list. Now all of a sudden it does not work anymore. The task just doesn't show up in any view mode. Any help would be appreciated. ...

Formatting/style master in Excel XP
Good afternoon, Can anyone tell me if there is a way to set up a master sheet (like the 'slide master' in PowerPoint) with formatting that would carry through to all the sheets within a workbook (ie: column fill, text formatting)? Thanks, Cheryl Cheryl, I don't know about Powerpoint, but in Excel you can group worksheets by Ctrl-clicking the sheet tabs. Then just about everything you do - formatting, entering data etc, - will be reflected on all grouped sheets. Don't forget to ungroup when you're done. See Excel Help for more help. HTH Anders Silv�n "Cheryl&q...

Inserting picture from file in Publisher 2000
I installed a trial Pub 2007 and when it ran its course I uninstalled it and reinstalled Publisher 2000. Since doing this I cannot insert a picture other than clipart, ie. I can't insert a picture from my files or internet. I get a message saying Pub doesn't recognise the format or there was an error loading a graphic converter. Some of the graphics converters may be missing. Run setup again. Well I've tried the 'repair' from setup again but still no joy. Can anybody help? I'm not too good with these problems so can you keep it simple for me? -- Ruth The graph...

Access 2003 and Access 2007 Synchronization
I'm setting up a new business relationship with a company in Portugal. They use Access 2003. I have just bought MS Office Professional 2007 (with Access 2007). Our plan is that they will send, once a month or so, their Access db then we will update and add to that db and then return it after another month or so. There probably won't be a lot of updates on our end so the monthly cycle should work. After they synchronize, they will send a new version of the db and we will start over. My goal is to keep everything as simple as possible partially because I don't know how skillf...

Excel Row to Access Columns
Hi, I have a single row in Excel with a lot of data, what I need to do is move that to a column in Access. I need some way to automate that. I know the easiest way to do that would to just transpose it in excel and then import in access.But I cant do that as I just get that excel file with one row and I need some way to automate the process in Access. thanks m -- mk389 ------------------------------------------------------------------------ mk389's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15272 View this thread: http://www.excelforum.com/showthread.php?...

Help displaying a random record in a form--Access newbie
Hello, I am new to Access, so if anyone can help me, please assume I know absolutely nothing! I currently have a table with two columns, ID and CHORE. In each row, the ID number corresponds to a chore that I have entered. I would like to create a form with a button and a text field such that when I press the button, a random chore is displayed in the text field (supposed to make chores more "fun" for my son). There is no need to remove this record from future clicks (the same record can come up over and over without any problem for me) Can anyone explain to me (in pai...

Access
Hi My form takes a few moments to load up as it is fairly substantial SQL statement is there a way to get something to display a graphic or 'loading...' message to appear why it calculate the contents? Steve ...

Moving contacts to Exchange 2000 Enterprise Server
Does anyone know an easy way to move my smtp addresses from CCmail 8.2 address book (about 400 of them) over to contacts in Active directory. I am running Windows 2000 Server and Exchange 2000 Enterprise Server. Cheers Crazy cc:Mail's export command with the /DIRECTORY switch can export them in an quasi - ldif format which could be massaged and used with ldifde to import. cc:Mail's Import/Export users guide will help on the export start with 237677 Using LDIFDE to import and export directory objects to Active Directory http://support.microsoft.com/default.aspx?scid=kb;EN-US;...

mspub 2000
When I create a blank publication ansd then go to tools - options mspun causes an error and has to close, and a log is created by drwatson. I have uninstalled and re- installed the product and also I have installed the latest service packs (sp3) Can any help please it driving me nuts. After managing to set up OE-QuoteFix on his new PC, Ed reads a message from dave <wi@eatonbank.cheshire.sch.uk>... > When I create a blank publication ansd then go to tools - > options mspun causes an error and has to close, and a log > is created by drwatson. I have uninstalled and re- > i...

access mail on WEB
Is there a way i can check emails from exchanger server 5.5 from an internet browser. I have Exchange 5.5 in win NT 4.0. Thanks! Yes - install OWA (Outlook Web Access) and open up the needed ports in your firewall (80 for http; better to use SSL and port 443 instead). disk0nek wrote: > Is there a way i can check emails from exchanger server > 5.5 from an internet browser. > > I have Exchange 5.5 in win NT 4.0. > > Thanks! ...

access or mount mirrored hard disks
Hi, is it possible to access a mirrored harddrive? or mount the mirrored volume by using api or mfc commands? Thank you in advance Wimpi ...

Trivia : the default desktop background for XP
That's an actual roadside picture he took while driving in Napa http://napavalleyregister.com/news/local/article_7703c8b2-03e9-11df-bb34-001cc4c03286.html HoopleHead Alert. "- Bobb -" <bobb@noemail.123> wrote in message news:u9IgsOhOLHA.2276@TK2MSFTNGP06.phx.gbl... > That's an actual roadside picture he took while driving in Napa > > http://napavalleyregister.com/news/local/article_7703c8b2-03e9-11df-bb34-001cc4c03286.html > Out of your dorm again? "Penn E. Loafer" <penn@eloafer.invalid> wrote in message news:i40rcg...

Want Publisher 2000 viewer for Office XP
I looked but could not find a download to view Publisher 2000 files on my Office XP home edition (with no Publisher software). Is this possible? Thanks for your assistance. To view any Publisher files you will need the same or later version of Publisher. There are no viewers for any version of Publisher files. Get the person who sent you the Publisher file to make a PDF and send you that. -- In addition to David's response, there is no such program as Office XP Home Edition. The *is* Windows XP Home Edition and Office XP, which came in several flavors but not "Home Edition&q...

how to change default comment format in excel (2000)
I want to change the default font for comments. I know how to do this each individual time but want to make the change permanent so I don't have to do it each time I enter a comment. Debra Dalgleish has some notes how to change the Font size at: http://www.contextures.com/xlcomments02.html#Default And she has a macro that can do more: http://www.contextures.com/xlcomments03.html#Formatted superiorparties wrote: > > I want to change the default font for comments. I know how to do this each > individual time but want to make the change permanent so I don't have to do >...

Access Database In Great Plains
I was wondering if anyone knew how to have the databases that are stored in access transfered over to great plains. I'm current running version 8.0 any help would be greatful. thanks Search Customer Source for integration Manager. MS Access databases can be used as a data source. Vincev "jake" wrote: > I was wondering if anyone knew how to have the databases that are > stored in access transfered over to great plains. I'm current running > version 8.0 any help would be greatful. thanks > > Hi Jake, Is this something you need to do regularly or is it ...

CRM v4 Accessibility Improvements
Hi all: Does anyone know if any improvements have been med to CRM v4 in the area of accessibility for handicapped users? One of my customers has a user who is blind and they need to make the software accessible to him. Thanks in advance for any and all help. John. Hi John, We have added following Accessibility features in CRM 4.0 : 1) High Contrast Mode (Tools --> Options --> General Tab --> Enable high contrast settings) 2) All the Form input elements have <LABEL FOR> to aid in screen readers. 3) All the Images have a ALT tag (for non text elements) etc. Thanks! Ma...

Upsizing Access to SQL Server 2000
Hello, I am new to SQL Server. I am trying to use the Database upsizing wizard to upsize a Access 2000 database into SQL Server 2000. They are both on the same machine (running Win 03 Server). I cannot connect to the SQL Server. Error as below: Connection failed: SQLState: '01000' SQL Server Error: 14 [Microsoft][ODBC SQL Server Driver][Shared Memory] ConnectionOpen(Invalid Instance()). SQLState: '08001' SQL Server Error: 14 [Microsoft][ODBC SQL Server Driver][Shared Memory]Invalid connection. ...

Outlook Web Access #19
We have have OWA at my work and I would like to configure Outlook 2003 to synchronize with my desktop at work, is this possible Thanks B ...

Have a user account accessible to multiple users
I have an issue where there is a user account that has multiple alias emails.(reservations@domain.com, info@domain.com, CustomerService@domain.com) I have an exchange 2003 server. My issue is that i need to have muliple users access these emails so they are never missed. What is the best way to accomplish this? I was thinking a public folder. But i want to know the best way to do this? On Sat, 12 Jun 2010 21:37:04 -0500, "Dan V" <dvalenti54athotmail.com> wrote: >I have an issue where there is a user account that has multiple alias >emails.(reservati...

Excel 2000 #6
How can I identify all cell links in a worksheet. Is there a way to list or highlight? Thanks in advance. There is a download available called "Delete Links Wizard". Find this on the MSN Excel site and download. It downloads to your desktop, you will need to copy this to your Microsoft Office folder. Then go to Tools/Add-ins and check the delete links wizard function (follow the instructions). Run the Delete links wizard on your spreadsheet. It has several options for listing and or deleting links. I have used it only a few times but I know it is safe to use to find and or delete ...

Going offline without write access to registry
I suggest that POS doesn't go offline if it can't write into registry, displaying a message box instead telling that it couldn't access the registry. What happens if the POS machine goes offline without having access to edit the registry? This typically happen when the user is a normal user (not a power user) 1. The POS application will try to connect to the server main database within the pre-configured ‘Connect Timeout’ in the RMS Administrator (Typically 15 seconds) 2. The application will then try to connect to the pre-defined offline database (which is usually stored loc...

Access 2000 problem if opened with Access 2007
Dear all, I'm running Access 2000 MDE in Access 2007. I find several header-details form (such as invoice transaction), the details form is displayed as white box without any record displayed. Is there any solution for this matter ? Thanks. Chlaris. you need to move to Access Data Projects if you want a reliable, predictable environment "Chlaris" <chlarrissa_nospam@yahoo.com> wrote in message news:ON0rS1NsHHA.3884@TK2MSFTNGP04.phx.gbl... > Dear all, > > I'm running Access 2000 MDE in Access 2007. I find several header-details > form (such as inv...