automatically lowercase all tables/fields?

[GeekSupport]

is there a way to automatically lowercase all tables/fields? we're starting a project that will be using an msaccess database that will be converted to mysql on a weekly basis. access will be used for the office and some tables/fields will be used for online purposes. is there a way to force mysql to lowercase all the tables/fields that it creates?

[MattR]

MySQL is case-insensitive, can you explain why you need them all to be the same case?

[GeekSupport]

oh. i thought it was case-sensitive thinking the php script would break if i don't remember how the access admin cased the tables/fields. this makes my job a lot easier (and the only thing i make UpperCase are classes the rest are joined like_this)

[GeekSupport]

doh!
error
select no from local
Table 'cft_locals.local' doesn't exist

success
select no from Local
[displayed list]

it looks like the table is case sensitive, but the field is NOT case sensitive (the field "no" is actually cased No in the Local table)