Visio to access - check clauses

[GISjockey]

I need to 'generate' check clauses along with my fields when going from Visio to MSAccess97.
It says... 'The SQL construct support in the Microsoft Access ODBC does not allow check clause to be part of the SQL statement. To populate the check clause, the program creates the check using DAO during the post-DDL generation phase when there is a live connection to the Microsoft Access MDB file. Live connection to the database is required.'

I thought I had a direct connection if I gen tables etc via ODBC, but the clauses do not come through.

Has anyone had success with doing this?

Thanks