I have an access file, a server, html expertise & basic knowledge of SQL. How do I make an online form to let others add to the database?
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$4 Answers
If you've already made the forms in Access, they are easy to convert to ASP.NET. A quick Google search points you to an "Access to ASP.NET Wizard" (see sources for links). To do this you'll need asp.net installed on your server. You can also create new web pages/forms in ASP.NET, but since this is a programming language, you'll first need to learn a few basics.
There are a lot of other server side languages available as well. PHP can connect to an Access database using ODBC. PHP is easy to learn, and free open source software. You'll also need SQL for this.
http://download.cnet.com/Access-to-ASP-NET-Wizard/3000-2380_4-10264310.html Access to ASP wizard, if you already have Access forms
http://www.microsoft.com/express/vwd/ Visual Web Developer Express, free from Microsoft, allows you to test ASP.NET.
http://www.php.net/ PHP, a server side language
http://www.web-max.ca/PHP/odbc_1.php Using MS Access and ODBC with PHP tutorial
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
Presumption is made that you are working on an internal LAN or corporate Intranet. If you want to make your database available on the Internet, you have a much more complicated project as described by others here.
This article explains the process:
http://office.microsoft.com/en-us/access/HA101314681033.aspx
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
The next task is to import the data from Access to MySQL
You could import using ADO if you're familiar by setting up a short VBA program to that . Otherwise look to the file import tools in Php Myadmin or download the toolking from de.mysql.com - this final option includes a migration tool kit.
With the database established you now need to set up the form to capture data.
If you have access to Dreamweaver there is a tool to help you do. I've listed the adobe technote to that describes this below.
Otherwise the best bet is to either use a third party database form tool like phpMyEdit or to learn some basic PHP. I'd recommend using some sort of tool - it probably will give you more secure code if you've not done this before.
Alternatively if you're using a CMS investigate any form tools in the CMS
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
