Access Database on the web server.

[teser]

How would I get my Access Database to show up on a web page? I have a url to the Access database (showing a form) on the NT web server but it always says it wants to download the database (test.mdb) to my local workstation. I want it to show the database form on this web site so I can fill out the form on this web site.

Any settings I should check???

 

[ensorg]

You would have to create a webpage that submits back to the database or if you have Access 200o or later then you can create data access pages with these.

 

[teser]

Yes I have it on Access2000. Please explain about submittin back to the database so I can create data access with the form.

Thanks

 

[ensorg]

What are you using to design your site?

If its something like frontpage there is loads of info in the help - search for "access database"

In Access search for "Data Access Pages"

 

[DaveNamou]

Here's step by step directions. I used Win2K Pro with MSAccess 2000 for these instructions

1. Copy your database to your

http://WWWroot

2. Goto Administrative Tools->Data Sources (ODBC)
3. Click the [System DSN] Tab
4. Click [Add]
5. Choose "Microsoft Access Driver (*.mdb)"
6. Click [Finish] and the "ODBC Microsoft Access Setup" comes up
7. Click [Select]
8. Navigate to your database and select it.
9. Data Source Name = "AnyNameYouWant" (Without spaces)
10. Click [OK]
11. You should now see the Data Source you created

12. Open your database
13. Open the Table or Form you want to publish to the web
14. Click File Export
15. Navigate to were you want to publish the web page
16. Change the "Save as type" to "Microsoft Active Server Pages (*ASP)"
17. Give your ASP page a name
18. Click [Save All]
19. The "Microsoft Active Server Pages Output Options" comes up
20. For "Data Source Name", give the name you chose in step 9
21. For "Server URL", give your servers address
22. For "Session timout " use 5 minutes

You should be able to use your web browser to view the items.

Unfortunatly, I was only able to view them. Not modify them. I know I created a page which allows you to edit from ASP before, I just can't remember the exact thing I did. I'll post it if I find it.
Dave Namou, MCSE CCEA

 

[teser]

Do I need ASP software to do this? I cant seem to open the file. I am testing it locally (

http://127.0.0.1/fri.asp)

to make sure it works. I did the ODBC and verified my Database connection and I was not in the database when I tested this.

Here is my error message:


[tt]
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

/fri.asp, line 13 [/tt]

 

[DaveNamou]

IIS 4.0 and 5.0 come with an ASP engine. If your using Apache, then you would need an ASP engine installed.

See if this article helps from Microsoft.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q163159

Dave Namou, MCSE CCEA

 

[teser]

I have IIS on my NT 4.0.

Anything I need to check to get ASP to work and avoid the error messages I posted earlier?

 

[DaveNamou]

I tried the same steps I listed before and came up with the same results. Are you sure you don't have some NTFS security settings on the file itself.

Remember that when you connect to the ASP file via HTTP, your using the Guest account for IIS (IUSR_Computername) which might not have access to the file even though you are logged on as Admin.

I don't have a quick way of testing that right now because my system is running FAT32. But I ran into this problem before on a system with NTFS.

If your interested, I have e-mailed the sample database I used to test along with the ASP page.
I e-mailed them to
CitrixTekTip@Hotmail.com
password is metaframe

Dave Namou, MCSE CCEA