introducing mysql trouble

[shutzy]

i am trying to move all my tables over to my sql but i am having trouble with the functionality of my forms. in particular updating and creating new records.

for instance i have a form that goes to new record on open, however the unique id field is empty. there isnt a new record being created.

ive installed mysql. created a database. exported all of my tables out of access and then re-linked them back in. it asked a few questions on doing this. mainly which field is the unique id etc.

im wondering on how to get the database to function just how it used to do before exprting and linking to mysql.

thanks for any help given

 

[GinaWhipp]

While I wrote this SQL Server much of the same applies...
http://regina-whipp.com/blog/?p=371

Check to be sure you have not gotten bitten by the gotchas!

 

[shutzy]

regina, thanks for the blog. it seems like alot of work. is there a program that will check my table systems for me and tell me what column, table, record has conflicts. im not lazy but i would rather a computer do the work and it be without errors rather than human error coming into play.

i do use lookups but that is easily resolved. the checkbox im not too sure about. do i have to change the check box to text and input true/false into everyone?

thank you

 

[GinaWhipp]

No problem, as long as it helps one person, the work is worth it!

Sorry, there is no program, just us humans and our eyeballs!

To check field names...
http://regina-whipp.com/blog/?page_id=465
Side note, this is one of the many reasons people use a Naming Convention. By doing so the odds of using a Reserved Word are about 99.9 to .1.

If you are using a Check Box (BIT field Data Type) then just set the Default for the field to 0(zero) in MySQL and refreash your links that should resolve your problems. Note: You should refresh your links whenever making a change but you can wait until you've made all your changes before doing so.)

 

[shutzy]

refreshing links!! i thought that the links where permenant. how do i refresh links. also i have managed to get all of my data (tables) into mysql. there are some errors with data type. does datatype differ from access to mysql?

i did think it was a good idea to start all this now but i am thinking otherwise now. im taking all this in and as i am making changes to my database i shall be keeping all this in mind. i think it will probably take me a couple of months to transfer over so if its ok with you i will keep coming back with more questions. not too frequently but often.

thanks for your help

 

[GinaWhipp]

The links need to be refreshed, while permenant they are more like *snapshots* that will stay the same unless you make a change then you need a new snapshot. (Hmm, I see an addition to my Blog coming up!) To refresh links, from Access, go to External Data > Linked Table Manager > click Select All then OK.

Data Type Differences
http://regina-whipp.com/blog/?page_id=49

It is a great idea to do thus before you actually have to. Not only does it help your present database but future ones.

Come back as often as you like, we aim to please!