Dynamic Internet Forms Using Access mdb 6

[annsolomon]

Our marketing director wants me to put a sales contact database on the server so she and her employees can access it and update data from remote locations. I don't think I can do it given our current resources:

We don't have SQL Server. Strictly Access/Jet databases. I tried creating pages in Access and publishing them using Front Page but it seems I can only get static forms that way. Isn't it true that I'd need something like SQL Server at the backend in order to have dynamic forms on the website for data entry?

Can anybody think of anyway I might be able to accomodate her request?

Ann

 

[unev]

I would like to use Data Access Pages over the internet. I have created a Data AccessPage for a table and have added a command button with "Add New Record" operation. "UseRemoteProvider” property was set to TRUE in the password properties sheet of the Data Access Page.

When the page was accessed over internet it showed all fields as blank and was not connected to the database. No error message was displayed. All the images of the TasksNavigation bar are disabled and so were not able to navigate thru the records. If the Command button to add a new record is clicked a Message box with a blank message is shown. I went thru Microsoft documentation and have used the following settings.

1. Database was created directly to the Intetpub\

http://wwwroot

of the webserver
2. Connection to Database is specified as a UNC path
3. All clients have been given access to RDS-based pages and application from the
MSADSC->Properties under IIS configuration Page.

[MSADC-> Properties->Directory Security tab->Edit->IP Address and Domain Name Restrictions->"Granted Acces"]

4. The following entry was made to the MSDFMAP.ini file (c:\winnt)

[connect c:\inetpub\wwwroot\myFolder\mydb.mdb]
Access=ReadWrite

could any body help me out if i have to make any further settings? wht could be preventing a connection from the client side to the database? Thanx in advance