Export to ODBC database has stopped working

[Guest]

I have been using Access 2003 on my laptop for 2 years and had no problems
exporting tables to an ODBC Database (MySQL) until today.

I haven't used this function for a couple of months, so I can't pinpoint
when the problem started exactly, but I no longer get the option to choose
the database. I select a table, select Export, select ODBC Database from the
dropdown, click OK to confirm the table name and then nothing happens.
Normally I would be asked which database to export the table to but this no
longer happens.

I can't create new linked tables with an external ODBC database either,
although existing linked tables still work (I can open the table and the data
refreshes with the latest from the database).

This suggest my ODBC connections are fine but it seems that the Access
software is skipping the step in which you choose the database.

I've tried searching forums and the internet for the answer but without
success.

Many thanks.
Steve

 

[Guest]

Are you using a DSN? Check the DSN. After reading the
data from a DSN, linked tables store the DSN information
internally, so even if the DSN disappears, linked tables which
used it may continue to work.

(david)

 

[Guest]

I have had User, File and System DSN's set up for two years and I haven't
changed them (they are all set up correctly), but the problem seems to be
with Access skipping the bit where it asks me which DSN to use when I try to
link to a database table.

 

[Guest]

Can you create and test a DSN from the ODBC data manager?

The pop-up that you are supposed to see is actually an ODBC
form, but it could be either a problem with the call (from Access)
or the callee (ODBC manager). I'm not aware of any special
dll's or settings on the Access side, so I'd start with the ODBC
side (which is simpler) before I started trying to install and uninstall
Office.

(david)

 

[Guest]

Yes, I can create a new DSN (user, file and system) and I can use it to get
data from the database using Excel, which suggests the problem is with Access
only.

 

[Guest]

I'm not aware of any settings or files in Access which could
control this.

Casting around, I guess I would try KB article 835519, in
case there is a problem in AcWiz.

And I guess I would suggest reposting, so that other people
know you are still looking for help.

I'm sorry I can't help any.

(david)

 

[Guest]

Thanks for trying David.

If anyone else has any idea how to get this working again please let me know.