Query not upsized

[tani1978]

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

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;

 

[gmmastros]

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

 

[tani1978]

I have just 6 tables in that database and all of them are successfully upsized.

 

[SQLDenis]

As far as I know (and I might be wrong) when you upsize Access it just does the tables not the queries

Just make stored procedures out of the queries

http://sqlservercode.blogspot.com/