Please help me! (Correct Message) 
Author Message
 Please help me! (Correct Message)
Hi,

I need to know the VB code necessary to connect to an Access data base
file through DAO, RDO or ADO to get it's tables.

Also: When using an SQL-Server with database, what are the Stored
Procedures needed for it?

Thanks is advance,

Gustavo Figueiredo



Mon, 02 Apr 2001 03:00:00 GMT
 Please help me! (Correct Message)

Quote:
>Hi,

>I need to know the VB code necessary to connect to an Access data base
>file through DAO, RDO or ADO to get it's tables.

>Also: When using an SQL-Server with database, what are the Stored
>Procedures needed for it?

>Thanks is advance,

>Gustavo Figueiredo

In DAO :
(
Dim dbDummy as Database, X as Variant

'Open DB
Set dbDummy = DBEngine.Workspaces(0).OpenDatabase("path_to_db")

'Enumerate DB tables
For Each X In dbDummy.TableDefs
    Debug.Print X.Name
Next

'Close DB
dbDummy.Close
Set dbDummy = Nothing
)

This enumerates all Tables in the DB (including system and hidden ones) into
the the debug window.
Caution !! ADO, DAO, etc. don't have the same object model even if they are
similar.
Read the documentation of the good one.

bigjim



Sun, 08 Apr 2001 03:00:00 GMT
 Please help me! (Correct Message)

Quote:
>Hi,

>I need to know the VB code necessary to connect to an Access data base
>file through DAO, RDO or ADO to get it's tables.

>Also: When using an SQL-Server with database, what are the Stored
>Procedures needed for it?

>Thanks is advance,

>Gustavo Figueiredo

In DAO :
(
Dim dbDummy as Database, X as Variant

'Open DB
Set dbDummy = DBEngine.Workspaces(0).OpenDatabase("path_to_db")

'Enumerate DB tables
For Each X In dbDummy.TableDefs
    Debug.Print X.Name
Next

'Close DB
dbDummy.Close
Set dbDummy = Nothing
)

This enumerates all Tables in the DB (including system and hidden ones) into
the the debug window.
Caution !! ADO, DAO, etc. don't have the same object model even if they are
similar.
Read the documentation of the good one.

bigjim



Sun, 08 Apr 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Please help me! (Correct Message)

2. Please Help me find the correct newsgroup

3. Please Help: Need SQL Server ODBC client v3.60.x to correct a date problem

4. Help Please correct e mail address

5. Please Help: Need SQL Server ODBC client v3.60.x to correct a date problem

6. Please help correct my stored procedure.

7. COMBO BOX, PLEASE HELP, PLEASE HELP, PLEASE HELP!

8. Error 17883 May Display Message Text That Is Not Correct

9. Retrieving correct error messages with ado on SQL 2000

10. Retrieving correct error messages with ado on SQL 2000

11. Retrieving correct error messages with ado on SQL 2000

12. corrected typo in previous message: inner/outer join


 
Powered by phpBB® Forum Software