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)
"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
On Jul 3, 3:08 pm, Chris Guiver 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@yahoo.co.in
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
