• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

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

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??

1 Solution
If you're using linked tables, have you refreshed all the table links in your Access database? (Tools -> Database Utilities -> Linked Table Manager)
PhoenixRemanAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now