Access conversion

[Guest]

Hi, I have created a database in Access 2000 and have sent it to a friend who
only has Access 97, and she couldn't open it. I therefore opened by 2000
version and did a conversion to a "previous version" which one has to assume
it Access 97. I sent that to her, and when she opened it, she got a message
saying: "COMPILE ERROR.......METHOD OR DATA MEMBER NOT FOUND .....(IN
FORM_SWITCHBOARD) Can you suggest what the problem might be? Thanks.

 

[Rick Brandt]

Hi, I have created a database in Access 2000 and have sent it to a
friend who only has Access 97, and she couldn't open it. I
therefore opened by 2000 version and did a conversion to a "previous
version" which one has to assume it Access 97. I sent that to her,
and when she opened it, she got a message saying: "COMPILE
ERROR.......METHOD OR DATA MEMBER NOT FOUND .....(IN
FORM_SWITCHBOARD) Can you suggest what the problem might be?
Thanks.

While it might sound odd, the conversion process merely converts the file
format. It is not guaranteed to produce a working application in the older
version because you might have utilized methods and features that do not exist
in the older version and which have no alternative method in that version.

To reliably produce files that work in multiple versions you need to develop in
the older version and convert UP.

 

['69 Camaro]

Hi.

Does your computer have both Access 2000 and Access 97 installed? If so,
then the problem is that the conversion to Access 97 still points to the DAO
3.6 Object Library on your computer, instead of the DAO 3.51 Object Library
for Access 97. Please see Tom Wickerath's tip, "ADO and DAO Library
References in Access Databases," on the following Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html

Please note the last paragraph, "Issues with the DAO library when converting
more recent database formats to the Access 97 format" for instructions on
how to easily fix this.

If your computer doesn't also have Access 97 installed, then the default
code installed by the Switchboard Wizard may have been manually altered to
include the ADO Recordset object instead of the DAO Recordset object, which
could also cause the compile error. The ADO code would have to be converted
to use the DAO Object Library, instead.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

Thanks Rick and 69 Camaro. I don't have Access 97 - just 2000. After I
converted to "previous version" I then tried to go to the properties to
change the version there too, but the whole thing hung. I spent ages
setting up and filling this database and hope that you can offer some sort of
remedy. Thanks again. Jazz

 

[M.L. Sco Scofield]

Then the fix will have to be done on the machine with Access 97.

1 - Open a code window.

2 - Tools / References

3 - Uncheck all references that have the word "Missing"

4 - Locate and check the "Microsoft DAO 3.51 Object Library"

5 - Compile and save.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

['69 Camaro]

Hi.

I don't have Access 97 - just 2000.

Then your friend will need to open her copy in Access 97 and attempt to
compile the code, fix any errors and missing library references, then
recompile again. Repeat until there are no more compile errors. Have her
follow the instructions listed in Tom Wickerath's tip that I gave you a link
to in my last post.

After I
converted to "previous version" I then tried to go to the properties to
change the version there too, but the whole thing hung.

Are you referring to the Database Properties dialog window? There's nothing
user-defined that you can modify to change the version of the database
format, including any Database Properties. When you "converted to an
earlier version," Access created an entirely new file in Access 97 format,
but kept the current Access 2K version open.

I spent ages
setting up and filling this database and hope that you can offer some sort of
remedy.

Does the Access 97 or the Access 2K format database hang whenever you open
it, or was this a one-time occurrence? If it continues to hang and you
don't have a backup of your Access 2K database, then make a copy of the file
and then compact and repair the file. If this doesn't fix the copy, then
create a new Access 2K database and attempt to import all objects, one group
at a time (tables first, then queries, then forms, et cetera) into the new
database. Compile the code in the new database and compact and repair it.
If the problem is in the Access 97 version, then you can convert to a new
copy of Access 97 from your Access 2K version if your friend needs another
copy.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Tom Wickerath]

Hi Jazz,

Did you use the Switchboard Manager to create your switchboard? Starting in Access 2000, the
wizard writes code that uses the ADO library with late binding (ie. Dim rs as Object). One
possibility is that your friend does not have ADO installed. Have your friend try the following
experiment:

1. Open the database while holding down the shift key, to prevent the startup form from
activating.

2. Open a code module (create a new temporary one, if required). Click on Tools > References.
Verify that no references are marked as MISSING. If any are marked as MISSING, then this is a
problem that must be fixed. Do not advance to the next step until all references are found.

3. Verify that she does have a reference set to the "Microsoft DAO 3.51 Object Library". If not,
have her scroll down the list to find it and set it. Then click on OK to dismiss the references
dialog.

4. Now have her delete the Switchboard form. Note: I am assuming that you used the switchboard
manager. If you created your own switchboard form, then obviously, this is not a step that she
should carry out.

5. Have her temporarily rename the Switchboard Items table to something like Switchboard Items
Original

6. Have her create a new Switchboard, using the wizard. In Access 97, click on Tools > Add-Ins >
Switchboard Manager. Click Yes to create a switchboard. Then close the wizard.

7. Have her delete the new Switchboard Items table, and then rename "Switchboard Items Original"
back to "Switchboard Items".

8. Test the new switchboard. The switchboard build by the wizard in Access 97 uses the much more
reliable (okay, just my opinion) DAO code. This is why you need to make sure that a reference is
set, as in step 3 above.

Good Luck,

Tom
___________________________________


Hi, I have created a database in Access 2000 and have sent it to a friend who
only has Access 97, and she couldn't open it. I therefore opened by 2000
version and did a conversion to a "previous version" which one has to assume
it Access 97. I sent that to her, and when she opened it, she got a message
saying: "COMPILE ERROR.......METHOD OR DATA MEMBER NOT FOUND .....(IN
FORM_SWITCHBOARD) Can you suggest what the problem might be? Thanks.

 

[Tom Wickerath]

I just verified, by converting an Access 2000 database that has a (Tom chokes & gasps here)
switchboard manager build switchboard. I get the same error when attempting to open the database
in Access 97:

The expression On Open you entered as the event property setting
produced the following error: Method or Data Member not found.

This error occurs on the line of code in the Switchboard form that reads: "Set con =
Application.CurrentProject.Connection", because Access 97 does not recognize CurrentProject.

Follow the steps I outlined in my previous message. This should get her up & running with your
app.

Tom
____________________________________


Hi Jazz,

Did you use the Switchboard Manager to create your switchboard? Starting in Access 2000, the
wizard writes code that uses the ADO library with late binding (ie. Dim rs as Object). One
possibility is that your friend does not have ADO installed. Have your friend try the following
experiment:

1. Open the database while holding down the shift key, to prevent the startup form from
activating.

2. Open a code module (create a new temporary one, if required). Click on Tools > References.
Verify that no references are marked as MISSING. If any are marked as MISSING, then this is a
problem that must be fixed. Do not advance to the next step until all references are found.

3. Verify that she does have a reference set to the "Microsoft DAO 3.51 Object Library". If not,
have her scroll down the list to find it and set it. Then click on OK to dismiss the references
dialog.

4. Now have her delete the Switchboard form. Note: I am assuming that you used the switchboard
manager. If you created your own switchboard form, then obviously, this is not a step that she
should carry out.

5. Have her temporarily rename the Switchboard Items table to something like Switchboard Items
Original

6. Have her create a new Switchboard, using the wizard. In Access 97, click on Tools > Add-Ins >
Switchboard Manager. Click Yes to create a switchboard. Then close the wizard.

7. Have her delete the new Switchboard Items table, and then rename "Switchboard Items Original"
back to "Switchboard Items".

8. Test the new switchboard. The switchboard build by the wizard in Access 97 uses the much more
reliable (okay, just my opinion) DAO code. This is why you need to make sure that a reference is
set, as in step 3 above.

Good Luck,

Tom
___________________________________


Hi, I have created a database in Access 2000 and have sent it to a friend who
only has Access 97, and she couldn't open it. I therefore opened by 2000
version and did a conversion to a "previous version" which one has to assume
it Access 97. I sent that to her, and when she opened it, she got a message
saying: "COMPILE ERROR.......METHOD OR DATA MEMBER NOT FOUND .....(IN
FORM_SWITCHBOARD) Can you suggest what the problem might be? Thanks.