Board index Database Programming

Easy Database Access at Run-time?

Easy Database Access at Run-time?

Post by Greg Fisbec » Tue, 25 Jul 2000 04:00:00



I'm trying to develop an application that will read data from a table
and use this data in the program.  So far, my code works great, but I'm
having difficulty with the UI.

I would like to present a dialog to the user asking them to choose
their data source.  I would like to give the user the choice of an
Access database, a SQL Database, or a comma-delimited file.  Then I
need the table name they are going to be reading from.  Is there a
(somewhat) easy way to do this in VB 6.0?

Any help you can give would be appreciated.

--
Gregory C. Fisbeck

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 
Top

Easy Database Access at Run-time?

Post by Evert Timme » Tue, 25 Jul 2000 04:00:00


As soon as you know the database name, type and location, you use the
connection.openschema method to get a list of tables.


Quote:> I'm trying to develop an application that will read data from a table
> and use this data in the program.  So far, my code works great, but I'm
> having difficulty with the UI.

> I would like to present a dialog to the user asking them to choose
> their data source.  I would like to give the user the choice of an
> Access database, a SQL Database, or a comma-delimited file.  Then I
> need the table name they are going to be reading from.  Is there a
> (somewhat) easy way to do this in VB 6.0?

> Any help you can give would be appreciated.

> --
> Gregory C. Fisbeck

> Sent via Deja.com http://www.deja.com/
> Before you buy.


 
 
 
Top

1. Creating Access database from SQL Server at run time

Hi,

    I have to create an access database (mdb file) from SQL Server Database
at run time i.e., the tables to be created & copied into access database
from SQL Server will be determined at run time. What is the efficient way to
achieve this??

  I have tried creating a DTS package but this package is executed in a
single step and therefore if tables are large then User have no visual
feedback regarding whether database creation is in progress or not? Even the
task manager shows that the application is not responding, but after around
7-8 minutes database is created.

Is there any other way of doing this??

K.K.

2. Informix Developer in Unix environment

3. RAID SYSTEM OR TAPE FOR BACK UP

4. Creating/Modifing Access Database at run time

5. Crystal Reports and RTF

6. unrecognized database format (Microsoft Access 2000) run time error

7. Create and Build an Access Database at Run-time

8. Opening an access database at run time with ADO

9. access 2000 database format and Run Time error 3343


All times are UTC
Board index