Results 1 to 8 of 8
  1. #1
    brentheuss
    Guest

    Access 2000 -DBF Database

    Hi, all.

    I have a database created in Foxpro. Access 2000 opens it OK and I can print the reports and move columns, but Access 2K will not let me add any records or make any changes to the existing records.

    I have tried to "convert" the database, but Access 2K will not let me (the "save as" option is grayed out, as are other options). I have installed the ODBC drivers for DBF, but that has not helped at all. Right now, the only option appears to be to re-enter all the data in Access 2K.

    Any advice you can offer on converting this database to usable form would be greatly appreciated.

    Thanks.
    Brent

  2. #2
    Mike B
    Guest

    Re: Access 2000 -DBF Database

    have a look at this article, Q197893, in the MS Knowledge base HTH

  3. #3
    brentheuss
    Guest

    Re: Access 2000 -DBF Database

    Thanks for the info Mike, but it did not work. I have installed the ODBC driver per the knowledgebase article.

    I still get "dataset is unupdatable". How is Nova Scotia?

    Hi from California.

    Brent

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2000 -DBF Database

    You're linked to the FoxPro tables, right? Do you have the FoxPro indexes set? Otherwise, you can't update the tables. That's true of other types of databases as well.
    Charlotte

  5. #5
    brentheuss
    Guest

    Re: Access 2000 -DBF Database

    Charlotte,

    No, I don't think I have the FoxPros indexes set. How do I do this?

    Thank you!

    Brent

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2000 -DBF Database

    You would ask that![img]/w3timages/icons/yikes.gif[/img] I seem to remember that dBase files asked you to specify one or more indexes when you linked the file. FoxPro (except the Visual flavor) should behave similarly, so if you know which indexes you need you should be OK.

    An alternative is to import the tables instead of linking them. Then you can do what you need to do without keying anything in.
    Charlotte

  7. #7
    brentheuss
    Guest

    Re: Access 2000 -DBF Database

    I think I still have a PC with FoxPro on it. If I can export the database in another format (maybe CSV), I may be able to import it into Access 2K.

    Right now, I can't even import the .DBF file. It's very strange - almost as if it were a locked file, but I don't find any evidence of that. The file is nearly 18,000 records with 10 fields/record, so I'd rather not re-input it if possible.

    If you (or anyone else) have any other suggestions, I'd appreciate hearing them. This is frustrating. [img]/w3timages/icons/thinks.gif[/img]

    Thanks!

    Brent

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2000 -DBF Database

    OK, if you can link to it, you should be able to build an append query to append records from it to an Access table. Have you tried that? Of course, first you need to build an Access table to hold the records, but it should work.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •