Database tutorial problem

[mgillow]

I've had a check through the forums, and while I can find this particular problem - the resolution is a little vague.

I want to use SWFKit to display data from an Access database - great I thought, there's a demo and everything!

I'm having the problem where I get the 'Microsoft JET Database Engine:Selected collating sequence not supported by the operating system' error when accessing the database from the demo.

I am using Win XP with SP2 patched up to date, and I'm pretty sure I've got all of the ADODC and Jet working fine, as I can connect up to the access database from Visual Basic using the same ActiveX and connection details without any problems.

From checking through the forums, it appears to be the following that's the problem:

record.Open("select id,name,age,sex,score from student", conn, 1, 2);

If you replace this with

record.Open("select * from student", conn, 1, 2);

the read data works OK, but then if you try and save back an updated record - you get errors again (using the update student set name='" + FlashPlayer.name + "' ... command).

Has this problem been resolved or is there a workaround?

[SWFKit]

The mdb file we used in the sample was set to sort by Chinese pronouncation, so it may not work well on some kind of platforms. We have updated the sample, please try it again:

http://www.swfkit.com/swfkit/samples...tabase_src.zip

If you still have problems, please let us know.

[mgillow]

Works perfectly - thanks for the quick reply

;D