VB Forum / Database Access / January 2005

I am new to VB programming.  I have been using Access for awhile, but would
like to expand my programming knowledge.  I am designing a database to be
accessed over a LAN by no more than 10 users simultaneously.  When is it a
good idea to utilize SQL versus ACCESS for the tables, ...

I created a VB program (vb6.0) that uses DAO. I put the .exe on a computer
on the network where my access dbase is at also. I mapped a drive on users
cpu and want users to be able use the map drive and to click on the .exe and
use it.

I have nasty problem I need to use a query to insert records from a table to
another table (access) but, both tables have passwords, I'm using VB6
through ADO, but I can't make it, always have an error, if I put the
password gives an error on syntax "insert into", if I don't of ...

What I need is to create a new ADODB file when the user first time runs my
application...
I don't want to pack an empty DB file in the wizard.
How do I do that?

I'm quite an amateur at SQL.
I have to select fields from a table to load into a grid, but one of
them is an ID that has a corresp. "friendly" name in another table to
which it is related.

Hi is it possible to delete records in one table using a join with another
table where the other table contains
a field in common with the table I want to delete records from.
For example if there are 2 tables A and B and I want to delete records from

I want to Delete records (mark records for deletion) and Pack the database
(physically remove the deleted records) in a single subroutine.  The Deletion
(marking of records) succeeds but the Pack fails with the error "File is in
use".  

I have several fields in my database table which are going to be
select from list.
For example, State. I have a separate table with 2 fields: the state
abbreviation and the abbreviation + full state name. The reason I do

after inserting some new data , I don't succeed in seeing these immediately
on the srceen . Although the data are in the database, I don't get them on
the next form without closing the application first. What do I forget?
Dim dc As New OleDb.OleDbCommand("insert into tblAankoop ...

 Can anyone tell me the difference between,
1. Dim a as New ADODB.Connection &
2. Dim a as ADODB.Connection.
Tell me a difference other than memory allocation.

As you'llsee, I'm not horribly fluent with this but....
I'm using ADO to access data from my VB6.  For future program upgrade
purposes, I need a way to add a field to the existing database (and stuff in
a default value). Can somebody steer me towards information on how to do

CAn anyon eplease help me with a sql problem which on the face of it appears
to be quite simple but which doesn't work
I have two tables containing 3 identical fields.
I need to be able to compare the data in both tables to find any differences

Is it possible thet I change name(size,type) in my mdb through code in VB. I
have field with name Info1 and I want change this name to Info2
Please help me...
Best regards

I am working with Office XP. I have created a simple, medium sized database,
which sits solely on my hard drive (no networking, no SQL Server) and which
has a couple of thousand rows.
On a regular basis I have a very large number of update statements to run,

How do i Pass "Table Name" and "field name" as parameter in SQL 2000 stored
procedure .This is to make make my stored procedure dynamic.