VB Forum / Database Access / May 2004

I meet a problem in creating new table in Access 2000 using VB6. These tables will be created whenever any Product Catagory is create.
For Example: When "Catagory 1" is added into the Table "Catagories", and a Table special for "Catagory 1" will be created as well.
Can anyone ...

Dear friends,
My name is Theodoros Tsioupros and I am a university student from
Greece. It is the first time I am using a newsgroup and I am writing
to request your precious help with a simple question about VB 6.0

VB6, Windows XP, Access 2000
I have a ADO Data control bound to a table with primary key (Date)
I have another ADO data control bound to a detail table with foreign key
(Date)

To All,
I've got a question, how can I check if a db is available using ASP
and ADO (not .Net but also welcome if any suggestion on ASP.Net using
C#)

I have a new query I would like to add to an Access MDB file
I would like my installation program to update an existing MDB file with this new query
Can this be done in VB in my .exe file that is used for the application
For instance, the user runs the update .exe file and the ...

My VB6 application sotres several dates in a database. I use an SQL stateemtn with ADO to insert the data into the database. I am developing my application to be used in several nations with different languages. Some nations write dates as 4.27.2004 instead of 4/27/2004. ADO does ...

I have a large vb5 program built around an access 97 (format jet 3.0)
mdb file running on NT4 computers. The "data environment" is Jet
engine 3.5 and DAO 3.5.
I'm re-writing some part of the code and want to ask if it would be

O.k.  Here's the deal.  I'm writing an application for a client.
Front-end is VB 6.0, back-end is SQL Server 2000 (actually, MSDE since
there are only a couple of users of the application in their office).
Reports are present in Crystal Reports.

I am new to MS access and I have to create and application which will take master data and some historical data from existing ERP. and then using this data reports needs to be generated (volume is less) and what we need is good graphical output, so i thought of MS access and VB. ...

I'm updating an existing SQL 2000 database. I'm using VB 6 and ADO 2.7 on a
XP Pro computer. A couple of my tables use identity columns. To update the
database I add a new tmp table with the new structure. I set the identity
column in the tmp table like this: "LogID int NOT NULL ...

I put a Dir-box on my Form and added Dir1.Path = "f:\temp". This naturally
works fine. Problem is that the Dir-box displays above the folder "temp"
the folder/drive "f\:". By selecting "f:\" the user can view all other
folders on this drive which I don't want.

I created an application using ADO control, DataEnvironment & DataReport designers. It works good only on a computer where Visual Basic installed. If no VB it says no msadodc.ocx (when I am trying to access data through ADO control) and no object found  (when I am trying to ...

I am looking for advice from the more experienced.
I have seen both of the below examples, both seem to work, most of the time.
Is there a right or wrong way to deal with text boxes and numeric values.
txtResults.text = val(txtText1.text)  + val(txtText2.text)

From VB6, How to open MsAccess 2000 with a protected dababase (with
password) ?
I wrote :
Set mAppAccessReport = New Access.Application

Can anybody help me on this? I have an activeX dll that connects to an SQL
2K database using ADO 2.7. In this dll I have a procedure that reads
information from an Excel file and writes it in the database. In this
procedure I use the method connection.BeginTrans. It works very well ...