VB Forum / Database Access / August 2006

I am working with an access database with more than 25000 records
(adresses).
In vb .net  i use the tableadapter and it takes a long time to read all the
records (with acces it doesnt take much time).

I've three tables in many-to-many relationship (in a MDB db):
TBL1:
ID_TBL1   IDENTITY PRIMARY KEY
FIELD1     VARCHAR(20)

I have a VB application using ADO to connect to an access database and I
need to copy data from table1 to table2.. both tables contain same
columns name.
Does someone know how should I do?

I used VB SQL and ADO to create two tables in an Access database. These
two tables looked fine in the database. Then, I want to create another
table based on these two newly created tables. However, I could not
create the third table. Seems to me VB could not reference to these two

Create / Delete or Read (existing)  Access 2000 macro using vb6
Possible?

I want to connect oracle database from excel via odbc. Someone told me I
needed oracle client installed on my computer. Is it true?
Regards
Karol Michalski

I have to execute a script to generate a very specific access report on
a very large list of servers. The size of the script is over 80 kB, and
runs perfectly fine on Query Analyzer, since the database is on a MSSQL
server. However, if I put that script into a variable, and try to ...

I have some code that does different things depending on record count in a
recordset.
stepping through the code
rs.BOF and rs.EOF are both false (so there is a record)

Hello everyone, I am very new to VB.net (and programming for that matter)
and I am trying to get a handle on it. I am trying to understand datasets,
data grid, data adapter, data connection and how they all work together. I
have found a few tutorials that helped a little but most ...

I have created the following tables like the  Ms-Access Nwind database.
the following tables are normalised
i.Group Table
ID                         Group

If a field name has a space in it (my field)
should a query use
[my field] or
"my field"

welche Möglichkeit gibt es SQL-Expressdatenbanken automatisiert zu sichern ?
Maria

This is a similar problem to one posted earlier but occurs with access.
I have some code under a 'save' button which is something like
myRs.fields("myField1").value = "XXXX"
myRs.fields("myField2").value = "YYYY"

A UNION SQL query is not updateable - fair enough.  Is there any way of
loading a UNION query into a client side ADO recordset and detatching the
recordset from the database, thus allowing it to be updated (the recordset).
NB There is a column with a unique value.

I have been developing a process in VB.Net using a SqlConnection.
My process inserts a number of records into a #Temp table for review prior
to being committed to the database. My problem is that I have function to
export a recordset to Excel which utilizes .CopyFromRecordset to ...