Not sure what caused it, but you could manually delete the im****t specs (do
a
DB backup first, then start a manual im****t and use the Delete option in
the
Advanced where where you normally modify the specs), do a compact/repair,
then im****t them from your test system. Just make sure the test system has
only the necessary specs so you don't get extras, then uncheck everything
except Im****t/Ex****t Specs during an im****t from the test to the live.
This
will re-im****t just the specs - probably less work than im****ting
everything
else to a new DB>
"Phil Trumpy" wrote:
> I have an Access 2003 database that im****ts a number of different text
files
> once per week into various tables. These files have changes made to the
> layouts now and then, in which case, I usually start a manual im****t,
change
> the Im****t Spec accordingly and save it over the other one. Now, I
normally
> do this in a test version and then when I am ready to make the change in
the
> live DB, I copy and paste that spec from the test copy to the live copy.
It
> has always worked fine.
>
> Well, recently, there have been file layout changes to 3 of the files I
use.
> Now, for these files, I get an error stating that the im****t spec does
not
> exist and I cannot do the im****t. I have unhidden the system tables and
can
> see the im****t specs there, but I cannot use them.
>
> I have two questions:
>
> 1) Is there any way to fix this issue in the database without im****ting
all
> objects to a new blank database and recreating the im****t specs?
>
> 2) What could have caused this. This issue will happen all the time as
> people are constantly asking for changes made to these .csv files. I
don't
> want to go through this every time a layout changes.
>
> Thanks in advance for your time. I am using Access 2003 on a Windows XP
Pro
> Service pack 2 machine.
|
