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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query not upsized

Status
Not open for further replies.

tani1978

MIS
Sep 29, 2005
49
DE
Hello Friends
I upsized a access database to Sql server but one of my query did not upsized. I dont know where is the problem need your help.This is the oroginal query in MS Access
Code:
SELECT Messung_Ottensen.Projekt, Messung_Ottensen.ID, Messung_Ottensen.Dat, Grenzwerte.*, Methode.*, Verdünnung.*, Bemerkung.*, Messung_Ottensen.Achtung16, ttensen.Dat2, Messung_Ottensen.Dat3,  Messung_Ottensen.Bemerkung
FROM (((Messung_Ottensen INNER JOIN Grenzwerte ON Messung_Ottensen.Projekt = Grenzwerte.Projekt) INNER JOIN Methode ON Messung_Ottensen.Projekt = Methode.Projekt) INNER JOIN Verdünnung ON Messung_Ottensen.Projekt = Verdünnung.Projekt) INNER JOIN Bemerkung ON Messung_Ottensen.Projekt = Bemerkung.Projekt
ORDER BY Messung_Ottensen.Projekt, Messung_Ottensen.Dat DESC;
 
I don't notice anything wrong with your query. Is it possible that one of the tables that this query uses did not 'upsize'. If the table does not exist, then you won't be able to create the query.

You can see what tables exist in the database by running the following query.

Select * from Information_Schema.Tables Order By Table_Name

There are likely to be a couple extra tables in the list. They are system tables and can safely be ignored.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
I have just 6 tables in that database and all of them are successfully upsized.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top