Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / November 2004

Tip: Looking for answers? Try searching our database.

DBF FILES used in other Software

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Beverly76 - 29 Nov 2004 21:35 GMT
My company uses a program which is based on .dbf files.  I have discovered
errors in the database files which would be easy to fix if I could correct
the files using access.  I know how to link up to the file and change it.  
But I don't know if this is safe to do.  The software programmer does not
recommend it, but I'm not sure if that is because the program will no longer
be able to read the file or because they are not familiar with ACCESS.  

I do know that it is NOT SAFE to open the file in EXCEL and change it there
and safe it as a .dbf file.

Any recommendations?
Signature

Sincerely,
Beverly76

John Nurick - 29 Nov 2004 21:55 GMT
Hi Beverley,

There's a third, better, reason for the programmer to advise against
editing the data files outside the program. In a well-designed Access
database, there are validation rules and relationships between tables
which between them maintain the integrity of the data (e.g. you can't
have an Order that isn't associated with a Customer), and these are
built into the .mdb file. DBF files don't have any corresponding
built-in safeguards: they have to be written into the program code and
don't come into the picture when you open a .dbf file from a different
program such as Access. So there is a very real danger of creating
inconsistencies in the data that could make the program fail.

The best approach would be to temporarily install the program and its
data files on another computer and try editing the .dbf files. If this
fixes the errors you know about, and thorough testing doesn't find any
new problems, it's probably safe; but if anything went wrong you will
still have the original installation.

>My company uses a program which is based on .dbf files.  I have discovered
>errors in the database files which would be easy to fix if I could correct
[quoted text clipped - 7 lines]
>
>Any recommendations?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.