General discussion


Present access data info in a web page.

By Shanghai Sam ·
How can I present information from an Access database in a web page without having to authenticate as an administrator? I have tried everything possible from every TechNet article I could find that relates to this problem. I have an NT 4.0 SP6a server running IIS 4.0 and MS Proxy 2.0 all with the latest sp's. The server is PKI enabled and we are using SSL. The Access database is loaded on the website in the recommended fpdb directory and I have created the proper ODBC connection info for the database on the server. Using FP2000, I created an active server page using the insert database results option and a search form function. I am the network administrator with full domain access and a webmaster. I have absolutely no problem opening the database and performing searches. When anyone else clicks the link, the following message in the active server page appears: Database Results Error
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
One or more form fields were empty. You should provide default values for all form fields that are used in the query. I know this is a security or authentication issue, but cannot for the life of me figure out where the problem lies. Does anyone know what directories in the IIS 4.0 web site may be causing this problem? Obviously, I do not want to give everyone change access to the whole web site. Thanks for any help or suggestions you can provide.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Present access data info in a web page.

by kevin In reply to Present access data info ...

I had the exact same problem. Make sure you supply a logon ID with the necessary rights to access the folder. You can do this by accessing the form properties in FP2000.

Collapse -

Present access data info in a web page.

by splash4500 In reply to Present access data info ...

The database is configured as shared and no locks. The problem really seems to be a security issue or authentication issue because, as the administrator, I can open the asp file in our web and perform the searches. When anyone without domain admin priviledges tries to open the asp is when it fails. I have set the required permissions on the web site, the ntfs permissions on the proper folder and files and tried all combinations of authentication in the Directory Security tab of the web site (using anonymous with and without password sync, basic authentication and ntlm, etc). Still baffling me...


Related Discussions

Related Forums