Upsizing to client server. Useable on Windows and Linux.

[risicare]

I have an Access database that has been my design platform. It now does everything I want it to do. I now wish to upsize it to client server. Ideally I would like a SQL-based relational database that will be as comfortable running on Linux as Windows. I intend to write a browser based front-end, I was thinking about using Dreamweaver running Java (but I would like to keep costs down). My understanding is that ASP will not work with Linux. Does anyone have any views, hints, tips, suggestions about the best route to take? I'm quite prepared to learn my way through the new technology, I just want to make sure I'm on the right path to start with. I'm looking at open-source products like PostgreSQL, MySQL, SAP, and McKoiSQL at the moment. Any help gratefully received, (don't be fooled into thinking I know what I'm talking about).
Cheers
Jason

 

[markphsd]

PHP And mySQl. That would work on Linux and Windows.

Nothing Active X

Java would work, JSPages and mySQl. Maybe use crystal reports for reporting.

You'll have to learn a fair amount of new development ideas when using these systems.

You shouldn't have developed the product on Access unless you were just making a model of what you were going for. It's probably going to be a pain to convert if you app is at all complex. However, good luck.. cause it's what i'm going to have to do also. I started off knowning very little about programming, now I would like a more distributable piece of software.

If I were you, I would consider the value of making it widely distributable, over selling it now and converting in the future.

Also, i just found a piece of software on the internet that runs Access and Office Programs on linux. It's abit pricey though, probably like 70 bucks. I don't remember, but you could find it on linux websites.


Mark P.

Bleh

 

[BNPMike]

You can use ASP on Linux. It used to be called Chillisoft but is now called something like Sun One.

Personally I think PHP is much nicer that VB because it is simpler and straight-forward. The trouble with VB/VBA/VBS is all those horrrible object models you have to learn before you can do the simplest things. The language itself is just fine.

If however you're comfortable with ASP/Sun One then use that. I get it free for example on my Webfusion (UK) Linux server.

 

[risicare]

Thanks guys. I started with Access because that's what my employer at the time used. But it's a good enough grounding in database basics. My Access app is suited to one of my market segments so no wasted energy. In fact I'm going to ensure my browser front end can speak with both the Access and MySQL databases.
For others using this forum I thought I would mention that I've downloaded and set-up MySQL, Apache, PHP and some other stuff like ADODB from

http://www.apachefriends.org.

Took about 15 minutes, and worked first-time on XP-Pro - fantastic.
Can anyone recommend some good PHP online tutorials? On the other hand, perhaps that's a different forum ...
Again thanks for your input guys,
J.
UK