VB Forum / Database Access / January 2004

I have Visual Basic Professional 6 Installed on my computer and then
recently installed Visual Studio Professional 2003. When I went back
to work on a VB6 Project, the apps when run will not connect to any
local access database.  What has happened to the JET engine after

I have a table with a bigint type column (field) that has an identity seed
of 1 and an identity increment of 1.  The column is the primary key for the
table.
After I backup and clean out the database (delete all of the data in the DB)

Are there any distinct advantages to running a vb application with Access
2000 tables rather than Access 97 format?  Performance, integrity issues,
etc?
I currently have a application with Access 97 format and am considering

I'm in VB .NET - ADO .NET - SQL Server (MSDE)
I want to retrieve the input parameters of a stored procedure before
execute it.
I've already try the fillschema but it return the "return object (table)"

I need to add new columns to an existing table in a SQL 2000 dbase.
afaik using ADO you can only add new tables but cannot amend existing tables
(!)
The MSDN examples for ADOX show how to add an table with columns but the

I want to change from an Access database to MySQL, but without ODBC. I
tried to connect to MySQL via the follwing code:
Dim Cnn as adodb.connection
cnn.open "Provider=MSDASQL;Driver=MySQL;Server=localhost;Database=test",

I'm using VB/ADO to work on DBF files. Sql such as "DELETE FROM TABLE WHERE
FIELD='VALUE' leaves records only marked as deleted. Over time the table
grows with invisible deleted records. A manual "pack" is requried to remove
them.

I need to convert MS Access 97 database to 2000 format using Visual basic
code.
I have looked on  the web and the only thing I can find is by using the
compactdatabase utility.

I need to convert MS Access 97 database to 2000 format using Visual basic
code.
I have looked on  the web and the only thing I can find is by using the
compactdatabase utility.

I tried a cut and past for my connection provider but it's not working.  I
have MS ActiveX Data Objects 2.5 referenced and import ADODB and import
System.Dada
Here is the connection

With VB6 there was an option to make data reports???? What happened to this
option in .NET...
My Windows Dat Form Wizard is also not working, are these related to each
other????

one field in an Access table is declared with data type long.
In case I want to assign a value to the field such as
rstQ!banknr = 889988441
it generates the following error message

Well, the subject line sums it nicely.  Hello all, using Windows2000,
9i(9.0.2?), OraOLEDB driver by Oracle.
I have an Oracle stored procedure that is called by a DLL which is
called from an ASP page. Everything functions correctly when I use the

How can I open database file with *.vdb extension?
Regards
Cezary Rytwiñski

I have three textboxes which all accept only numbers but I need to
store the combination of all three in a special concatenated format,
eg the user inputs into:
txtBox1 123