How to connect Access Database to a website?

Question

I am setting up a site for a small business and we need a way to connect access to the site as a database for ordering products and making invoices; does anyone know how to?

Answer 1

Share the error your are facing,

You are tring to Access SQL server database OR talking about MS Office Access Database.

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

Hi Trevor129,

You can refer to this site:

http://smallbusiness.chron.com/build-database-website-using-access-27644.html

Microsoft Access software lets you create a small database you can use on your website. You must first create a new database, then create the tables that store the website information. Access is beneficial for small websites and webmasters who are unfamiliar with database structures. Access includes a wizard and designer that helps you create a website and its tables.

Since this forum is for SQL Server, for more information about Access, please visit Access forum:

http://social.msdn.microsoft.com/Forums/en-US/accessdev/threads

---

Iric Wen
TechNet Community Support