Exporting to text file

[Martin]

In 97, we used to export a table to a fixed width text file (using a saved
spec). The file was always the same name with the extension ".ser" rather
than one of the conventional text file name extensions. This worked fine.
Now we are running the database in 2003 (still in 97 format), we keep getting
the error message that the database is read-only. Fair enough, I know we
can't change the design of the database when working in 97 format but in what
way is this export changing the design? The export works fine if it's to a
file with ".txt" at the end -it seems to be the ".ser" that's causing the
problem.

This is actually a coded process in VBA, part of a much larger routine
(which is why I don't just change the ".ser" to ".txt").

Any help appreciated!

 

[Martin]

Looking down the other threads I found the solution which is to add the
extension (in my case "ser") to the following key in the registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\Disabled
Extensions.

Begs the question as to why M/soft feels they that have to restrict text
file name extensions and, more weirdly, why the completely irrelevant
"Database read only" message comes up!

 

[Marcin]

========================================================================
FREE ? No problem How are this: http://www.webneti.cjb.net and
http://www.webteam.gsi.pl and http://www.webneti.gsi.pl
========================================================================

Looking down the other threads I found the solution which is to add the
extension (in my case "ser") to the following key in the registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\Disabled
Extensions.

Begs the question as to why M/soft feels they that have to restrict text
file name extensions and, more weirdly, why the completely irrelevant
"Database read only" message comes up!

========================================================================
FREE ? No problem How are this: http://www.webneti.cjb.net and
http://www.webteam.gsi.pl and http://www.webneti.gsi.pl
========================================================================