MySQL Forums
Forum List  »  Microsoft Access

Re: HELP!!!!
Posted by: Jake Yazici
Date: July 12, 2005 11:35PM

Hi!

Regarding the lookup fields, I'm pretty certain that this is primarily an MS Access feature with no direct equivalent. However, the feature can sort-of be synthesized by using forms in datasheet view. Fields that will be pulldowns should be changed to ComboBox controls in the form. In the properties dialog for the combobox control, the row source type property should be set to "Table/Query", and the row source property should be set to the name of the table for the key. The bound column property should be set to the column "number" corresponding to the key field.

As far as the File DSN goes, I just went through this exercise. File DSN creation fails impressively when trying to create a file DSN using the ODBC driver management GUI. The way around it is to simply use your favorite text editor (notepad will do), and hand craft the DSN. Just create a new text file (call it "MyFooFileDSN.dsn"). Here's a template for syntax that supports the latest ODBC driver.


DRIVER={MySQL ODBC 3.51 Driver}
SERVER=<IP address or qualified host name>
PORT=<server port, default 3306>
DATABASE=<database name>
UID=<db user account name>
PWD=<db user account password>
OPTION=<numeric>

As an example ...

DRIVER={MySQL ODBC 3.51 Driver}
SERVER=FooServer.corp.foobar.com
PORT=3306
DATABASE=funstuff
UID=gandalf
PWD=thewhite
OPTION=16834

-Jake

"I conclude that there are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies and the other way is to make it so complicated that there are no obvious deficiencies." - C. A. R. Hoare

Options: ReplyQuote


Subject
Views
Written By
Posted
3294
July 12, 2005 09:10PM
Re: HELP!!!!
2112
July 12, 2005 11:35PM
1880
July 13, 2005 01:34AM
2021
July 13, 2005 12:45PM
1919
July 13, 2005 01:54PM
1937
July 15, 2005 02:06PM
1971
July 15, 2005 04:12PM
1929
July 17, 2005 09:04PM
2007
July 27, 2005 08:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.