Database updatable via a web page?

[therodzone]

I've created a little database that needs to be kept up to date by 20 different people. I'd like to have this database on the web, and have a kind of Data Access Page where they can update it. I tried using the Data Access Page, but it wasn't working.. What's the best way to do this?

Thanks

 

[Hayley Baxter]

I'm just getting into this so I'm probably not the best person to advise you however I have been told that Data Access Pages are not the most friendly and the best way to accomplish this is with ASP. I have been playing about with this for quite some time now and managed to get the connection and update a table in the database however I'm stuck with updating more than one table as it didn't allow the option of using a query. Still haven't figured this last part out.

Here's what I done using Frontpage 2000

Create an input form from scratch adding text boxes etc then in the properties choose send to database and add the connection to the database. You will then need to map the text boxes to the fields in your table.

Remember to save this with an asp extension rather than html.

Also if you want to take the data the other way, to display data from the table/query on your web page you can do this via the database results wizard

Can anyone tell me how I update the query why isn't this an option in the list?

Hope that gets you started
Hay

 

[jonmadrid]

In my opinion Data Access pages are not the way to go. They arent very flexible and dont allow you to do much in regard to updating records. There are multiple ways to update your data, and some are easier than others. I prefer to write the routines myself rather than letting an application create them for me since writing them yourself allows for more precision and you can specify exactly what you want. That would be what I suggest. That can be a little daunting, I know, but they are actually pretty simple.

If you still need help with this issue (It's been a month since you posted), I would be happy to show you some code that would update records with information that you could input and submit via a form on a web page.

You can actually very easily create a system that will allow you to request particular records and edit the data very easily. Let me know if you still need help with this.

-Jon Madrid
---------------------------
Madrid Communications
www.madridcom.com