VB Forum / Database Access / July 2006

I'm creating a VB app wich uses an Access DB. In the future, there will be
updates made to my program, wich might change the DB setup. I want to store
a version number inside the Access DB, to be able to determine when the DB
has been created and with what setup. Can anyone ...

***Environment***
Visual Basic 2005
.Net Framework 2.0
DB2 Direct Connect Client info as follows

not sure if this is the right place to post this, but here goes ...
where can I go to find out how to do the following for a given SQL Server
and Access database:
1. select all table names from database.

I've searched for days trying to figure this one out - I hope someone
here can help me.
The problem, in a nutshell, is this: I've got a Recordset object and a
Database object. The database is an Access MDB database that is open.

The programm works fine with SQL server 2000, but after the migratio to sql
server 2005
(database server and odbc/ole drivers on the client) I got the error
message:

I'm cycling through a ADO recordset connected to SQLServer. ADO is raising
an error when I access certain rows as there is invalid data in those rows.
The nature of the data error is that an invalid date value is being
calculated through a DateAdd function.

Have not worked in latest VB, but need to quickly crank out project attaching
to MS Access. Any good resources. 4 books later my head is spinning ...
between trying to cover all front end languages, and all back end databases
... and code that does NOT work ... the books I'be ...

Apologies if I'm missing something obvious....
I'm conneting to Access db using ADOX and VB6 and getting the value of
Column.Properties("AutoIncrement") - that's fine!
But I want to get the same from my SQL Server (2000) db. I understand that

I tried to create a new sql server (express) database with visual web
developer 2005 express edition. I opened the database explorer and right
clicked at data connection. But in the following menu the entry "Create new
sql server database" wasn't accessible. Does someone know the ...

I have written an ActiveX DLL that does lookups in a SQL Server
Express 2005 via ODBC.  This works fine but is horribly slow.  I would
like to test the possible speed improvement with an OLEDB connection,
but can't make it work.  All I get for an error is "Login failed for

I am doing a small job which needs to match up a product code with the
database entry and return the field that indicates the stock on hand.
I am using access 2000 fior the database , it has three fields , the
product code has 28 alphanumeric digits and has been made the index.

Hello all， I  am writing a program about the database.
The part of program as follow
For i = 0 To 3
str_detalle = "rs_editfac!mem_DETALLE" & (i )

Hi we have a VB6.0 application, where the ADODB Recordset "rs(!Amount)"
returning indifferent value (Regional Settings modified) as
"4523480000" but where the actual database value is "452348". any
reason why this strange behaviour. how do i get the original value

On a whim, I downloaded the free version of Oracle 10gXE and installed it.
As I have only ever used Access databases before I was wondering if there
was a preferred way of dealing with Oracle.
I usually use the

Why the REPLACE function does not work in Access SQL?
Where can I see the list of all such VBA functions that do not work?
Are there some tech articles in MSDN?
May they will be working in the future versions of the ADO?