For Programmers: Free Programming Magazines  


Home > Archive > PHP Programming > July 2005 > ACCESS Database & MySQL and properties in PHPMyAdmin









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ACCESS Database & MySQL and properties in PHPMyAdmin
bettina@coaster.ch

2005-07-31, 5:15 pm

I had an Access database and I had always used in my tables (whenever
possible) pop up lists to choose elements.. for example, for a column
I've wrote in "Datensatzherkunft" SELECT tbl.field1 FROM tbl WHERE
tbl.field2 LIKE 'XXX'; or I could say that only certain values are
allowed: "X";"O";"S" as an example.
Now I have exported my Access Database to MySql and established from
Access a relation to MySQL so that I can update the database direct
from Access and no from PHPMyAdmin.
The problem is that these information about "where to whole the data
from.." that's to say the "Select tbl.field1...." where not exported
and in PHPMyAdmin I cannot find where I can define such attributes. If
I try to do it from Access I receive I message saying that I cannot
change the properties of the database since it is a linked
(verkn=FCpfte) table. Any idea how can I "export these properties too or
redefine them in PHPMyAdmin?

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2010 codecomments.com