Access to mySQL export giving -7776 Reserved error

[jbiggs via AccessMonster.com]

I am in the process of converting our backend from Access to mySQL. There are
21 tables and all of them except for one exported correctly.

Our clients table is giving me problems and I suspect it is from several
date/time fields that are included in the table. Do do date/time fields need
to be a certain format or have a certain default value before export?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

[jbiggs via AccessMonster.com]

From the MS Jet DB error codes I found 7776 means:

Illegal date/time value returned.

I did not write this application but I do know one of the columns is using a
timeserial function to set it. Does anyone know what format I need to get
this into or some kind of manual workaround?

jbiggs wrote:

>I am in the process of converting our backend from Access to mySQL. There are
21 tables and all of them except for one exported correctly.

Our clients table is giving me problems and I suspect it is from several
date/time fields that are included in the table. Do do date/time fields need
to be a certain format or have a certain default value before export?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

[Albert D. Kallal]

You could export the table to a text file..and then use the mysql import
features...

the other possible is to convert the field to a text field...and export
that...

I would check in the mysql newsgroups, and see what they have to say on
this....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com

[jbiggs via AccessMonster.com]

I ended up deleting one of my columns which was set using a timeserial
function. There must have been rows which fell outside of what mysql was
expecting. I am going to recreate the column in mysql.

Albert D. Kallal wrote:

>You could export the table to a text file..and then use the mysql import
features...

the other possible is to convert the field to a text field...and export
that...

I would check in the mysql newsgroups, and see what they have to say on
this....

--
Message posted via http://www.accessmonster.com

[Tony Toews [MVP]]

"jbiggs via AccessMonster.com" <u33089@uwewrote:

>I ended up deleting one of my columns which was set using a timeserial
function. There must have been rows which fell outside of what mysql was
expecting. I am going to recreate the column in mysql.

Run a query against those date fields looking for date values in years before, say,
1900 or after 2008. In one table I was upsizing there were about 12 wrong dates
out of 100,000 records.

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