From Access to MySQL

[Guest]

This semesters project is a data base registration system for a convention
center here in Upastate NY. They have decided that they want to be able to
access the system via the Internet. Not the public, only the people
responsible for registration. We intend to build the system with an Access
backend, and a .net front end.

My question is, has anyone here have experience with MySQL and what are
their opinions and advice. We are researching the problem, but just thought I
would ask the Access pros.

Thanks
CoachBarkerOJPW

 

[George Hepworth]

MySQL is a database application which would be a replacement for your Access
backend, so unless I misread your requirement to use Access as athe backend,
it's a moot point.

 

[Guest]

I guess the question is can we create it in Access and migrate the Access
data base to MySQL.

 

[Guest]

To clarify even more. At first the customer only wanted a networked system at
their place of business. For this we would have used Access. One of them
travels and decided that he would like to be able to add and update
reservations while on the road. So one solution was to use MySQL as the data
base, what we were wondering was that if we create the application using
Access, would we then be able to upsize or migrate the system from Access to
MySQL. None of us have ever done anything with MySQL.

Thanks
CoachBarkerOJPW

 

[storrboy]

To clarify even more. At first the customer only wanted a networked system at
their place of business. For this we would have used Access. One of them
travels and decided that he would like to be able to add and update
reservations while on the road. So one solution was to use MySQL as the data
base, what we were wondering was that if we create the application using
Access, would we then be able to upsize or migrate the system from Access to
MySQL. None of us have ever done anything with MySQL.

Thanks
CoachBarkerOJPW

I have worked some with MySQL, and from my experience, it would not be
a 'simple' thing to 'upsize'. You can obtain MySQL ODBC drivers to use
in Access, so it may be simpler to create an Access front-end for LAN
use, and a web interface for WAN use. Depending on the web server, you
can also use an Access back-end, but I feel MySQL is better suited in
that role.

 

[Tony Toews [MVP]]

This semesters project is a data base registration system for a convention
center here in Upastate NY. They have decided that they want to be able to
access the system via the Internet. Not the public, only the people
responsible for registration. We intend to build the system with an Access
backend, and a .net front end.

Consider using SQL Server Express. It's free and will provide better
compatibility to Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm