Re: opening a .dbf file in MS Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I was wondering how do I go about opening a .dbf file in MS Access
because
every time that I try to open this type of file I encounter an error.
What
do I need to do to prevent this from happening over and over. The
message
that I get is

In Xbase (dBase and FoxPro) files, a memo field isn't stored in the database
itself. It's stored in another file called a memo file and a pointer to
that file is actually stored in the database. Both files have to be present
in order for Access to use the .dbf database file. Have you tried to browse
the databse in dBase or FoxPro? Does it work?

Tom Lake


.



Relevant Pages

  • Re: Dbase III field attributes
    ... > Andrew told you about memo fields, but you mentioned dbase III in a FoxPro ... > convert that memo field to FoxPro format and the file will no longer be ...
    (microsoft.public.fox.programmer.exchange)
  • Re: dBase & ODBC woes
    ... records over (when I say manually, in dBase, I would say "create table..." ... Each group> of doctors has its' own patient and billing tables. ... I am pretty sure> that this particular database has a corrupted memo field, but I'm not sure> what I can do about it. ...
    (microsoft.public.dotnet.languages.csharp)
  • Access 2003 Link Causes External Table is not in the Expected Format.
    ... I have some DBASE tables (not FOXPRO) that I have been able to link to an ... access database using Access 2000 in and Access 2000 format database. ... attempting to link to DBASE tables using Access 2003. ...
    (microsoft.public.access.externaldata)
  • Re: weird DBASE IV data access
    ... Why are you using all those commands to access a dBase IV database (by the ... way have a look for that for FoxPro). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Finding a record number using SQL
    ... What database? ... In most databases, except for FoxPro, ... CLipper, DBase .. ...
    (borland.public.delphi.database.ado)