readonly error: using dao with mysql

[cihatkarli]

im tryiny to create a table and fields with dao in a mysql db. i create them but when i try to write something an error "db is readonly" occurs.

Any ideas?

 

[ChrisHirst]

no idea. Do we get to see your query and the way you are calling it?

are you using a client side cursor? or a dataset that is readonly?


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[cihatkarli]

Set ws = DBEngine.Workspaces(0)
Let strConnection = "ODBC;DSN=takip;"
Set vtab = ws.OpenDatabase("", False, False, strConnection)
'Workspaces(0).OpenDatabase(App.Path & "\vt.mdb", x1gln, x2gln)


Set tdef = vtab.CreateTableDef(Tablo)
--------------
-For i = 1 To Len(alan)


x:
8 kk = Mid(alan, i, 1)
If kk = "," Then j = j + 1: i = i + 1: GoTo x
alani(j) = alani(j) & kk
Next


For p = 1 To Len(tip)
xx:

yy = Mid(tip, p, 1)
If yy = "," Then t = t + 1: p = p + 1: GoTo xx
If yy = 1 Then tipsx(t) = dbText
'If yy = 2 Then tipsx(t) = dbFloat
If yy = 2 Then tipsx(t) = dbDate
Next

For i = 1 To j

tdef.Fields.Append tdef.CreateField(alani(i), tipsx(i), 50)

Next


vtab.TableDefs.Append tdef

-------------------------------------

this is how i create table

--------------------------

and this is my query


---------------------

Call tblb("select * from " & Tablo.Text)



tbl.AddNew

---------------------
DANG!! Error

And i'm getting a catastrophic error if i use ado to connect :'(

 

[Nimroduk]

I seem to recall something about having to perform a "flush privlidges" command on the MySQL DB after modifying the structure or user permissions; this could be your problem ?