Forms import problem

[smwabill]

Need help on this one.

We have Access97 and Access2000 and here is the problem.

1. We are trying to import a form from a database in 97 to 2000 and it says that the underlying code is corrupt and therefore won't let us import.

2. However, we use the 97 database program everyday and it works like a charm and never gives us an error.

3. I've run repair and compaction and still it doesn't change the import outcome. I looked for corruption and couldn't locate anything and are wondering if it is just how Acc2000 is handling code differently.

4. I notice Acc2000 is a little stiff in certain ways.

Question: Is there a new version of Access that will definitely handle this problem of importing, if so I'll go and buy it. But, before I throw good money after bad I want someone in the know to tell me that this is the correction solution?

p.s. forms are too involved to rebuild and want to transfer them.

Thank you.
smwabill

 

[dcx693]

I don't know what the particular problem is in this case, but in lieu of anything better, you could try to work around this issue by importing the other object in one operation, then importing the problem form separately.

Make a copy of the original form. Using the copy of the form, go into design view, and view the form's property sheet (if it's not visible, go to the View menu and choose Properties). Click on the "Other" tab and for the last item "Has Module" change it to No. You'll get a warning that proceeding will delete all your code. That's OK since you're working with a copy of the original form. Now import the form without any code. That should work fine.

Now, go back to the original form, go into the code view (go to the View menu and choose Code). Copy all the code. Open the form that you just imported into Access 2000 (the one with no code). Now paste the code you just copied from the Access 97 version of the form into the Access 2000 version. Now go to the Debug menu and choose Compile Loaded Modules. You should be able to troubleshoot the code from there.

 

[smwabill]

thanks but I think I realized it's 2000

I tried what you said and it said query too complex and it made me remember that I had called Microsoft in past and they said that 2000 would not hold as complex queries as 97 so there lies the root of my problem. I just wonder if new versions are equal or better than 97 in handling complex queries. thanks again.