VB Forum / Database Access / September 2005

During an open
Dim cnn1 As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Program Files\Test\T1.mdb")
cnn1.Open()

Hy!
I use INSERT INTO sql statment to insert new record in db, but i have a
problem if value that needs to be inserted
have a ' sing (single quote sign).

I don't do much programming with a JET db these days, so I'm puzzled by this
one. I can execute the following query directly using the Access Query tool,
but I cannot execute it with VB using ADO against the same db ("undefined
function Nz in expression").

hi gurus
would appreciate if u can list the advantages that visual basic 6.0 has
over MS Access frontend.
need to convince the client to move from MS Access frontend to VB

Group,
I have a stored procedure in MS SQL 2000 that queries a table called Test1.
The stored procedure looks like this:
CREATE PROCEDURE z_ResultSetWithResultCode AS

Please help me, I'm lost on the actual code. All I want to do is: (using
VS2005 - vb application)
1) read db1.mdb
2) using field1 from db1, lookup in db2.mdb

Qualcuno ha già una funzione pronta che analizzi una statemten sql e divida
quinid la stringa in più parti?
Esempio
SELECT * FROM tabella WHERE campo = valore ORDER BY campo2

I'm issuing a MoveNext command on an ADO object and the ODBC driver is
issuing an error
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error
converting expression to data type datetime.

I'm running an old ASP program that worked just fine w/ Access 2000 (Win2K).
Now, when I run it against an Access 2003 db (XP) I get the following: Cannot
update. Database or object is read-only.     Note that the program is able to
read the db.

Could someone please help me fix this SQL statement; it gives me
Line 57: Incorrect syntax near 'qti' where I've marked it with /*****/
SELECT qti.CUSTNMBR,sum(qti.TRXAMT) as amnt
FROM

I'm trying to delete all indexes in an Access 2000 table, and then add new
ones
based on an ADOX.Table that I have defined.  I am doing this because my
client sometimes messes with the database they are releasing to the

I am running an Access report from VB via ADO.
The report has a field that shows the time it was run.
Is it possible to return the data from this field to VB when the
report runs?  Or to find the data in the ACCESS system tables?

I'm pulling a lot of fields out of a database for a report. The report is
full of details about the customer, the quote, pricing and so forth. The
database is normalized, thus there are a lot of joins. I need to populate
about 100 fields on the report, but one query is a massive ...

I am fresher what kind of questions are asked during .NET Interviews
how should i prepare myself.I have just completed my course from my
NIIT and looking forward for real job.
I am doing the following stuff

does anyone has experience with db-engines like http://www.vistadb.net as an
alternavite to jet-engine or MSDE. Are there other easy distributable
engines?
Important is that they should be password-protectable, queries within two