Prev: Archive a datasheet once finished with
Next: Using form to enter data to a field
From: Chris Guiver on 3 Jul 2008 06:08
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)
From: Chris O'C via AccessMonster.com on 4 Jul 2008 13:10
"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


Chris Guiver wrote:
>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)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200807/1

From: badari on 6 Jul 2008 05:09
On Jul 3, 3:08 pm, Chris Guiver <guiv...(a)discussions.microsoft.com>
wrote:
> 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 using my
> 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
gbadarivishal(a)yahoo.co.in

From: bhicks11 via AccessMonster.com on 6 Jul 2008 22:26
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

Chris Guiver wrote:
>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)

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200807/1

 | 
Pages: 1
Prev: Archive a datasheet once finished with
Next: Using form to enter data to a field