Import while DBF file is in use

[Guest]

Hi there,
Is it possible to import a DBF file while it is opening (in use) by another
program (such as Foxpro 2.6) but have no access - I mean the records have no
change. Because the DBF files are in use almost the time, and I want to
update everytime I click a button.
Many thanks.

 

[Cindy Winegarden]

Hi Khoa,

Theoretically you can share tables - if - you are accessing the tables in
shared mode and the other app is accessing the tables in shared, rather than
exclusive, mode.

Why import the tables when you can link to them?

 

[Guest]

Hi Cindy,
My company is still using a program using Foxpro 2.6 for Dos, and it uses
the DBF files (and others) in exclusive mode (I guess). Since then, if
someone open the DBF file via the program (such as Account.PRG), the others
cannot access to it - and the program is open almost the time of the day. I
usually have to wait until the program is closed (or at least the DBF file is
not in used) to import the DBF file to MS Access for my own purpose. If I
link to any file, the FoxPro program might not work !
Dear Cindy, as I mentioned in the other post, I can import every DBF files
that have no MEMO field with just one click - using VBA, but not the one that
have MEMO field. I've been trying to write some code, as well as looking
around for some help about ODBC Database ... , but I've got nothing. Do you
have any idea, plz ?

 

[Cindy Winegarden]

Hi Khoa,

It's unfortunate that the app uses the tables exclusively. Your only
alternative is to use the tables when everyone else is out of them.

For VBA code, please see my answer in your "Import DBF Files with Memo
Fields" thread.

 

[Guest]

Hi Cindy,
I've found a way to solve my problem. As you said, I link the table to my
MDB file, create a make-table query base on this table to make another table,
etc... Since then, I can refresh the data with just one click, that what I
want.
Thank you very much, Cindy.