Insert Data to DBase III

[Vadim]

I created a simple VB program that insert records to
DBase III file by Insert SQL statements. The program ran fine and created a new records, but after that I cannot open that file on DBase by USE or BROWSE command. It throws a message that my file is not a database file.
I use this type of connection

cn.ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};" & "DriverID=21;" & "Dbq=c:\DocsToDBF"

What is wrong? Please help.

 

[tviman]

Have updated your dBASE program to account for Y2K? If not, do a search on google for "dbase" and you'll find a couple of sites that offer a free utiliy that changes the hardcode in the .exe file to allow dates past 12/31/2000.

There's always a better way. The fun is trying to find it!