Access 2000 Web Pages

[Lauren36]

I have an access 97 database with sql tables. If I convert the front end to access 2000 and make web pages will users have to have access 2000 to view and use the web pages?

 

[jimmythegeek]

1) What do you mean by "sql Tables"?
2) No, they will not need Access 2000 as the asp page will create a connection to the database. So long as the database is on the web server, you are ok. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[Lauren36]

The database is split. The tables are on the sql server 7.0 and the front end I am presently using is Access 97 queries, forms, and reports.

 

[jimmythegeek]

What is the point of converting to Access 2000 if you are going to be using web pages to communicate with your data (SQL Server)? ASP pages can be created completely outside of Access, and with a SQL Server web db, there is now need for Access. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[Guest_imported]

Can I use ASP and FrontPage quickly and easily? I have 2 months to make web a enabled front end for a large personnel database and I am trying to figure out the best way to go with the resources that I have available. My choices are Access 2000, DreamWeaver 4.0, or Frontpage. I am studying ASP and VB Script but I thought it may be alot easier if I use Access 2000 because it writes the code for you. What should I do?

 

[jimmythegeek]

I am not sure about Access 2000 and it's web page building capabilites, as I have never used them. I create ASP pages from scratch in any web editor. Maybe someone who has experience with Access' web ability can speak better to that.

Dreamweaver is fine, my preference is Visual Interdev, but I use it strictly for the editor. If you are developing ASP pages with a dynamic front end, I would not use Frontpage, unless you use it to create the pages initially, and then modify the code, preferrably in an editor more suited to ASP. That is why I use VI. There are a few decent web editors for cheap or free on the internet; Homesite, and 1st Page are two that come to mind, as well as Dreamweaver.

After programming Access for over 10 years, I found that web pages (asp in particular) are more difficult and time consuming to create.

If you have not done a web app before, and you have a large project with a limited timeline, I would suggest hiring appropriate help, or you could certainly have a frustrating time meeting your deadline.

Web development is tough to master in that there are multiple technologies to learn, all of which are used in a web app: HTML, DHTML, CSS, ASP, VBScript, Javascript, etc. I took me a good year to get comfortable with all of these.

Good Luck. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?