opening a .dbf file in MS Access

[capnhud]

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.

 

[John Vinson]

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]

 

[capnhud]

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.

 

[Tom Lake]

I was wondering how do I go about opening a .dbf file in MS Access
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

 

[capnhud]

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

 

[Cindy Winegarden]

Hi!

Please also see my reply to your post in the microsoft.public.access
newsgroup.

FoxPro Memo files have an FPT extension. I'm not sure about DBFs created
with other programs such as Clipper.

I looked for information about Timberline and there was some mention of ODBC
on the sagetimberlineoffice.com website (if that's your software provider).
Do the provide a special ODBC driver for their files?