opening a .dbf file in MS Access
in [Getting Started]
|
From: capnhud on 28 Feb 2006 19:55 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 cannot locate the requested Xbase memo file.
From: John Vinson on 28 Feb 2006 22:32 On Tue, 28 Feb 2006 16:55:27 -0800, "capnhud" <capnhud(a)discussions.microsoft.com> wrote: >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 > >cannot locate the requested Xbase memo file. It would appear that the dBase file in question contains a Memo field - which is stored in a separate Memo type file - and that file is not available. Are you sure you have all the needed files available? John W. Vinson[MVP]
From: capnhud on 1 Mar 2006 05:11 "capnhud" wrote: > 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 > > cannot locate the requested Xbase memo file. I am not quite sure what a memo file is.
From: Tom Lake on 1 Mar 2006 05:51 >> 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
From: capnhud on 1 Mar 2006 07:21
"Tom Lake" wrote: > >> 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 > > > No I have not tried to open in neither one of these programs because I do not have either of these programs. How would I know what a memo file is |