Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 8th, 2006, 06:00 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default publishing the MDB

Hi,

  I want publish my mdb in web, for that i want to try it in the Intranet first..what i want is how can i convert my Front end to html.I tried the Ms Access Page but the fact is Access Page is only readable and not editable please give me an idea to do this .or weather it is possible for me to get Access page to edit i.e. enter the data in the from through access page ..

 if ur not able to understand plz revert Me!

thanks

Learn as you can..
------------------------
pap...
 
Old August 10th, 2006, 12:31 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   You should be able to do this. I would suggest using FrontPage on your site, then pasting the back end of the database to your web site. FrontPage will store the database in a folder called _fpdb, I think, but more importantly, it will create a datasource for the databse on the web site.

   Then create form pages and save them as .asp pages. These will allow you to add controls that look up data in the database (for combo boxes, etc) and then publish to the database - either updates or new records.

   Most people don't like FrontPage, but it works well with Access and .asp pages. Most FrontPage 2003 books will spend a lot of time on setting this sort of thing up, and you will find it is very easy to do this way.

   Just make sure to do data validation on your pages or someone will write some executable code and clean out your database - just cause they can.

HTH

mmcdonal
 
Old August 14th, 2006, 02:10 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Do u have any idea to get any tutorial about this...

 please give the links if it is in webs

Learn as you can..
------------------------
pap...
 
Old August 14th, 2006, 06:24 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You can get any of these books:

Microsoft Office FrontPage 2003 Inside Out
ISBN: 0735615101

Special Edition Using Office Microsoft FrontPage 2003
ISBN: 0789729547

If you paste the Access file to the root folder in your web site, FrontPage will ask you if you want to turn it into a data source, and then it sets that up for you. Then you create forms on your pages, and connect them to the datasource, etc. You can also do queries on the datasource. I would suggest creating your queries in the Access query design window, then changing to SQL view, and copying and pasting your SQL code to the data source query advanced properties etc.

Read either of these books and they should help out. I think I spent 15 minutes with the first book and that was all I needed. You will see how easy it is. Let me know if you need additional help offline.

HTH

mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
import data from mdb to another mdb mat41 Classic ASP Professional 3 March 9th, 2007 07:01 AM
Publishing Problem vipin.raturi ASP.NET 1.0 and 1.1 Professional 1 January 4th, 2007 04:32 PM
Publishing Error gkamckenney Apache Tomcat 0 December 29th, 2005 11:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.