I've migrated all tables and data from Access 2000 to SQL
2000. DTS worked wonderfully ...after I fixed the data in
Access to comply with SQL format.

Anyway, now I am starting to migrate all queries into
Stored Procedures & Views, but I'm running into a common
issue ...a lot of the Access queries are pointing to an
Access form for information. We've decided to keep Access
as the 'Front-End" to make it easier on the users.

Question: Is there a way to point a SQL Stored Procedure
to an Access 2000 form?

It would be REALLY cool if I could do somthing like:

WHERE [Access.MDB].Form '=' <paramater>

....or any other referencing to Access from within SQL.

It sure would help in migrating my queries quickly if this
can be done! Since we're keeping Access as the front-End,
creating stored procedures that point to it shouldn't be a
problem ...or should it?

Any help would be appreciated.

Stephen