Hi,
I am new to the forum and not very good at Access.
Perhaps the question I am asking is outside the scope of this forum, but I have not found an answer to the problem yet so I thought I would try here.
The problem:
I have a web page that connects to an access database. When I run a query from the database, it seems to run properly. Ie: the "Results" view is populated with the correct data. When it is viewed from the web page using a simple "Select * From Results", it returns an empty data error even though the data is clearly there in the Access database view. I can use the exact same command on any different view or table and get the results. I can connect to a different identical Access database and it all works just fine. I have been working on this problem for several days now to no avail. I have posted this same question on different web development forums with no answers.
I have double checked, triple checked everything I could possibly do.
Is there possibly something in Access that will restrict the data from showing in a web page? I know that sounds dumb but I am really scratching my head here.
I appreciate any help or thoughts on this.