not a dBASE IV file - after access query

[Chris Guiver]

A dBASE IV file was opened by ACCESS for a query (SQL select query ran);
which was fine until I returned to dBASE IV. Experimenting following a Access
book.

dBASE IV now gives the error "not a dBASE IV file" when I try to open the
database file I opened with Access. This occurs with & without index even
though no update/editing was done in access.

How can I correct whatever access did to the file so I can continue using my
database file in dBASE??

Any help appreicated.
Computer runs XP SP3. dBASE IV is version 1.1; Access is 2002 though I also
tried reading the file on another machine running Access 97. Sorry I'm not
sure which version of Access damaged the file - but Access 2002 produced the
query I wanted, on '97 i failed to produce anything usable. No updating of
file was done in either access (just attempted to run query following example
in book)

 

[Chris O'C via AccessMonster.com]

"Opening a dbase IV file" for reading the data in a select query shouldn't
alter the data file in any way. If dbase won't open the file any more, find
your backup, make a copy and use the copy.

Chris
Microsoft MVP

 

[badari]

AdBASEIV file was opened by ACCESS for a query (SQL select query ran);
which was fine until I returned todBASEIV. Experimenting following a Access
book.

dBASEIV now gives the error "not adBASEIV file" when I try to open the
database file I opened with Access. This occurs with & without index even
though no update/editing was done in access.

How can I correct whatever access did to the file so I can continue usingmy
database file indBASE??

Any help appreicated.
Computer runs XP SP3.dBASEIV is version 1.1; Access is 2002 though I also
tried reading the file on another machine running Access 97. Sorry I'm not
sure which version of Access damaged the file - but Access 2002 produced the
query I wanted, on '97 i failed to produce anything usable. No updating of
file was done in either access (just attempted to run query following example
in book)

---------------------------------------------------------------------------------------------------------------------
From: G.BADARIVISHAL

If a dbase file is opened either in Access OR Visual Foxpro this can
happen since
the extension name of the file for Access is 'mdb' and Visual Foxpro
is 'vfp'

You can run 'dir' command for the file at the DOS prompt and see if
the extension name has changed.

If it has changed you can try renaming the file with '.dbf' extension.

This must work

If this does not work you will have to, as already suggested by one of
the
readers, copy from the backup and continue.

It is suggested that all important basic data dbase files are copied
to another
directory to be a back up source. This has to be done, as you know,
on daily
basis.

Hope this will help

G.BADARIVISHAL
06-07-2008
(e-mail address removed)

 

[bhicks11 via AccessMonster.com]

Hi Chris,

I am an old dBase programmer and use dbf's all the time in Access. I have
not had this problem. However, if this is something you do on a regular
basis, you could set up a process that imports the data, do what you need and
then export is a dbf you will solve your problem.

Bonnie
http://www.dataplus-svc.com