VB Forum / Database Access / April 2007

I'm creating an app that needs some kind of data store to hold a number of
things, in particular questions and answers.
My plan was to use an Access DB to hold this info and then use ADO to
select, insert, update and delete the data between my vb app and the DB, but

I'm trying to move the selected values from a list box into a second list on
the click of an Add Button. So if the user selects multiple values pressing
Ctrl from the list box containing values from a data source, the selected
values should show up in the second list box.

I have copied part of code from the Microsoft-side, with which I am trying
to find out wheter a user in a network is using the database.
Conconnection is defined in another part of the program as an ADODB.Connection
   Dim rs As New ADODB.Recordset

as promised in an earlier Thread:
Motto:...faster, smaller, dependency-free... ;-)
Or, ...my free COM-Wrapper for SQLite3 is now available.
www.datenhaus.de/Downloads/dhSQLite-Demo.zip (ca. 630kB)

I am having a strange issue with cascading deletes in that it simply isn't
cascading. Heres what I'm using:
VB .NET 2005 sp1
SQL Express 2005

I'm developping a software to import SQLserver data into Sage
(Acountancy software).
I use Visual Basic 6 to do that. No matter getting the Data from
SQLserver and Updating Sage via an ODBC link.

Is there an SQL statement to retrieve table names?
I don't want to use ADOX since some databases don't support that.
-Lou

I placed my data file in the Public folder on a Vista computer. I turned
Network Discovery on, File Sharing on, Public Folder Sharing on with with
full access, and Password protected sharing is off. Now, when I connect with
my app on an XP computer, the app opens but when I try to ...

Hi there everyone,
I have a program I compiled to   .exe  file, but it won't run on any other
computer
message reads    'Component  "MSFLXGRD.OCX' or one of it's dependencies not

I want open this select contained in a visual basic string (as
QueryAnalizer).
   update test set order = 'X'
   select  * from test

We have a vb6 app using Jet 4.0. When we install on Vista, the OS will not
let us update any records. If we turn uac off or start up with "Run as
Administrator" everything works fine.
What is the best way to avoid telling our users they need to do one of the

I've written the following code to delete all tables of a ms access db.
It deletes only half the number of tables not all.
----------------------------------------
1.  Sub deleteTables()

I am trying to convert some SQL Server queries to have them working with a
MS Access database and use ADO.
I am not able to find an Access equivalent for the SQL Server Construct :
ColumnName = CASE WHEN EXIST (.....) THEN 1 ELSE 0 END

Forgive me, I am more familiar with vbscript than vb 2005...
I am querying AD using ADO (v2.8) and need to set the command object page
size.  In vbscript it's as simple as
cmdAD.Properties("Page size") = 99

Im very new to VB so please bear with me, here is what i want to do
I currently have a shop and want to develop an application to show me sales,
items in stock etc.....
I have done the basics in that i have got the application looking how i want