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: Need SQL Server ODBC client v3.60.x to correct a date problem

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

4. Please help correct my stored procedure.

5. Please Help me find the correct newsgroup

6. Help Please correct e mail address

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

8. Retrieving correct error messages with ado on SQL 2000

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

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

11. Retrieving correct error messages with ado on SQL 2000

12. Retrieving correct error messages with ado on SQL 2000


 
Powered by phpBB® Forum Software