VB Forum / Database Access / May 2004

I have an Access 2000 database and a VB6 front end
One of the routines in the VB6 code is to compact and repair the database
I used to have Access 2002 installed and this routine worked fine (on the development machine). However, I changed to Access 2000 (can't remember the reason) ...

I would like to open DBF file to MSFlexGrid on runtime.
This is how i am doing it but it doesnt work:
Dim m_cn As ADODB.Connection
Dim m_rs As ADODB.Recordset

Does anyone have any good code for accessing and synchronizing with a design
master database from a VB6 application?  I have one central Access 2000
database that I want to make the design master and several mobile users.
The mobile users will be using the replicas but the in-house ...

I need to be able to view data in the datagrid for windows forms in a hierarchial fashion
as in msaccess
i found an article for the asp.netgrid in the october 03 issue of current edg
but how can i do this in the windows form datagrid

I'm creating a parameter query using ADOX. The query is stored in the Access database (I can see and use it from code) but I can't see it when I open the database with Access. I've tried .Refresh, view hidden and system objects, but there's no change
Here's the code

i have 3 vb6 apps on a bunch of win nt 4 sp6 machines that work perfectly
fine. i have upgraded 4 machines to windows 2000 sp 3 and now 2 of them
cannot connect to the databases.
i have installed mdac 2.8, and the lastest jet engine files but that had no

I'm using an ADODB command to create multiples Stored Procedures on a DB.
Into query analyzer, to run a query batch, GO command is used to run all the
creation processes.
1. - If I execute the Command using GO keyword, and Error is showed:

I am writing a VB program using ADO to create and insert a record into a SQL
Server 2000 table. My intent is to place the user (in a grid browse of the
records from the table) at the record just created to allow further
processing with that record.

 How can i connect btrieve database (6.15) from visual basic (6.0 sp5)

It's been a few days now and I still can't get this simple thing to work. I
hope this (ALMOST DUPLICATE) post will get me some help.
I have a vb6 app, mdac 2.8, sqlserver7
The problem is: the ON ERROR does not trap the errors thrown by ADO. When

I keep getting the following when trying to create a connection to a
database :
Error: User defined type not declared .
The declaration it is complaining about is :  c1 As ADODB.Connecton

Hi Forum,
While querying from VB 6.0 to Foxpro Database table, doing good if Date
condition is not included, whenever I include date condition VB gives an
error message. I think there is Date format problem:

List:
I'm using MS DAO components 3.6 under vb6 SP5
I've a table with an autoincrement field.
I've added records successfully using:

I have a VB6 that can connect to an Access 97 DB, but not to my Access 2002 DB. I have installed SP5 but that is the only thing I have done so far. What am I missing?

I have some VB 6 code that has been working for the couple of years, and 2 months ago I loaded the following patches on my machine
mdac 2.7 setu
mdac 2.
mdac_type 2.5_sp