VB Forum / Database Access / December 2003

I'm using VB6 SP5 on a Win2K machine.  I have written an ActiveX DLL
that creates a set of ADO recordsets from proprietary data, so there is
no connection object or source database.  Is there any way to use these
existing ADO recordsets in a SQL SELECT...JOIN statement to return a ...

If I execute an sp over adodb from Visual Basic, An Exception may be
raised and I can inspect the <connection>.Errors collection. However,
I cannot find out how to get hold of the part ", Procedure test, Line
4", which is quite interesting for debugging.

Good Morning,
The company I work for is looking into so changes to the architecture and
how we interact with the database. As a financial company that processes
hundreds of thousands of transactions a day we have to ensure top

We have developed an application with VB 6.0 and MDAC 2.7 and it communicate
with an Access 2000 database.
The problem is that MDAC 2.7 cannot be installed on Win 95 machine and many
of our clients still use this version, and they cannot upgrade.

1.I'm working on Windows 98 OS.
2.My machine got installed MS-Access 2000
3.I've removed the default "MS Access Database" user ODBC
name. After I create it, it does not come in to existing

I am trying to import data into an access DB and I am getting the following error:
"Could not update:  currently locked by user Admin on machine [machine name]"
After clicking OK on this error, I get the following:
"State:  S1000, native:  -1102, origin: [Microsoft] [ODBC MS Access ...

The following message appears when running the code below on Windows 98. On
Win2K it works fine:
-2147467259: [Microsoft][ODBC dBase Driver] Could not delete from specified
tables

Hi I have the code:
dbCONNECTION.ConnectionString = "FIL=MS
Access;DSN=PETITIONS"
       Try

How do I make a connection to an old Clipper database using VB 6.0?
Don C.

vb6, windows 98, access 2000. project has a data environment,(playing
around with something different).
form has mshflexgrid fed from recordset defined as clientside cursor,
static, read only, top of form has data input panel, after adding a

Hola a todo el mundo, quisiera saber por que cuando cargo mi msflexgrid con
un objeto data, le hago al objeto data.movefirst y en el grid no se mueve.
Gracias Por la Ayuda

I foolishly asked this question about a second hyphen
problem as part of another related issue.  It was, of
course, lost in the discussion of the other issue.  So I
am posting it again on its own this time.  My appologies

hi, i have a program that outputs a save file that is somewhat encoded.
i was wondering if any of you had some free time and would like to take
a shot at decoding it. i know it is some sort of sql-based db cuz it
occassionally give me error messages saying like syntax error in from

I get that error when i try to move my program from one workstation to another, and try to compile and run the project
I have checked the components and references and all seems ok. Similar to other projects i have but they all run fine
Any ideas would be appreciated!
Thanks

I try to use the form wizard in VB6 to link the Access 2000 which has
password, how can I do that? Is it the password should be contained in *.rwp
file ? if yes how can I creat the *.rwp file.
Thanks