469,924 Members | 1,545 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,924 developers. It's quick & easy.

seeking some guidance

hi there,

I am quite interested in making the move from Access to MySQL. I have
grabbed all the software that is needed (MySQL, MySQL Control Center, MaxDB,
etc.) and have installed it all without a hitch, everything is running
smoothly, so far. My only concern is that I am still trying to look at
everything from a Access point of view; meaning, I am trying to find out how
to create forms and reports and what not.

The reason for this is I already have an extensive database put together in
Access. If I go and create the tables from my access database into MySQL how
would I go about creating the Forms, Reports, and other Queries that I
utilized on my Access Database on the MySQL database. (it's late here so my
thoughts aren't as sharp right now...I apologize if none of this is making
any sense..hehe).

Simply put, does MySQL have the functionality for generating forms, reports,
macros, etc. or is it strictly just for the hard data end of things and I
need another program to tackle the rest of the stuff?

thanks in advance
Jul 20 '05 #1
5 1587

"chanchito_cojones" <ch**********@hotmail.com> wrote in message
news:pe********************@rogers.com...
hi there,

I am quite interested in making the move from Access to MySQL. I have
grabbed all the software that is needed (MySQL, MySQL Control Center, MaxDB, etc.) and have installed it all without a hitch, everything is running
smoothly, so far. My only concern is that I am still trying to look at
everything from a Access point of view; meaning, I am trying to find out how to create forms and reports and what not.

The reason for this is I already have an extensive database put together in Access. If I go and create the tables from my access database into MySQL how would I go about creating the Forms, Reports, and other Queries that I
utilized on my Access Database on the MySQL database. (it's late here so my thoughts aren't as sharp right now...I apologize if none of this is making
any sense..hehe).

Simply put, does MySQL have the functionality for generating forms, reports, macros, etc. or is it strictly just for the hard data end of things and I
need another program to tackle the rest of the stuff?

thanks in advance

MySQL is a database management system. No forms or reports. One thing you
can do is create a data source (you have to download the odbc driver from
MySQL.com) and using Get External Data from Access either import or link the
data from the mysql database. Then you would be able to use Access's forms
and reports capabilities. I don't know what overhead you will incur by going
through Access.

Rich
Jul 20 '05 #2

"Rich R" <rr***@cshore.com> wrote in message
news:F5****************@newssvr17.news.prodigy.com ...

MySQL is a database management system. No forms or reports. One thing you
can do is create a data source (you have to download the odbc driver from
MySQL.com) and using Get External Data from Access either import or link
the
data from the mysql database. Then you would be able to use Access's forms
and reports capabilities. I don't know what overhead you will incur by
going
through Access.

Rich

Thanks for the reply Rich. I understand what you mean by using the ODBC and
then importing from Access. But what if I would be in a situation where I
would no longer be able to use Access. Do you know of any other programs out
there that offer the same capabilities in regards to making it easy for the
developer and the user to manipulate and call forth the data from the
database? From a web based perspective would this be something such as PHP?
and if so, what would its equivalent be in a non-web-based application.

Sorry for picking your brain there Rich, I am just trying to wrap my own
around all this stuff. hehe

cheers


Jul 20 '05 #3
chanchito_cojones wrote:
"Rich R" <rr***@cshore.com> wrote in message
news:F5****************@newssvr17.news.prodigy.com ...
MySQL is a database management system. No forms or reports. One thing you
can do is create a data source (you have to download the odbc driver from
MySQL.com) and using Get External Data from Access either import or link
the
data from the mysql database. Then you would be able to use Access's forms
and reports capabilities. I don't know what overhead you will incur by
going
through Access.

Rich

Thanks for the reply Rich. I understand what you mean by using the ODBC and
then importing from Access. But what if I would be in a situation where I
would no longer be able to use Access. Do you know of any other programs out
there that offer the same capabilities in regards to making it easy for the
developer and the user to manipulate and call forth the data from the
database? From a web based perspective would this be something such as PHP?
and if so, what would its equivalent be in a non-web-based application.

Sorry for picking your brain there Rich, I am just trying to wrap my own
around all this stuff. hehe

cheers

Hi,
You can use a programming language like VB.NET or C# or any other
language capable of using ODBC database to create an application that
will use your database as a backend. This will allow you te easilly
create forms and "macros". For the reports you can generate them "by
hand" or use a thid party control like Crystal Reports.

Mathieu Pagé
Jul 20 '05 #4

"Mathieu Pagé" >>
Hi,
You can use a programming language like VB.NET or C# or any other language
capable of using ODBC database to create an application that will use your
database as a backend. This will allow you te easilly create forms and
"macros". For the reports you can generate them "by hand" or use a thid
party control like Crystal Reports.

Mathieu Pagé


Thanks for the reply.

cheers

Jul 20 '05 #5
chanchito_cojones wrote:
I am trying to find out how
to create forms and reports and what not.


Why not use all of your existing forms & reports in Access as they are,
and reconnect the tables to MySQL through ODBC? Then you don't need
another tool for creating all of this. There are some challenges to
get it all to work (see www.mysql.com/doc for details), but when you do
get it there, it works well.

Jul 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ben Sehara | last post: by
3 posts views Thread by Gustaf Liljegren | last post: by
8 posts views Thread by jason | last post: by
reply views Thread by Patrick.O.Ige | last post: by
3 posts views Thread by Jia Lu | last post: by
1 post views Thread by SteveV | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.