Link tables in access >> MYSQL

Access & MySQL do not have the same data types, thus when you link MySQL tables in Access, the fields will show a data type that Access would convert it to.  What is error 3219 and what is it that causes the error?

Hi!

I think the error message 3219 is caused by this Data type in the table in access.

Data Type --> Autonumber

What do i set this field to in MYSQL ??

Thanks for helping me out.

Tor

identity is the type of field you need in MySQL, combined with identity_seed

Regards,
Max.

Actually, that's just an int value, that you can auto_increment under the "Extra" part of MySQL.

Regards,
Max.

Hi DreamMaster!

When i tryed to set the Field in MYSQL to Auto Increment
and make the Link in access, i still get problems in access.

Is there a way to change Data-fields the Linkd table in access from DAO-code in vb6.0 ?

Have had this problem a long time now, and must be finish with this ASAP.

If you can give me a sourcecode in vb6.0 that i can change this fields in the linked table in access.
I realy be happy.

Thanks

Tor

What's the error you get?

Might be able to help you if I knew that...

Regards,
Max.

Hi!

The error is this:

When i use table in access (NO LINK) i start a report in access.
And everything working fine.

But when i try to link the table to MYSQL (with the same name as the table), and try to start the same report
It's stopp in a macro, that calls a function that is in a library (MDE-file)

Or if i quit access, and try to start access. I get this error message:

Run-time error '3219'
Invalid operation

What is going on.... Driving me crazy....

Thanks for helping me out.

Tor

Can you get the data from both mySQL and Access using your program? If so, you can synchronize them using a bit of conversion.

Personally, I have the strange feeling, the error is not in your datatypes, but in the way you try to compare them.

Regards,
Max.

Hi!

Yes i can get data from both mysql and access.

How do i synchronize them ?

But why dosent it work when i link the table, and working just fine when i dont use
link ? Thats why i think the problem is datatypes...

Regards,
Tor

The problem is more likely that you want to directly link them, while you could convert them to the datatype of the receiving database first...

Hi!

Please explane what you saying, don't anderstand... Sorry

What must i do then ?

Tor

Well, I think you can't just link the MySQL to the Access database, so you will need to retrieve the data, convert them to text, integer and long int, or their respective counterparts and then save them into your database...

Hi!

But how is the code for doing this, please give me a code
that i can use. Thanks you

Hope you can give me the source in vb6.0 for this.

Thanks

Tor

Also, go to your MySQL DSN and click on the Options button, there is a check box having something to do with "change bigint to int" or something like that, make sure that is checked and then try it.

Hi!

Tryed that, that dosent help...

Somthing else.....

Thanks

Tor

If you are trying to insert rows from your MySQL DB into Access, you cannot insert the AutoNumber field.  If the Access DB must have the same NUMM value as the MySQL one, you will have to change the AutoNumber to its Number equivalent.

J.

Hi!

Yes, but how is the sourcecode lock like for this ?

Thanks

Tor