Missing Table MsysIMEXSpecs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While in Access 2000, I used the tools feature Database Utilities\Convert
Database\To prior Access Database Version. After conversion when I load 97
and try to run a macro, I’m getting an error that says 97 cannot locate the
table MsysIMEXSpecs. I’m stumped for a solution.

I’ve seen a similar error in 97 before when I’ve tried to import a macro but
didn’t include the advanced import specs.

Thanks
 
Hi.

Unfortunately, database conversions from Access 2K to Access 97 don't
include the system table for import/export specifications, MSysIMEXSpecs, nor
its companion table, MSysIMEXColumns. You can't import these tables into
your Access 97 database from the original Access 2K database, because Access
97 can't read the database format of Access 2K. However, you can export the
MSysIMEXSpecs and MSysIMEXColumns tables from the Access 2K database to the
Access 97 database.

To do so, open your original Access 2K database. In the database window,
select the "Tables" button to view all tables. If you don't see the
MSysIMEXSpecs and MSysIMEXColumns tables, then use the "Tools" menu to select
the "Options" dialog box. Select the "View" tab, then select the "System
Objects" check box. Click on the "OK" button to close the dialog window.
All of the system tables will now show in the database window, along with any
user-defined tables.

Select the MSysIMEXColumns table in the database window. On the "File"
menu, select "Export ..." In the next dialog box, browse to the directory
where your converted Access 97 database is located, and then select the
database file. Click on the "Save" button. When the "Export" dialog box
opens, leave the information "as is" and click on the "OK" button. Select
the MSysIMEXSpecs table in the database window and repeat these same steps to
export this table, too. Close your Access 2K database.

Open your converted Access 97 database file (using your Access 97 .EXE) and
view your database window. If you don't see the system tables, use the
instructions above to view the "System Objects," too. Your MSysIMEXSpecs and
MSysIMEXColumns tables are now available for your macro to use.

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.)

- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
 
Back
Top