473,287 Members | 1,709 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Switching from Ms Access to MySql

Experts/Programmers please advice on these questions.

1. Is Mysql secure than MsAccess (there are softwares avilable to
retrieve Ms Office Password)

2. Which 3rd Party tool Would You recommend for Administration,Query
creation.... Etc

3.Any tools for setup Mysql database to ship with ApplicationProgram
(Access need not be installed in a Windows machine)

4.Any known problems in a VB6/VB.Net - Mysql Combinations

Thank You In Advance

Nov 23 '05 #1
2 1522
Hi,
1. Is Mysql secure than MsAccess (there are softwares avilable to
retrieve Ms Office Password)
The server itself is at least as secure as Access, but you should be aware
that the MySQL server can only be as secure as the server that it runs on.
What are the concrete dangers that you're concerned about (colleagues who
use your machine, attacks via network/internet, ...)?
2. Which 3rd Party tool Would You recommend for Administration,Query
creation.... Etc
I would recommand MySQL Administrator and MySQL QueryBrowser, which aren't
even 3rd party tools. You can get them from the MySQL website:

http://dev.mysql.com/downloads/administrator/1.1.html
http://dev.mysql.com/downloads/query-browser/1.1.html

There's also a tool for migration purposes (supporting Access) - check out
this:

http://dev.mysql.com/downloads/migra...olkit/1.0.html
3.Any tools for setup Mysql database to ship with ApplicationProgram
(Access need not be installed in a Windows machine)
The Application program needs to have access to a MySQL server. That could
e.g. be a MySQL database that runs with a database service provider (check
out www.db4free.net if you need a public available MySQL database that
doesn't cost you anything). Drivers are available for all purposes you can
think of.
4.Any known problems in a VB6/VB.Net - Mysql Combinations


For VB6 you can choose ODBC, for VB.NET there's a specific .NET driver
available:

http://dev.mysql.com/downloads/connector/net/1.0.html

I hope, this helps - good luck :-).

Markus
Nov 23 '05 #2
ar*********@yahoo.com wrote:
3.Any tools for setup Mysql database to ship with ApplicationProgram


The first thing you need to be aware of is that you may not be licensed
to redistribute MySQL with your application, unless either your
application is licensed with the GNU Public License*, or you pay MySQL
AB for a license to redistribute MySQL.

See http://www.mysql.com/company/legal/licensing/index.html
and read the policies for yourself.

Regards,
Bill K.

* Or another approved Free/Libre Open Source Software license; see
http://www.mysql.com/company/legal/l...exception.html
Nov 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
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...
0
by: Matias Silva | last post by:
I am still a novice when it comes to MySQL and I was wondering if switching the indexing from INDEX to a FULLTEXT would have any dramatic repercussions on current searches based on the the INDEX...
17
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...
3
by: Dennis Wheeler | last post by:
I'm trying to find a commandline solution for switching projects. Currently I have to modify the IIS virtual directory path to the source files, and then open the solution file in .Net to be...
3
by: MLH | last post by:
I seem to remember a post in the distant past discussing how to switch to another open application window. IE, if WordPad is running, some API function that'll allow me to switch the focus to that...
15
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...
0
by: clevsone | last post by:
I had the whole not having <enable parent paths> checked problem and once that was checked it fixed half of my issuse. I currently link to a Access database using asp from a flash site (login) ,...
4
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...
1
by: garry.oxnard | last post by:
Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.