Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length
May 24, 2012, 08:37:00 AM

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: where to start  (Read 342 times)
nayborbob
Newbie
*
Offline Offline

Posts: 2


WWW
« on: March 25, 2003, 07:29:00 AM »
hi

I am totally new to web design.  I have a MS Access application I created, and have created a runtime version of for potential sale.

What I really want to do, is put the application on the web so users can run the db program on the web.

Need help on where to start.  Hoping that all the work I did to develop my application (forms and >20k lines of code) is not for naught - that there is some slick way to convert to asp pages or something like that.

I presume I would pay lunarpages for space on a server.  Not sure about much after that.

Help
Bob
Logged
stephan
Guest
« Reply #1 on: March 25, 2003, 03:43:00 PM »
Hello,

You can use lunarpages to host your .asp files,

but you cannot use an Access database at the moment.

However, you can use a mySQL database, which can be connected to from ASP.

You would have to adapt your program slightly, but if you are a programmer, it should be easy enough for you.
Logged
TWebMan
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3112



WWW
« Reply #2 on: March 25, 2003, 09:41:00 PM »
You're in luck!  There's a program that smoothly converts your Access DB to MySQL.  It's at

 http://www.dmsofttech.com/access2mysql.html

But if you're not a designer and you designed a 'live' webpage from Access, it may not work on the server.  It may be a good idea to get a little help for the site.
 
 [ March 26, 2003, 05:46 AM: Message edited by: TWebMan ]
Logged
"Computers cause people to make more mistakes than any other invention in history, with the possible exception of handguns and tequila."  - Unknown
"Liberty of any kind is seldom lost all at once." - D. Hume
Every day is an Ode to Joy
The planet will be fine... and so will your site
nayborbob
Newbie
*
Offline Offline

Posts: 2


WWW
« Reply #3 on: March 26, 2003, 04:12:00 PM »
On the topic of conversion to mySQL:  You are telling me I can convert the forms, and all the vb code ?

Is there someplace where I could see a simple example of this (MS access db to mySQL) ?

I don't understand what the development environment looks like using mySQL compared to using MS Access.

Do I have to buy mySQL ?  Wouldn't I just be better off to find a site that uses MS Access or MS SQLServer (sorry if thats not you - I have already invested >$1000 in MS XP developer) ?

Thanks
Logged
TWebMan
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3112



WWW
« Reply #4 on: March 26, 2003, 04:23:00 PM »
The Access2Mysql program will only convert the database tables.

As for the scripting, you would have to connect it to the mysql database.  As far as db connections go, it's one of the easiest.

You can find a server that will host an Access database, but IMO those are rather cumbersome, and usually quite expensive.

MYSql is a database server, and it's geared towards multiple users.  I've seen too many NT/2000 servers lag and give problems, but again that's my opinion.

There would be a bit of work involved to convert the code to connect to the mysql database, but if you choose to do it, you only have to do it once  "[Smile]"

The program you're using may have sql provisions.
Logged
"Computers cause people to make more mistakes than any other invention in history, with the possible exception of handguns and tequila."  - Unknown
"Liberty of any kind is seldom lost all at once." - D. Hume
Every day is an Ode to Joy
The planet will be fine... and so will your site
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: