Thread: Another off topic... Help me SQL, Access 97, Web

Does your web server use Windows, or the better choice of Linux?

If it's Linux, just make it with MySQL on the box..

Scott--

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.

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.....

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.

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)

Greetz

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.