Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP.TLB Error

Status
Not open for further replies.

Fattire

Technical User
Nov 30, 2006
127
US
My database works fine on my computer. When I copied it over to a co-workers computer it gives me this ASP.TLB error. Says that his copy of the database is missing a reference to the file 'ASP.TLB' version 2.0

- His computer as well as mine have the same references installed. I used no special reference libraries when making this .mdb
- Neither of us have Visual Studio installed on our computers.
- There are no web pages connected to this .mdb nor either of our computers.

There are several connections in my .mdb to a single Oracle database in the building as well as connections to tables within the .mdb file - such as:

Code:
Dim cn2 As New ADODB.Connection
Set cn2 = CurrentProject.Connection

...., but that's it. Works fine on my computer, but not his.

The funny thing is that it errors out when trying to run some code that deletes all records from one of the tables before populating it again with data from Oracle, such as:

Code:
Dim cn1 As ADODB.Connection
Dim cn2 As New ADODB.Connection
Set cn2 = CurrentProject.Connection

purge2 = "delete * from [tblAll]"
cn2.Execute purge2
cn2.Close

Any one get this before?
 
For what its worth, ASP.tbl is the Microsoft Active Server Pages Object Library, which is not something I would have a reference to in a normal Access database. Have you checked your colleague's References to see if any are marked missing? Have you tried a repair, or an import into a fresh database?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top