I am trying to commect to a Access file called DB1.MDB I can do it fine through a DNS connection but when I try

? SQLCONNECT([MS Access 97 Database; DATA=DB1.MDB])

Which I thought would work... It opens up a dialog box looking for the table I know I am close what am I missing?

This needs to be done without the DNS entry.

TIA Ron