Cannot use data from dBase database tables
Article ID: 138 - Updated: Aug 30, 2009 - Products: - Version: V4 - Category: License and Activation
You have created the form in NiceForm application and have linked it to the dBase database. You can see the dBase table in the design NiceForm window. But as soon as you start your form, the run NiceForm window does not show the data in the table object. When you open the properties of the table object, you can experience the error message 'Access violation'.
Based on the information and research that was conducted the problem seems to occur in the development environment used to program NiceForm (Borland Delphi). NiceForm uses different connection technologies like ADO (ActiveX Data Objects) and BDE (Borland Database Engine) to be able to connect to the widest array of database types. When different database connectivity technologies are used at the same time and Windows XP SP2 is installed on the system, the application cannot connect to the dBase tables. Several Delphi-developed applications created by other developers have the same problem, so not just NiceForm is affected.
NiceForm V4 does not support the dBase tables. The same feature is working in NiceForm V3. The following workarounds are suggested:
Workaround 1 (recommended): Convert your dBase database to some other database type, like Access or Paradox. You can use the application NiceData to convert the database type.
Workaround 2: Remove the Windows XP Service Pack 2 from the computer.