I want to protect my data source which feeds only a selected amount of records to a public page (no login required).

For instance, here's a code snippet of the data source from my test page:

http://www.hmgstrategy.com/dmxDatabaseSources/devProgListFuture.asp?hiddenDate=5/18/2014

All anyone has to do is look at the view source and they'll see this data source which any entry level programmer can use to view everything in that recordset.

The information on your site about securing data sources revolves around using a login, but there is still a need to protect data sources on pages that are public too. How do we solve this?

Hello Steve,
It is not possible to protect a data source on a public website. What is the point of restricting access to a public data if it is public?
You can create a separate data source for the public part of your website and limit it to return XX records only when setting up the database connection - this way even when loaded into the browser it will show the XX recrods and no more.
And you can create another data source for the protected part of your site, that returns all of the records. You can then protect it with the security provide.

There are those times when you are providing limited access to premium data. Using two data sources as you suggest would work. Thanks.