Opening a Access Database table through ASP

[Incognito44]

I have a customer who (Don't ask me why) want to perform a query on a Access database table, if the query comes back with no records he wants the table to open up so the fields can be seen. Is this possible through ASP? Thanks, G

[Tequila_worm]

Is the access database on the same server ?

[mendhak]

Does he want the actual MDB file to open up, or just the names of the fields returned in the ASP page?

[rangeela]

why don't u show rs fields in first <tr> by making loop of rs fields name(for each rs in recordset
response.write rs.name
next)

[Incognito44]

I appreciate the suggestions but this is what the customer asked for, not what I would do or anyone else would do. This is on a server within a intranet. They want the mdb to open up and display a certain table exposing the fields and the data to the user based upon my above description.
They don't want a recordset returned....This is what they want and what I want to attempt to give them if possible.
I'm sure they have thier reasons.
The last thing I would do is expose the database but people want what they want....

[mendhak]

What you are describing is not possible. It involves the transfer of the MDB file between server and client, and then execution of the MDB file so that it opens up. The thing is, it's not allowed.

You CAN initiate the download of the MDB file between server and client. You cannot get the MDB file to open up itself though. It is something that has to be done manually by the user, provided the user has accepted the download when the download dialog box came up.