>Because of a short term deadline for upgrading a new client's software we have a need to interact with Access tables via ODBC. I've tried remote views and connections for SQL pass through but no matter what I do, either SQLCONNECT() or CREATE SQL VIEW, a dialog box pops up asking for the .MDB Access table. Is there a way to stop this behavior?
>I'm probably missing something very fundamental but I just can't find it.
>
>TIA
>Mike
try it like this:
create database myaccess
create connection myconnection
The designer will pop up. Hit "new data source" and then "add" then add a new Access ODBC data source. You will enter a name. Halfway down that dialog box, there is a button for "select database" hit that and select your database.
Be aware: You'll probably have to mark all the fields as updatedable and choose the key fields when you define a remote view.
Good luck!
--Todd Sherman
-Wake Up! Smell the Coffee!