Just had an interesting experience. I have just created my ER Model In EA for an Access 2000 DB, specifying Foreign Keys which point to an Autonumber primary key. Access likes these FK fields to be long integer which I dutifully did in EA. However the following SQL will not run:
CREATE TABLE Address (
Id Counter NOT NULL,
Building Text(100),
Street Text(100),
TownCity Text(100),
CountyArea Text(100),
Country Text(50),
PostCode Text(50),
TelNo Text(50),
FaxNo Text(50),
Type Text(10),
FkCompanyId long integer
)
;
as 'long integer' is not liked. Instead you have to use 'long'. So you have to be careful to select this in EA for your FK datatypes if linking to a PK autonumber field.
I am also evaluating a tool called urSQL that runs the EA code straight - covers a number of DBs e.g MySQL as I could not get MsAccess itself to run the EA DDL code.
Any feedback on this gratefully received.
Thanks,
Sam
