Re: Questions about tables upsized db from access to sql

The obvious question no one has asked is - did you make a link in your Access
database to the upsized table? You said you could see it in Query Analyzer
and Enterprise Manager, but can you see it in your Access database?

Also, are you trying to use an MDB or an ADP Access project?

On Thu, 27 Oct 2005 20:28:37 GMT, "Mike" <noway@xxxxxxxxxxxx> wrote:

>I have an Access DB that I upsized to a SQL server DB. The tables that I
>upsized I can't seem to modify. I wanted to insert some data into the table
>and I am getting the following error:
>
>---Begin Error---
>Server: Msg 107, Level 16, State 3, Line 1
>The column prefix 'SVC_Details' does not match with a table name or alias
>name used in the query.
>---End Error---
>
>The table called SVC_Details is the table that was upsized from Access. The
>table is listed in both the query analyzer and sql enterprise manager. I do
>not know why I am getting this error.
>
>I am using the following code to insert the data:
>
>---Begin Code---
>insert into SVC_Details(svccode, svcdesc, price)
>Select svccode, svcdesc, svcprice from svc_details_chrg_mastr
>Where svc_details_chrg_mastr.svccode <> SVC_Details.svccode
>---End Code---
>
>I am running MS-SQL 2000 standard on a Windows 2003 Standard server.
>
>Thanks in advance for all the help!!
>

.

Relevant Pages

  • Re: SQL2005 sys tables
    ... Maybe you don't have the SQL Editor toolbar open. ... You can also change the database context by using the USE statement in the ... SQL Server Documentation Team ... I mean in sql2000 query analyzer I can do the select statement against ...
    (microsoft.public.sqlserver.security)
  • Re: limits of SQL Server???
    ... I suspect that the problem has more to do with your method of data access/retrieval/display than with SQL Server. ... Running this statement within Query Analyzer displays the 2155 rows in 0 seconds: ... > Does the data come back quickly from the database? ... > "mickey" wrote in message ...
    (microsoft.public.sqlserver.setup)
  • Re: sqlserver and access
    ... solid on exactly what SQL Server is. ... Query Analyzer is simply a tool that allows an administrator/developer to ... Your "central main database system" is actually a SQL Server. ... or would I need the help of a network administrator? ...
    (microsoft.public.sqlserver.programming)
  • Re: Correct Deleted Default Database??
    ... >>It is not possible to restore dropped database because ... >>connected over trusted connection users and SQL ... Using Query Analyzer or any other tool try to login ... but SQL Server complains that sa is ...
    (microsoft.public.sqlserver.security)
  • Questions about tables upsized db from access to sql
    ... I have an Access DB that I upsized to a SQL server DB. ... table is listed in both the query analyzer and sql enterprise manager. ... Select svccode, svcdesc, svcprice from svc_details_chrg_mastr ... I am running MS-SQL 2000 standard on a Windows 2003 Standard server. ...
    (comp.databases.ms-access)
Loading