Retrieving data over internet?

[davemassey]

I'm wondering if anyone has been able to retrieve records from an Access DB over the internet using Visual C++. I have 20 mg database which I just want to set up on a web page and then have my VC++ application (which runs on client computers) point to the database on the web page and execute queries as required. Someone tried something similar a while ago and the system would try to download the ENTIRE database during a read attempt (and at 20 mg, that is NOT what I want -- just want the data from the SELECT to be sent to client computer).

Any one have thoughts on this?

Thanks in advance.

Dave

 

[PHV]

You may consider Data Access Pages (.dap).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

There are a number of things that can read Jet databases (eg DAO, ADO and MSODSC) They will under some circumstances read all the data for all the tables in your query.

You can partially work out if this is a risk by thinking how you could pick the data you want if you were Access. If you can't think of a good way, neither can Access. After that, avoid complex SQL. Write simple select statements with WHERE conditions specifying an indexed field without calculations in the WHERE.

And of course follow the maxim that if you're not sure, it's safer to stick an index on something than not.

 

[davemassey]

Everything that I've tried up till now has had the same problem - the entire database is downloaded to the client machine during the connect/open request (which is a problem both from a security and performance Point of view.)....

 

[BNPMike]

Can you post your SQL here and point out which fields in the query have indexes.