Updating access 2000 database through code in VB6

I have an application that uses an access 2000 database currently in distribution.

I need to update one of the recordsets with additional fields on my customer's computers.

My data controls work fine as I have them set to connect in access 2000 format. But, when I try to open the database in code, I get an unrecognized data format error.

开发者_如何学CWhat is the best way to replace or add to the database on their machines?

It is possible to update an Access database using VBScript, ADO and DDL.

strCon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Example.mdb;" _
   & "Jet OLEDB:Database Password=pass;"

Set cn=CreateObject("ADODB.Connection")
cn.Open strCon

strSQL="ALTER TABLE Example ADD COLUMN Example Text (20)"
cn.Execute strSQL

More connections strings: www.connectionstrings.com

I much prefer using DAO collections to updating BE database schemas as it gives you much more control over what you can do. For example you can easily delete or create tables, records, indexes and relationships. See the TempTables.MDB page at my website which illustrates how to use a temporary MDB in your app and has sample code to get you started.