Fails to create the new table(s). The process appears to run through
several
statements similar to the one I posted and as far as I can tell the
process
fails because the tables are not created. The table creation works in the
'97 version but not in the 2000 version that was recently created. I
suspect
it has to do with the "specification" property in the TransferText action,
but I'm not sure how to view the specification properties.
I have tried to im****t these from the '97 version but the im****t fails.
"Klatuu" wrote:
> Define "fails to work"
> Computer melts into ozzing puddle of plastic?
> Nothing im****ted?
> An error message is displayed?
>
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Rich K" wrote:
>
> > A colleague recently converted an Access 97 mdb to Access 2000.
> >
> > A process that deletes tables and recreates them while im****ting data
fails
> > to work. I believe I've resolved the issue down to this statement:
> >
> > DoCmd.TransferText acIm****tFixed, "Im****t_HED", "TI_HED",
> > Concat_Dir_File(Me![Directory_Location], Me![Collar_ID]) & ".HED",
False
> >
> > Concat_Dir_File is a local sub that creates the file location and
name. That
> > works just fine.
> >
> > Any ideas on why this would work in '97 and not 2000?
> >
> > What is the meaning of the specification? Would it be in a file, or
is it
> > set internally in Access?
> >
> >
> >
> >
|
