VB Forum / Database Access / September 2004

i want to make a project with VB 6.0 as frontend and MS Access as the database.
does the user need to have MS Access installed on his computer to use this software.
Can it work if i give him only the database file.
Gaurav Jain

Im only familiar with VB not VB in access, i have 5 tick boxes the top one
is a question, what i want to find out is if you click the top one, i want
the other 4 to blank out
if you dont know what im talking about ill use this as a simple example

I want to indirectly access a field called "ID" I know this syntax is
wrong but I do not know how to corrected it
Dim db1 As Database
Dim  rs1 As Recordset

I have to create a new dBase IV database.
I want to use ADO.
Can somebody tell me how to do that?
Thanks for your answers

Can anyone help with the following:
I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click a
table, the fields are displayed. And then I have a button to create a

I am trying to figure out a fix for an Application Error 1000 that is being
generated by a VB6sp3 app we have written in house.  The error showed up when
we first upgraded to WinXP and only shows up on most of our WinXP computers.  
It happens when we are using ADO (2.5)'s command ...

I am unning Access 9.0.2720, vb 5.0(SP3), & WINDOWS 98 SE, my problem is:
when I install a data control and attempt to select the record source from a
data base I have created in Acess, vb 5 says " unrecognizable data base
format" . When I do the same but use the sample ...

I am wondering in what situration when we use an AutoNumber to be the
primary key of the record over a... huh... (don't know how to call this)
let's say a user supplied Part# for example.
So, we can have a record with an autonumber as the sole primary key for a

I'm looping through code in VB6, using ADOX to modify an Access 2000
query and  update the catalog. It then passes the query name (not its
SQL) to a macro in an open Word 2000 document. The macro then connects
via DDE to the query to run a Mail Merge.

We have a vb app that loads from text files and inserts data into a
SQL Server 2000 database.  This has been running successfully for a
year, with no recent changes, yet in the last few days our users are
getting the above error when trying to insert a date "20/09/2004" into

I have a connection established to an Excel spreadsheet that I am using for
an import. The problem is that the worksheet names will change from file to
file. I need to know of a way to discover the worksheet names within the
spreadsheet. Is there a way to do this with ADO?

I have already created an Access application, which I now wish to port to a
VB platform. My question is: Is Visual Basic the right vehicle to perform
this function (I normally use VC++)? If so, is there a link somewhere which
fully explains the methodology involved in connecting ...

I'm using VB 6.0 and am trying to update an access table without much
luck.
The string variables all have values in them and all of the table
entries are text.

I'm creating a form that will calculate the value of quantity times
price. I have that code working to calculate the value, but want to be
able to automaticaly calculate it when I go to the next record without
having to  click the calculate button.

I cannot seem to figure out simple connection string for MS Access 97, I get
an error "Could not find installable ISAM".  I know that also mean wrong
connections string.
Here is what I am using now.