very weird linked table problem

[dharkangel]

Hi,

I am trying to do a simple select statement on an asp page from an access database. The database has a linked table in it. When I imported the table, I renamed it from the long default name access gave it: 'Action Items: All Issues' to 'QPTActions'. When I run the asp page I get the following error:

The Microsoft Jet database engine cannot find the input table or query 'Action Items: All Issues'.

This doesn't make any sense since I renamed the table as soon as I imported it as a linked table. Below is my code:

Set metricsDB = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT [Issue ID] FROM QPTActions"
'Open the connection
metricsDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\

http://wwwroot\metrics\MergedActions.mdb"

set userSet = metricsDB.Execute(strSQL)