Hello all,
Greetings from Scotland.
Can anyone help?
I have and Access 2000 Database. On MS windows 98.
I inserted the access to mysql text
I created the Module and inserted the , and I tried to run the macro.
Action - RunCode and
Function Name - export_mysql () I also tried export_mysql(). But each time
I run the Macro I get an error message.
In the Visual Basic window the following part of the code type is
highlighted in yellow it is part of the section Check Primary property.
For Each fld In idx.Fields
Type mismatch (Error 13)
'Check Primary property
k = k + 1
If idx.PRIMARY Then
istuff = " PRIMARY KEY ("
Else
istuff = " KEY ("
End If
f = 0
For Each fld In idx.Fields
f = f + 1
iname = fld.Name
For j = 1 To Len(iname)
If j < Len(iname) Then
If Mid$(iname, j, 1) = " " Then
s = Left$(iname, j - 1)
s = s & "" & Right$(iname, Len(iname) - j)
j = j + 1
found = True
iname = s
End If
Does anyone know what I have done wrong, and what I need to do to correct
it?
Thanks,
James Oliver
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
