MySQL - MS Access

[John DOE]

Hello:

I need to change over from MS Access to MySQL, at least some of my tables,
and was wondering how difficult this will be. Is there a way to export
structure and data without much hassle?


Thanks.

 

[Todos Menos [MSFT]]

yeah.. SQL Server developers' edition includes some DTS designers that
make this pretty easy

I really reccomend sticking with MS SQL Server and using Access Data
Projects; especially if you have a complex frontend

moving to a linked-ODBC environment is not palatable in my opinion

 

[storrboy]

Hello:

I need to change over from MS Access to MySQL, at least some of my tables,
and was wondering how difficult this will be. Is there a way to export
structure and data without much hassle?

Thanks.

Take a look at the various tid-bits of info and tools at the MySQl
site before making too many decisions.

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

 

[Tony Toews [MVP]]

yeah.. SQL Server developers' edition includes some DTS designers that
make this pretty easy

I really reccomend sticking with MS SQL Server and using Access Data
Projects; especially if you have a complex frontend

moving to a linked-ODBC environment is not palatable in my opinion

Aaron had a decent response here.

However you should note that this person is really A a r o n K e m p f and that he
is not an employee of Microsoft.

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

 

[David W. Fenton]

Aaron had a decent response here.

Why would you say that? Microsoft has deprecated ADPs and is
recommending MDB to SQL Server using ODBC. How could that be
superior to MySQL? What about the licensing issues that come with
SQL Server and that are absent with MySQL?

I'm no fan of MySQL (I think it's mostly a toy database that is
trying to catch up with real database engines, like, oh, Jet), but
in this case, if a server database is required, ODBC is no reason to
prefer SQL Server.

 

[Tony Toews [MVP]]

Why would you say that?

Umm, you're right. The first sentence was fine. Not enough coffee I guess when I
typed my response.

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

 

[Todos Menos [MSFT]]

I'm still not sure I agree that 'microsoft has depecrated ADPs'

is that in writing somewhere?

I do believe that MDB are the files that are technically depecreated
ADPs have tremendous benefits in Access 2007

I mean get real David Fenton; you're a complete and utter fairy

-Todos

 

[Todos Menos [MSFT]]

You're no fan of mySql?

that's because you're a baby database programmer and you can't write
real sql by hand

grow some balls, kid

ODBC is a reason NOT to use JET because Ole DB has been proven to be
faster

I can do anything via ADO in a single line of code than you can do in
a dozen lines of mixed DAO/SQL

DAO is for retards
MDB is for retards

ADP is the future; it has been the future.

ADP is the best option for new users, intermediate users and advanced
users.

Maybe you kids should start to push for MS to fix bugs instead of
sitting here and preaching a Database that has been obsolete for a
decade.

MDB is dead.

SQL Server works great-

lose the training wheels you MDB fairy

 

[i_takeuti]

I'm still not sure I agree that 'microsoft has depecrated ADPs'

is that in writing somewhere?

I do believe that MDB are the files that are technically depecreated
ADPs have tremendous benefits in Access 2007

I mean get real David Fenton; you're a complete and utter fairy

-Todos