i want to run the below query on a Ms-Access database
CREATE TABLE products (
product_no integer PRIMARY KEY,
price numeric DEFAULT 9.99
when i run it, its seems that access doesnt like the DEFAULT 9.99 for some reason
however if i run the query in SQL Server it works fine, but i need to run it on
an access database
ne1 any ideas of a way round this ???