Lost Queries during Upsizing

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

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server Queries 5
upsizing to sql 2005 26
Need help with Access query following an "Upsizing" 1
Upsizing Problem with number of records 2
Upsizing wizard failures 3
Access parameterised queries upsizing to sql server 2
Finding out the order in which access performs queries 1
dynamic queries 4

Top