If your .dbf file data will continue to change in the future, then it's
best to Link the table.
If you are going to convert the .dbf file data into Access and maintain
that data there, then Import.
Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions
Al, I need to periodically read data from an DBF file which structure is
permanent but its name and path change from reading to reading.
Is it possible to do it without setting a link. For instance, using
If OpenDatabase is OK, please put some code because I tried and failed.
I don't want to use a link to an DBF file becasue I don't know how to
redirect it. The problem is that the name of an link to an DBF file changes
along with the name of the file.
If you want to do it in code you can use the OpenDatabase methods and the
Connect property (which is the last argument in the OpenDatabase method).
You will still have the problem of supplying the path each time. I suggest
just using the built in GUI as I described in my first post. It does the
same thing as you would write in code. Linking is probably the better choice
unless the data is unique each time. It that case, you may prefer to import
Arvin Meyer, MCP, MVP
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access