I have designed a very useful database at work using Access 97. What is the best way to get it online? It uses Tables, Forms, queries, Reports and macros. PLEASE HELP ME
I believe that Access 2000 has inbuilt option of creating web pages incorporated with Access database. I think Access 97 has it too.
The easiest way to link this with web is to run IIS server and link Access with it.
IIS comes with Win NT and Win 2000.
There is another one for Win9x but i dont think it will work with Access.
System Comp V3 - In progress.
Low power MB with C7 CPU, DC-DC PSU, car ECU link, USB TV, GPS, 7" TFT, Wireless, Voice.
if you want the functionality of the access database, which I think you do since you mentioned forms/reports/macros then you best bet is to look into what Fosgate is talking about. From memory I think Access has a "web portal" add-in, letting you use access from a web browser via an IP address.
If only the tables and data is really required, maybe look at building a website using a scripting language such as .asp or .php with the database. ASP supports access databases directly and runs under IIS with win NT/2000 and Personal Web Server (PWS) under Windows 98....
if it can be done, the first solution will be the most painless and quickest.....
Project - GAME OVER :(
It is window NT soon to be 2000. It is running IIS. I do not have direct contact with the IIS server but I pass on my needs for them to be completted. I did notice that access has an export feature but I was lost using it. Not sure what to point things to and what format to use. I also don't know what info the IIS manager needs to modify on his box. Any help or a URL would be great.... Having the macros, reports, and forms is important.
Just one minor detail, beware that Access doesnt scale well. If you dont expect a lot of trafic on your site it wont be a problem, but if you expect more than a few simutaneously (i just cant spell that word..)
you may run into problems because Access locks entire tables when processing data from it, MSDE/MSSQL server only locks the record in concern...
Appart from this detail i believe the others have supplied you with the information required..
Doesn't the access-export feature add a lot of junk in the html/asp pages.. like frontpage was doing...
This would also slow the pages down..
If you have any skills with access and you know how to write VB(A),
Then the easiest thing to do is build a site from scratch..
You can connect to the database in 2 different ways.. use odbc or not...
When I got first into this i went to brinkster
Because I didn't have a server then.
You get 30megs ASP enabled website, and there are lots of tips and articles for beginners..
Hope this helps you out..
PS.. I remind something that you could run ASP-pages on a linux or unix server using... Cake for linux ???!?!?!??!?! (don't know the exact name anymore)
Raas - The Netherlands
ME: VIA epia m10000, lilliput 7', opus 150w, 80gb<br>
GF: IBM Thinkpad 380, ext. 3.5 80gb, 40x4, PB-IR
Some pertinent information:
Access has a built-in limitation of 256 connections.
You mention forms and reports: you will need to create a new front end application to duplicate these in your favorite web scripting language (ASP, PHP, PERL, etc..)
Here is a pretty decent page to get you started on your way. It has a step-by-step to help you set up your ODBC conection and use Access's built in web export stuff.
[ 08-21-2001: Message edited by: Meatballman ]
We have 700 plus users but it is Very unlikely that we have more than 10 users in it at a time MAX. Perhaps there is a way to just launch access 97 from a link in a website. EVERYONE has access installed and it is an Intranet website. I am really hoping to be able to use my current macros, forms, and reports.