VB Forum / Database Access / June 2003

I have an Access Table, "tblData", with a Text field called "Program". I
need to convert the "Program" field to a Long data type, so I suppose I have
to create a new field and transpose the data from the old to the new (The
old field contains data like "1- One", "2- Two", "3- Three" ...

I'm trying to establish a data connection in VB.net to an
Access .mdb database using Jet 4.0 and I keep getting the
above error.  I installed the MDAC 2.7 refresh and then
the Jet 4.0 service pack that came out last week, but

Please,  a newbie: I have written a simple VB 6 program using MS Access
database. I have been unable to find what happens with the Access db as the
program is compiled to EXE. 1). does it remain as a separate .mdb, 2) can it
be "complied into the VB EXE so the user cannot "see" the  ...

my problem is:
I have a list with 8000 rows (CSV)
I use this list to delete a row in a sql-database
that stores 2.000.000 rows..

i need to check to see if a tables exist. how do i do this? using Access
Database

 i have this problem when I do a transaction, see the code:
on error goto e
conection.begintrans
recordset1.updatebatch  ' until here the Recordset's status is 1 (new)

I have developed a db app using VB and install it at several PCs. The odd
behaviour I was talking about is that whenever I launch the app, Microsoft
Installer opens up trying to install a Microsoft Office 2000 Premium
features. I don't know what feature it tries to install. I don't ...

Hi all I am new of the Ng.
I'm getting close to Database in vb in the last month.
I'm making a program, using acces database 7.0 version, but now I have a
problem: I must do a research in the database, in one form that contains all

I have written some code to retrieve data from my database and now I want to
make it generic so that i can use it with several forms without having to
rewrite all the code. i can't get the code to return the recordset from the
module to the form procedure. I also tried passing the ...

I've only been coding in VB for about 5 months, plese excuse this if
it's elementary.
I'm creating a program in VB6 which will go through the list of
customer accounts in our SQL-2000 database and do some cleanup. For a

How can I open and update a remote Access DB from a Visual Basic application
running on my PC?
Thank You very much.
Alfredo

I`m trying to develop a program that make a report in access and print it.
First, how can I create/modify one report?
Second, how can I print it?
Thanks

Good morning,
Ok here is one I have been fighting with for a few days. I have a VB6
front end that ties into a MS Access 2000 database. The front end has
many textboxes some of which will not be used buy every user. These