VB Forum / Database Access / February 2007

I have a VB 6.0 application using Access as backend. It is being used
on a local area network. The backend database is password protected.
The problem is that the database gives me a run time error 3343
unrecognized database format. I open it in Access and repair it, which

I have an app that works fine in almost all machines, i´m using a dbgrid to
a adodc control, in some machines the app hangs when calling adodc.refresh
method, have reinstalled mdac 2.8. This occurs both running from VB and
executable. DB: sybase, OS : XP/2000.  This is my code:

I have an odd problem.  I have a stored procedure that make use of
cursors to build dynamic sql for returning multiple recordsets in one
stored procedure call from VB6 (via ADO sql exec command).
VB is able to process each recordset until one particular recordset

Hi Every body
I used access succefully for years and I created many scientefic
databases with it
Now I want to use VB.net2005 environmment  with access database

I am very(!) new to Visual Basic but i am quite experienced with MS Access. I
want to use VB6 as a front end to my database. I don't know where to begin, i
have tried googling it but all i can find is complicated articles about ADO
and DAO which i don't understand. Can any give ...

I need to import data from csv file to excel template through
vb6.Currently I'm
copying data from csv file and pasting it on excel template using copy
and

anyone know the shortform code for adding a hyperlink to a button on a
Windows Application Project in Microsoft Visual Studio 2005? Im at witts end
trying to figure it out

anyone know the shortform code for adding a hyperlink to a button on a
Windows Application Project in Microsoft Visual Studio 2005? Im at witts end
trying to figure it out

I'm using Visual Basic Express 2005 and need to populate a DataGridView with
an ADO recordset.  Is this possible?  I don't want to use ADO.Net because I
want to put an export to excel button on the form near the DataGridView so
the user can get the data in excel and I m using the ...

I am modifying some software, written in VB6, using an MDB database.
It seems as if the database is changing somehow. I can't open it in the
visual data manager in VB, it gives me an error about unrecognizable
database format. VB can access it ok, but crystal reports asks for a

I am having dificulty understanding ADO.
I am trying to create an Access input form for a table called
"debtors" in an mdb called halibut using VB and ADO rather than using
the form & textbox object properties at design time to bind the

I'm getting the famous error 91, but in a way I've never seen. I built
a form to handle our work order system via SQL and included it in a
project I had already started. The compiled project works fine on my
development machine and the laptop with VB6 enterprise on it, but when

I use VB5 SP5 with an Access DB via DAO.
I have two tables and I would like to select from the first one the
records that have the desidered value in a field in the second table.
In other words:

I am trying to read an excel file using ADO but having a problem trying to
connect to early excel files. The ones I am having to use are version 2!
If there is no way of connecting to it, can I easily check the version of
the file or is error trapping my only option? The end user ...

vb 6 pro DAO as front end, access 2000 db back end
How do I convert a table to a querie through vb code?
TIA
John G