Lost Queries during Upsizing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an mdb in Access XP. I have tried to upsize it to SQL 2005. All of the
queries that have calculated fields failed to be upsized. Tried copying the
SQL view in Access into SQL. The alias fields failed. What can I do. I have a
lot of queries that I don't want to have to rewrite?
 
Hi,


It is not all the queries that can be upsized. Those involving VBA functions
are not. Also, the Alias do not behave in the same way in Jet than in MS SQL
Server. You cannot use, in MS SQL Server:

SELECT a+ b AS x, c+x AS d FROM mytable


neither can you use = as comparison, since =, in MS SQL Server, is an alias,
not a comparison, in the SELECT clause.

There are a lot of other differences too, so without seeing each of your
queries, I can hardly be specific.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top