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