By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,906 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,906 IT Pros & Developers. It's quick & easy.

Switching from Ms Access to MySql

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.