Access 2002 ADP Connection to SQL Server 2000-Stored Proc Query Names

[HardingR2000]

I have an Access 2002 ADP which connects to a SQL Server 2000 database. The connections is established by going to FILE, CONNECTION, and entering the appropriate information in the Data Link Properties window.

I wanted to create a new ADP and establish the connection to the SQL Server database. I went through the FILE, CONNECTION and Data Link Properties specifications, but when the connection was established and the SQL Server stored procedures were presented in the Queries container they had double quotes around the query (stored procedure) name.

For example my original ADP had a query called Interconnect_Frm_sp (dbo).

The new ADP called that same query "Interconnect_Frm_sp" (dbo).

The double quotes are visual clutter and I would like to get rid of them if possible.

Did I do something wrong when establishing the connection? Will I have to use the double quotes when referencing the queries (stored procedures) in VBA code?

 

[HardingR2000]

I made a stupid mistake. After creating the blank ADP and making the connection (which automatically brought in the stored procedures as queries), I did an import from the production ADP. Out of habit I included all queries (ie. stored procedures) that were in the production ADP. This brought in the stored procedures a second time and they were written back to the SQL Server database with a slightly different name and with the double quotes around them.

Randy