Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
MS Access db messed up.. Want to convert to MySQL
Old 10-31-2005, 12:40 AM MS Access db messed up.. Want to convert to MySQL
Webmaster Talker

Posts: 626
Trades: 0
I designed an MS ACCESS db for my clients. After entering 40+ clients into (with a LOT of data) I got an error within MS Access. This basically gives me the feeling that it is going to be very unstable which I don't like.

I just downloaded a freeware program which coverts my MS Access file to MySQL. I would like to know if there is a tutorial that I can get which will teach me the basics of manipulating a MySQL db via PHP.

Now that I have gotten better at designing wesites, I would like to design input/display pages which will be accessed on a central computer via IE.

The problem is, I don't know where to start. I have already converted the db to MySQL and the data transferred no problem, next I guess I need to know how to manipulate data... ie. add, delete, edit records... Also, display records/information on the screen.

Any help is much appreciated.
Thanks in advance.
jim.thornton is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 10-31-2005, 01:44 AM
Average Talker

Posts: 16
Trades: 0
Here are a few tutorial links I used when I first started...

http://www.programmershelp.co.uk/mysqlphp.php

http://www.on3e.com/f1/scripts.php

and just type "php mysql tutorial" into google and you will get a bunch of good results. Have fun!
__________________
Focus Group & Paid Survey Database
Please login or register to view this content. Registration is FREE
hxed.com is offline
Reply With Quote
View Public Profile
 
Old 11-11-2005, 12:55 AM
priyanka's Avatar
Skilled Talker

Posts: 82
Location: Canberra
Trades: 0
MS-Access is recommended when you have 20 users not more than that.
Check out this resource :
http://dev.mysql.com/tech-resources/articles/ddws/
You might get some help there.
__________________
Cheers,
Priyanka-m6.net

Please login or register to view this content. Registration is FREE

We help in making your dreams come true on internet
priyanka is offline
Reply With Quote
View Public Profile Visit priyanka's homepage!
 
Old 11-16-2005, 12:14 PM
Minaki's Avatar
Defies a Status

Posts: 1,626
Location: Guildford, UK
Trades: 0
Quote:
MS-Access is recommended when you have 20 users not more than that.
That is, 20 concurrent users (accessing the database at the same time).

Another option is to look at Microsoft SQL Server. There's built in options to import directly from an Access database. Microsoft have also just brought out SQL Server 2005, which looks pretty good.
__________________
Minaki Serinde MCP
"Wow, Linux is nearly on-par with Windows ME!"

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
Minaki is offline
Reply With Quote
View Public Profile Visit Minaki's homepage!
 
Reply     « Reply to MS Access db messed up.. Want to convert to MySQL
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.13060 seconds with 12 queries