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