Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old December 1st, 2003, 02:36 AM
Lynn101 Lynn101 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 1 Lynn101 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question using access as html pages over intranet

I would like to make my access program into html pages and allow them to be accessed through the intranet in my work. This is in order that users would be able to work with my program without having to install access on their computers. Does anyone have any tips or any reading material about this???
Thanks.

Reply With Quote
  #2  
Old December 3rd, 2003, 11:43 PM
syatek syatek is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 3 syatek User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via AIM to syatek Send a message via Yahoo to syatek
There are many different ways to go about doing what I believew you are trying to do. I would need to know alittle more about your program first though. One way would be to use access as your backend database and use Front Page or Dreamweaver or some other web design tool that lets you access databases to design a front end to your Access DB.

You could also use some of the MS Visual Tools for front end design to your Access DB.

Another thought would be, depending on what this project is for and the number of users who will access the DB, to use a MySQL or other free relational DB (I mention MySQL because it is free and work in Windows and *nix environemnts) as you backend and use the methoisds I mentioned above for the front end design.

Good Luck

Reply With Quote
  #3  
Old February 10th, 2004, 11:38 AM
codruta.crisan codruta.crisan is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 1 codruta.crisan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
using access as html pages over intranet

Hey there,
I have a question connected to your thread. I want to post Access database over intranet using IIS (Internet Information Services). Does anyone have an answer to this question?
Thanks!
Codruta Crisan

Quote:
Originally Posted by syatek
There are many different ways to go about doing what I believew you are trying to do. I would need to know alittle more about your program first though. One way would be to use access as your backend database and use Front Page or Dreamweaver or some other web design tool that lets you access databases to design a front end to your Access DB.

You could also use some of the MS Visual Tools for front end design to your Access DB.

Another thought would be, depending on what this project is for and the number of users who will access the DB, to use a MySQL or other free relational DB (I mention MySQL because it is free and work in Windows and *nix environemnts) as you backend and use the methoisds I mentioned above for the front end design.

Good Luck

Reply With Quote
  #4  
Old February 12th, 2004, 06:39 AM
Bullschmidt's Avatar
Bullschmidt Bullschmidt is offline
Guru
ASP Free Novice (500 - 999 posts)
 
Join Date: May 2003
Location: USA
Posts: 877 Bullschmidt User rank is Corporal (100 - 500 Reputation Level)Bullschmidt User rank is Corporal (100 - 500 Reputation Level)Bullschmidt User rank is Corporal (100 - 500 Reputation Level)Bullschmidt User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 8 h 40 m 43 sec
Reputation Power: 9
Here is something I put together about ASP that hopefully might help somehow.

You and others can have access to a database hosted on the Web from any location that has a browser with an Internet connection.

The Web database concept makes sense if you and your people want to do work in various locations in or outside the office and still be "plugged" in.

For example you could have employees enter timesheets or have sales reps log their contacts. Or perhaps you'd like customers to be able to check the status of their orders online without having to call the company.

If you want a Web database, typically what would happen is that a database such as Access or MySQL (basically just consisting of tables) would be put on the Web.

Then "dynamic" Web pages (actually ASP pages which include VBScript, HTML, and/or JavaScript) would be created acting like the old desktop database's queries, forms, and reports to access the database - all hosted on a Web Server.

Dynamic Web pages are similar in many ways to regular HTML pages. But they are "live" because the user can read from and write to information in the database. An example where you can login and add, edit, or view fictional customers and invoices is at http://www.bullschmidt.com/login.asp

Not all Web hosts will handle dynamic Web pages but many do. The Web hosts that can handle ASP pages usually have a Windows 2000 or Windows 2003 operating system running an IIS Web server.

Here are a few good ASP sites:
o ASP101 Samples - http://www.asp101.com/samples
o W3Schools ASP Tutorial - http://www.w3schools.com/asp
o Microsoft VBScript Language Reference - http://msdn.microsoft.com/scripting...vbscripttoc.htm

And the following newsgroup is good:
microsoft.public.inetserver.asp.general

Or for a "quick and dirty" generic ASP open source solution to putting databases on the Web that just requires setting up a configuration page for each table or query and uploading the database to the Web as long as there is an autonumber field in each table (and you'll probably also separately want to create login capabilities), perhaps try something like this:
GenericDB by Eli Robillard
http://www.genericdb.com and then click on the Tips link to see an example
__________________
J. Paul Schmidt
www.Bullschmidt.com - Freelance Web and Database Developer
www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > using access as html pages over intranet


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway