Transfertext won't work after Access 2K to 97 conversion

[mcollett]

Hello,

I'm a relatively new user of Access and I'm working with a database built by someone else. I've been making modifications to the DB in Access 2K, but I am having to convert it back to 97 for other users. The DB works fine in 2K, but upon conversion to 97 the transfer text capabilities do not work. I don't even get an error message. Anyone encounter this problem before?

 

[pcs]

guessing here, as i don't use a2k much....

if the original database was in a97, did the Transfertext use a Specification? i think a2k handles this with 'schemas'. could it be that the conversion to a2k changed the original specification, and when you tried to revert to a97, it couldn't re-create the original spec? (there are more than a few problems with a2k to a97...)

as i said, just guessing

.

hth.
al

 

[mcollett]

That's entirely possible, and I'll check it out. Funny thing- I converted the DB once before to Access 97, and at that point had problems with the .00 extension on the files I was importing. I ended up fixing that through the registry, which was set to not allow .00 imports. But now that doesn't seem to work!

Thanks for your help!

MC

 

[catt]

I created an application in Access2, which through a macro, automatically imported text. The office updated to Office 97, and I converted the application to Access97. The transfer would work once maybe twice and then I would crash.

I tried on different machines, thinking it may be memory or operation system, but it still did not work. I believe 97 has glitches. The office eventually converted to Access2000, and now the application works every time.