SV: Newsgroup ???

2001-09-26 Thread Ann Myhre
I am not sure, but it seems like the newsgroup mailing.database.myodbc is the same as this mailinglist? (Sorry if I create confusion, I am not quite sure I understand what you ask for.) Ann - Original Message - From: Jeremy Zawodny <[EMAIL PROTECTED]> To: Christopher Raymond <[EMAIL

Access as frontend with MyODBC

2001-09-26 Thread Ann Myhre
Hi group I don't know if my problem is Microsoft or MySQL so i try here first. I have installed MySQL and MyODBC on the same machine as I have Access. I would like to connect to MySQL using Access as frontend, but when I have done the whole procedure with ODBC, I get a message, saying: Fileda

Enum

2001-09-17 Thread Ann Myhre
Hi group Access has a datatype (I don't remember the name) which is a kind of boleaen; it represents Yes/No, true or false. When I try to translate that creating a table in MySQL I try ENUM("N","Y") but I do not get the expected result when using If Y then...(ASP). Do I use ENUM right? I have

SV: Renaming Columns...

2001-09-12 Thread Ann Myhre
Rename is for Tables (I think ...I am fresh, too. So fresh that I send it to you privatly. Sorry about that!) ALTER TABLE table1 CHANGE column1 coloum2 varchar(20) not null [or what ever datatype]; gives you what you want. Ann - Original Message - From: Deryck Henson <[EMAI