migrating MS Access to MySql Server

JET will never be supported on X64 natively. It's a known feature.
It's not a bug-- X64-- the future-- doesn't support JET because JET is
obsolete.

Windows Server 2008 and Windows Vista were supposed to be the last OS
that had a 32 bit version.
Do the math.

Yet another symptom that JET is dead and anyone using it should learn
a real DB.
JET has no place in the world-- except in the history books.

-Aaron





On Jul 4, 9:27 pm, "Larry Linson" <boun... RemoveThis @localhost.not> wrote:
> "a a r o n _ k e m p f" <aaron_ke... RemoveThis @hotmail.com> wrote
>
>  > I'm not sure that half of the ODBC features work on X64
>
> When you determine what doesn't work, post back and let us know.  It would
> be helpful to others if you'd file an error report with Microsoft Support,
> too.
>
>  Larry Linson
>  Microsoft Office Access MVP
>
>  > a a r o n _ k e m p f  wrote:
>
>  > > which components of JET don't work on X64 editions of Windows?
>
> David Fenton responded:
>
>
>
> > You're the one making the argument here, so *you* tell *us* what
> > parts of Jet don't work.- Hide quoted text -
>
> - Show quoted text -

a a r o n _ k e m p f <aaron_kempf.RemoveThis@hotmail.com> wrote in
news:821ffad1-5b21-43e9-89fe-371336e87aca@v26g2000prm.googlegroups.co
m:

> uh lots of ODBC doesn't work on x64
> lots and lots and lots of them.

I thought were were talking about Jet, and you don't need ODBC to
connect to a Jet database.

So, you seem to be very confused about what you're talking about
(not that this is surprising).

> I'm not sure that half of the ODBC features work on X64

Get back to us when you're sure, and provide URLs that document the
problems. And if you actually want to make your point, provide some
documentation that *Jet* doesn't work -- ODBC is completely
irrelevant.

Until that point, you've demonstrated nothing at all but your
ability to post useless blather (not that we needed any more
evidence of *that*).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

san_quentin76 <sanquentin76.RemoveThis@discussions.microsoft.com> wrote:

>I'm an end user primarily and I need to know how to configure or export
>Access tables and all of its other objects to a MySql Server so it can run
>faster. Currently the Access databases are becoming too large and cumbersome
>dramatically affecting processing time.

How large is your database in terms of MB and the number of records in
the largest tables? Do you have proper indexes on the tables for the
various searching and filtering fields?

Are there any specific things that have become slow?

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

san_quentin76 <sanquentin76.RemoveThis@discussions.microsoft.com> wrote:

Also please ignore any sub threads involving Aaron Kempf. He is a
well known "troll" and general irritant in the newsgroups.

Thanks, 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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Dude Tony

You cannot prevent Jet bloat-- so go and sell your wares elsewhere.
oh.. Oh I noticed that you sell ads on a webpage and thus you need to
disclaim that everywhere you go.

What are you really going to listen to a dipshit canadian?

What a NooB

-Aaron





On Jul 6, 6:08 pm, "Tony Toews [MVP]" <tto....TakeThisOut@telusplanet.net> wrote:
> san_quentin76 <sanquenti....TakeThisOut@discussions.microsoft.com> wrote:
> >I'm an end user primarily and I need to know how to configure or export
> >Access tables and all of its other objects to a MySql Server so it can run
> >faster.  Currently the Access databases are becoming too large and cumbersome
> >dramatically affecting processing time.  
>
> How large is your database in terms of MB and the number of records in
> the largest tables?   Do you have proper indexes on the tables for the
> various searching and filtering fields?
>
> Are there any specific things that have become slow?
>
> 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 athttp://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Dude Tony

You cannot prevent Jet bloat-- so go and sell your wares elsewhere.
oh.. Oh I noticed that you sell ads on a webpage and thus you need to
disclaim that everywhere you go.

What are you really going to listen to a dipshit canadian?

What a NooB

-Aaron





On Jul 6, 6:08 pm, "Tony Toews [MVP]" <tto... DeleteThis @telusplanet.net> wrote:
> san_quentin76 <sanquenti... DeleteThis @discussions.microsoft.com> wrote:
> >I'm an end user primarily and I need to know how to configure or export
> >Access tables and all of its other objects to a MySql Server so it can run
> >faster.  Currently the Access databases are becoming too large and cumbersome
> >dramatically affecting processing time.  
>
> How large is your database in terms of MB and the number of records in
> the largest tables?   Do you have proper indexes on the tables for the
> various searching and filtering fields?
>
> Are there any specific things that have become slow?
>
> 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 athttp://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/