Connecting to executable db

[GIGN]

Hi, I am writing software around a particular database. I am using ASP.

The problem I am having is with the format of the msb file. It is a database of parts, and it is issued on a CD as an Application, which serves as a parts finder.

I need to be able to connect to it via ASP, to read the data, I don't need the forms and queries and all that crap, how can I get the pure data?

At them moment when I connect to the table in question, it produces no results - counting returns zero.

What I think is going wrong is that the format is wrong, because it has been made into an executable, and the have made the table read only or something.

So my question is:
How do I get the table out of the Application?

below is the connection code:
<%
Dim Connector,Records
Set Connector = Server.createObject(&quot;ADODB.Connection&quot
Connector.open &quot;DSN=parts&quot;
Set Records = Connector.Execute(&quot;SELECT count(*) FROM PartDetail&quot
Response.write &quot;Connected to <a href='javascript:void(0)'>PartDetail</a><br>&quot;
Response.write &quot;This database contains &quot; & Records(0) & &quot; records.&quot;

Set Records = Nothing
Set Connection = Nothing
%>

 

[Aivars]

Hi!

I always create links to another DB. Then I can work with data of these tables out as application's tables data.

What's format of your DB on CD?

Aivars

 

[GIGN]

It is a .mdb File. I can connect to the table but sql statements don't return anything, it behaves as though the table is empty?

By the way, I did not create the Application. So do you think it is because it is in Application form, that I cannot read from it?

I have tried opening it in Access2000, and the actual table is not viewable for some reason, is this for protection? All the other items I can see, the queries, forms etc. The table does not even appear anywhere.

I know it is there, because my asp query does not return an error, so I know I have the right name, and the mdb file is a few maegs in size.

 

[Aivars]

You use ADODB. I'm using DAO and nothing know about work with them. If you would like to work also with DAO I can give you codes for auto linking to another DB.mdb.

Aivars

 

[Databaseguy]

The database may be an ODBC Direct database.

To browse the tables in an Access 2000 DB, use this code:

(Given open Catalog object)

Dim tbl as ADOX.Table
For each tbl in cat.Tables
msgbox tbl.Name
Next tbl

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy