Linking through ODBC 1

[rjm13]

Hi folks,

I have a database, Frontend is ACCESS and the backend is MySQL. I am having no luck with autonumber fields. Does anyone know how configure the fields in both so that autonumber fields are compatible between the two databases?
Any help is greatly appreciated!

Thanks

R

 

[Darrylles]

Hi rjm,

Does this help:

http://forums.mysql.com/read.php?65,21073,21073#msg-21073

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[rjm13]

You know what, I thought that would be the solution, but after working with it, I'm still having the problem, Anyone else out there got a suggestion?

R

 

[Darrylles]

Hi rjm,

Sorry mate - how did this not fit with your problem - I'm stuck now - you gave me a star .

Without knowing MySql, I'm kind of tempted to suggest creating a 'dummy' field - making the autonumber field simple text, and making that the key field when linking with MySql.

However, I'm not sure how you mean to communicate between the databases....

Are you simply importing? Are you linking? What are you doing between these databases?

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[rjm13]

Hey Darrylle,

Thanks for getting back to me, I am linking to mysql with an ACCESS front end. I have a form that has a couple of subforms.

Your suggestion of adding the time stamp field to the main table that the main form derives from helped. 3 of my subforms work and one does not, it is totally crazy, if I look at the linked table through ACCESS I see the values I have added in the subform, when I look at the linked table in MySQL (where it resides) the values are not present!
This is driving me crazy, I've redone the links and recreated and put the subform on the main form like 10 times. Very frustrating.... Any help is greatly appreciated!

Thanks

R

 

[Darrylles]

rjm,

From this, the obvious way forward (apart from attempting to find an identical problem to yours on Google) is to ascertain the difference between your 3:1 subforms.

Are the sub-forms linking to different tables (sub-forms can link to the same table)? I'm pretty sure that they must be different tables, otherwise MySQL would not have this problem.

One obviously has a difference to the others. I think that finding that difference (table / field structure / type) will be the quickest way forward.

Have you looked at this in a logical way? i.e. create a table of all tables (E.G. in Excel) - with data-types etc? Look at the 'formats' set for that field especially.

Hope this helps, and I won't let this go (since you starred me you idiot - lol ).

Regards,

Darrylle








Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[rjm13]

Hey Darrylle

The Subform/Table setups are the exact same. Here is another twist. If I look at the table entries in ACCESS the records are there, If I look at the table in MySQL the records are not. And this is a linked table! How is this possible?

Thanks again,

RJM

 

[rjm13]

Problem solved! Re-linked that last table! Thanks for helping me through this, I owe you a beer

RJM