existing SQL database into adp

A

Andy G

All i'm doing is creating a new Access .adp and then connecting it to an
existing SQL Server Database. It correctly brings in (connects) all the
tables and views but does not bring in all of the stored procedures. It
doesn't seem like there are any settings to tell Access to bring in all of
the stored procedures. If anyone has an idea or direction to point me in,
it would be greatly appreciated.

Versions:
Access Access 2003 (11.5614.5606)
SQL Server 8.00.0818
 
A

Andy G

I looked at them but didn't know which permissions whould have an effect on
them if they were connected to my ADP. Are there specific permissions that
deal with this problem?

Thanks!
 
R

Robert Morley

Are you SURE it's not bringing in the SPs? Unlike the Enterprise Manager,
Access just mixes in the SPs with the Views...or at least it does in Access
XP, I can't be sure about Access 2003.


Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top