MS-Access Project

[rn5a]

I created a new MS-Access project (with the .adp extension) &
connected the project to a existing SQL Server 2005 database. All the
tables, stored procedures etc. existing in SQL Server were imported to
this Access project but when I tried to create a new stored procedure
in Access in this Access project (by going to the Stored Procedure
object under 'Objects' & then double-clicking 'Create stored procedure
in designer'), Access generated the following error:

-----------------------------------------------------------------
Microsoft Access can't find the object 'Microsoft Access can't find
the object 'StoredProcedure1.'.'

* You misspelled the object name. Check for missing underscores (_) or
other punctuation, and make sure you didn't enter leading spaces.
* You tried to open a linked table, but the file containing the table
isn't on the path you specified. Use the Linked Table Manager to
update the link and point to the correct path.
-----------------------------------------------------------------

But I don't find any Linked Table Manager anywhere in the menus.

Can someone please point out where I might be going wrong?

Please note that I am working on WinXP Pro (SP2) & use MS-Access 2000.

 

[Norman Yuan]

Access project (*.ADP) does not "IMPORT" anything in SQL Server (Sql Server
objcts, like tables, SPs, Views...) into Access project. It is just a front
end user interface of application/develpment environment.

With Access2003 or older, you can use ADP with SQL Server2005, however, you
cannot use it for designing server objects (tables, SPs...) in SQL
Server2005, which makes developing ADP with Access for SQL Server2005 make
no sense any more. For ADP, you need Access2007 to work with SQL Server2005.

Although you can design server objects in SQL Server2000 with Access2000 to
Access2003, it is recommended to use Access2002/XP or Access2003. Access2000
has quite some bugs in its ADP, since it was released well before SQL
Server2000.

You may need to be aware that Access ADP is dying.