I have this VB program using MSAccess database.
Do i have to make major modification in the program? or can I create the MySQL database similar to MSAccess with same fields, tables, primary fields, then do i have just to modify the part in the program which would CONNECT to the MySQL database? the rest will remain intact like the relationship I have established in the code, the display of the fields, editing, etc.
I am asking this because I am not familiar in how an MySQL database looks like, if it can be made the same with MSAccess? Create the same field names, tables and database name?
Please advise. Thanks and more power to you guys.
2  1118 
The answer is not just that simple. Since MySQL is a relational db using standard SQL as the query language, you'll probably have to change some of your setup (indexes, keys, etc) and queries from your programs. But I assume that is not a problem that can't be solved.
When migrating to MySQL and still prereserving the MSAccess characteristics of your data and programs, you'll have to know a bit more about MySQL. Have a look at this thread, with a member having the same question: http://www.thescripts.com/forum/thread567118.html
Ronald :cool:
The answer is not just that simple. Since MySQL is a relational db using standard SQL as the query language, you'll probably have to change some of your setup (indexes, keys, etc) and queries from your programs. But I assume that is not a problem that can't be solved.
When migrating to MySQL and still prereserving the MSAccess characteristics of your data and programs, you'll have to know a bit more about MySQL. Have a look at this thread, with a member having the same question:
http://www.thescripts.com/forum/thread567118.html
Ronald :cool:
thanks and i will look into your suggestions.more power to you.rgds.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: John |
last post by:
Hello.
I am currently working through a book on Dreamweaver and using PHP. I
am having a little trouble with setting up the database though. I
have php 4.2.3 and MySQL 4.0.20a. I am running...
|
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no...
|
by: Ryan Schefke |
last post by:
------=_NextPart_000_0077_01C34C8B.2B90C960
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
..I just sent this out to the win32 distribution list but no one has...
|
by: Maciej Wiznerowicz |
last post by:
Dear Sirs,
I can not start MySQL server.
More specifically, MySQL was running fine all the time since
installation. It stopped working after I used FmPro Migrator to convert
some File Maker...
|
by: Morten Gulbrandsen |
last post by:
Hi programmers, Good morning ;-)
I think something is wrong,
Running windows I believe first I have to set some password,
Which creates some user,
Then I can grant the required privileges, for...
|
by: chicha |
last post by:
Hey people,
I have to convert MS Access 2000 database into mysql database, the whole
thing being part of this project I'm doing for one of my faculty
classes. My professor somehow presumed I...
|
by: Beda Christoph Hammerschmidt |
last post by:
MySQL, Access, ODBC, Replication
Hello,
i have a central mysql database that is accesed by multiple clients
running MS Access with ODBC.
This works fine if Access has a permanent connection...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: B1ackwater |
last post by:
We've fooled around with Access a bit, but only using the
single-user store-bought version. It seems to be a good
database - versatile and infinitely programmable - and
can apparently be used as a...
|
by: Vanessa |
last post by:
Hi there
I am an Access developer, and I have written applications for a 30
telephone call center, using the standard multiuser jet engine, it all
works fine, but I want to move our systems onto...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
