Solved

Run-time error '-2147217900 (80040e14)"

Posted on 2004-09-13
4
331 Views
Last Modified: 2012-05-05
Hi all need some help on troubleshooting this error.

This is the lowdown:

I restored a SQL 7 database to a sql 2k server.  I received a successful restore and all looks good.  But when I attempted to load our MS access program I get this run-time error.

 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column prefix 'tblTimeLine.': No table name specified

Does anyone have a clue on how to solve this??

Thanks
0
Comment
Question by:PhoenixReman
4 Comments
 
LVL 12

Accepted Solution

by:
pique_tech earned 125 total points
ID: 12049639
If you're using linked tables, have you refreshed all the table links in your Access database? (Tools -> Database Utilities -> Linked Table Manager)
0
 

Author Comment

by:PhoenixReman
ID: 12412957
Sorry.  Should have closed this out.  The problem had nothing to do with linked tables.  We had a syntax error in a stored procedure that was apparently acceptable to SQL 7 but not to 2000.  We referenced dbo..tblTimeLine (notice the double dot) instead of dbo.tblTimline. SQL 7 ran this correctly but 2000 burped on it.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question