How do you convert an add-in from acc 2000 to acc 2007?

[Z]

We have a bunch of access add-ins that we created in acc 2000. Trying
to upgrade to acc 2007 but we can't seem to get the add-ins to work.

Is there a equivalent to the USYSREGINFO? We can't even find the
table (or any system tables) when we open the original myaddin.mda in
acc 2007.

If there is a different way to register it, anyone know how?

We were able to find the add-in manager and add the add-in. Could not
edit the path where the add-in shuold be copied because we couldn't
update the USYSREGINFO.

Any help, pointers, guidance would be appreciated.

Thanks.
Z.

 

[Stuart McCall]

Comments inline:

We have a bunch of access add-ins that we created in acc 2000. Trying
to upgrade to acc 2007 but we can't seem to get the add-ins to work.

Is there a equivalent to the USYSREGINFO? We can't even find the
table (or any system tables) when we open the original myaddin.mda in
acc 2007.

The usysreginfo table should be constructed exactly the same as in A2k. In
order to see the table in the navigation pane, click the Office button (the
round thing in top left),Click the button "Access Options", select "Current
Database" on LHS list, then scroll down till you see a button with the
caption "navigation options". Click it and put check marks next to "show
hidden objects" and "show system objects" in the popup dialog. Ok everything
till you get back to the nav pane and your usysreginfo table will be
visible.

If there is a different way to register it, anyone know how?

We were able to find the add-in manager and add the add-in. Could not
edit the path where the add-in shuold be copied because we couldn't
update the USYSREGINFO.

In the "Value" column of usysreginfo, if you type "|ACCDIR" (without the
quotes), it will be substituted by Access for the addin path. So lets say
your addin file is called "MyAddin.mda". In this case the Value field should
read "|ACCDIR\MyAddin.mda" (again no quotes).

Now the new addin path is:

C:\Documents and Settings\<Login Name>\Application Data\Microsoft\AddIns

(the addin manager will copy your addin here, so if you want to work on it
after installation, here's where to do it)

HTH