existing SQL database into adp

  • Thread starter Thread starter Andy G
  • Start date Start date
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
 
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!
 
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
 
Back
Top