homepage Welcome to WebmasterWorld Guest from 54.198.148.191
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Visit PubCon.com
Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
From Access Frontend to Web Frontend
looking for quick solution
Ulrike




msg:672750
 8:07 am on Mar 25, 2002 (gmt 0)

I hope I am posting this at the right place. And I also hope someone can point me in the right direction.

A materials management database is hosted on linux servers with MySQL. So far an MS Access frontend is used for input and output. Now they want to move to a web-based frontend.

Is there any solution to export the access masks into html forms? Ideally exporting the sql queries at the same time?

We looked into the possibility of MS Access 2000 exporting its masks into html, but the generated pages still need network paths and access itself.

What can we do?

 

DaveN




msg:672751
 4:48 pm on Mar 25, 2002 (gmt 0)

Hi Ulrike,

A materials management database is hosted on linux servers with MySQL. So far an MS Access frontend is used for input and output. Now they want to move to a web-based frontend.

I take it that you have some kind of ASP (chillisoft) Also running on the server.

I would rewrite the forms input pages and use ASP with a DSN-Connection.

DaveN

Crazy_Fool




msg:672752
 1:28 am on Mar 26, 2002 (gmt 0)

There are many ways to solve this.

1) The easiest way would be to use PHP to access the MySQL database - they work together beautifully. This of course means you need to be running the database on a Unix / Linux server with MySQL and PHP installed. You'll need to create data entry forms in HTML and write PHP scripts to take the entries from the HTML forms and put them in the MySQL database.

2) More awkward, but if you want to use Windows 2000 as your server, you can use ASP to access the MySQL database. I don't know how to install MySQL on windows servers, but i know it can be done (you've probably already done this as you're using Access on the machine). Again, you'll need to write your own HTML forms and ASP scripts. As ASP / MySQL combination isn't used much, you might find documentation and help a bit scarce.

3) A more common way of using databases on Windows servers is to use ASP and Access databases. This will involve transferring all data from the MySQL database to an Access database. If you can't get things worked out with options 1 or 2 then this is probably the best way to go.

There are loads more ways to fix this, but the above methods are probably the easiest. I don't know of any way to export HTML forms and ASP / PHP code from the Access front end. If you can't do the coding yourself, you should be able to find a web developer who can write the code for you - it costs nothing to get a quote and if you go ahead it can save you a lot of headaches, time and effort, and if it's for business, it can save you money as well.

As a general rule, people will normally use PHP + MySQL on Unix / Linux servers, or ASP + Access / SQL Server on Windows servers. Mixing them up is awkward, often complicated, and often doesn't work as intended. PHP and MySQL *can* be run on Windows but I wouldn't recommend it - that's not what they were created to run on. There are versions of ASP that can run on Linux servers (Chillisoft and iASP) but as far as I know, none can connect to databases - in fact, the features of both are very poor compared to genuine ASP on Windows servers - so if you need ASP, use Windows. Access databases cannot be run on Unix / Linux servers.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved