Hello i need some help setting a html interface for a data access page. I have created the tables i believe I just need the next step, because i am confused.

Where is the data that you are trying to access?

I have the table created on my local C drive the table it has 8 fields 4 of which have combo boxes. I stumbled onto and figured out how to create the data Access page but the combo boxes are not showing up. I have tried to attach the database file but this board wont let me.

Click to view attachmentHere is a screen shot attached to this message of what i have done so far.

Screen shots usually aren't very helpful, but in this case, I realized that you're talking about MS Access, rather than accessing a database. Sorry, I can't help you with MS Access.

I am going to try and be more clear about my issue. Ihave created an HTML page which i want to tie into a Access Database in which i have created the table and fields.

Where are you planning to keep the M$Access database? And where is your web server? (If they are not the same computer, there may be problems.)

It is not possible to "tie" an html page and a database together *directly*. You need a script, typically written in PHP or Perl, which accesses the database and writes the pages.

If you plan on remotely hosting the DB that you're sourcing your stuff from, you're going to have to migrate it.

No webhost I can think of offers Access as a DB - it's not robust enough for WWW use.

Hopefully the database and the html page will be on the same box that is the plan. The Database is being created or written by a program called Audit wizard. For right now i just wanted to see if the HTMl page i created could in some way be used as a data entry page. I am attaching a updated version of the HTML i am working on.

The HTML isn't the issue. What matters is your ability to run a program on the server that can accept form submissions and interact with your MS Access database.

What kind of programming experience do you have? What kind of programs are you able to run on your web server?

Just to follow up on what Darin said, the PHP manual includes some stuff about ODBC, with which you could access an MS-Access [isn't it amazing how M$ product names are unsearchable, because they are simply a basic word in the relevant context] database.

However, my guess is that the expertise required to get this thing working with your "Audit wizard" database will be _more_ than that required simply to write a standard PHP-Mysql script to do the whole thing.

Yes because i just found out the auditwizard write a SQL database. Now i am even more confused.

SQL is a standard (more-or-less) language for database queries. MySQL supports it - so (no doubt in an M$-ey sort of way) does MS-Access. But to access the DB you need to write a program in Perl, PHP or similar, which makes the necessary SQL calls. If you have no programming experience at all this is a daunting, if not impossible task.

What is the budget for this project?

My pocketbook (which is 0). I just found out more info on this issue. And that is we have created a table in Access with the required fields i just need to know how i can tie the html page i created to the access table. Everything will be on the same server.

You need a program running on the server that can accept form submissions and interact with your MS Access database.

What kind of programming experience do you have? What kind of programs are you able to run on your web server?

None really i no a little HTML i can create a table in access and thats it. Programs we are running now that i know of are Access and SQL

Then you'll need to learn a lot, or you'll need someone with the necessary experience to do it for you.