Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2004-09-13
4
Medium Priority
?
341 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
2 Comments
 
LVL 12

Accepted Solution

by:
pique_tech earned 500 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

577 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