Data Access Page - trying to deploy to internet

[eran_assis]

I am Trying to create Data Access Pages for my Database. the DB itself works well, seperated to BE and FE. I Recently configured IIS on the server, and I'm trying now to make DAPs, with no success.

After a lot of begginer's errors, I managed to configure the security issues detailed in KB 264080. Now, I had an error message going like:

Quote:
"an error occured while trying to use <My query name>; check to see if the object exists".

​

I found another KB, discussing the problem. As I understood, the problem occures whenever you use UNC path instead of real path. but in my case, I used a real path (c:/Inetpub/Database/MYDB.mdb). As I understand, the client side finds the DB, but can't handle the query object itself. I tried to use a table and it didn't help.

I don't know how to go on. I would've linking the DAP I'm talking about, but I don't want to be too linked in the WWW, having Security configurations not set tightly enough.

 

[boblarson]

I hope you find the answer you're looking for but I have to tell you that I think you are going down a bad path trying to use a Data Access Page as they have been deprecated by Microsoft. They are no longer supported and they aren't in Access 2007 nor in future versions. I would suggest looking into other options.