opening a .dbf file in MS Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

capnhud - 01 Mar 2006 00:55 GMT

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.

Reply to this Message

John Vinson - 01 Mar 2006 03:32 GMT

>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]

Reply to this Message

capnhud - 01 Mar 2006 10:11 GMT

> 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.

Reply to this Message

Tom Lake - 01 Mar 2006 10:51 GMT

>> I was wondering how do I go about opening a .dbf file in MS Access
>> because
[quoted text clipped - 3 lines]
>> 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

Reply to this Message

capnhud - 01 Mar 2006 12:21 GMT

> >> I was wondering how do I go about opening a .dbf file in MS Access
> >> because
[quoted text clipped - 13 lines]
>
> 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

Reply to this Message

Cindy Winegarden - 01 Mar 2006 16:45 GMT

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?

Signature

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com

>> >> I was wondering how do I go about opening a .dbf file in MS Access
>> >> because
[quoted text clipped - 12 lines]
>> browse
>> the databse in dBase or FoxPro? Does it work?

> 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

Reply to this Message