Make-table query run with macro

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Hello,

I have an MDE database that runs a make-table query via a
macro that starts as part of some VBA code. It had been
working just fine. However, for some reason, it now
doesn't work. It starts to run, and then stops and
displays a custom error message. The table is connected
to a subform, and when I open that, I get a message
saying that that table does not exist and the subform is
whited out where the make-table's data should display.
Because it's an MDE file which has doesn't display the
database window I can't look at the table directly.
However, the table shows up in MS Query if I query the
database (though it displays no data). I get the
impression the query has deleted the old table, but
something is preventing it from making the new one. Can
anyone tell me how I can fix this? (I have the .mdb
version of the database so I can make the changes on
that) Thanks in advance to anyone who replies.
 
A couple of ideas...
1. If the .mdb version is good, you can try remaking
the .mde version. You'll want to make sure that any data
in the .mde version more current than in the .mdb version
is loaded up in the .mdb copy before you try the remake.
If the data differences are trivial, then you can skip
that part and simply fix the data in the new .mde copy.

2. If the .mdb version is behaving the same way as
the .mde, try compacting the .mdb version first and then
remake the .mde version. This might squeeze out
any 'ghosts' of the busted make-table process.

If neither of these helps, you might want to repost with a
plea for MVP help in the subject line.

Good luck.
 
Back
Top