How To: Put your MS Access databases on your website

Put your MS Access databases on your website

To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the browse button. Import the table as a brand new table. Click next and finish. Second step is creating the search application. Click on data pages and click on new button launching the data page wizard. Create a search and report application. Select the data source and style and click next twice and search the users by name and city. Now configure the search fields to make it a keyword search and a drop down menu. Now you design the results page layout and select the tabular form along with other default options. Sort the results options by name. Now deploying the database can be done by selected the data page and click on deploy. You have to now use the embedded method to deploy. You copy the deploy code from there to the site you want to deploy it on by changing the code and inserting your code in it. Publish it and refresh the page. The uploading is done.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest