Upsizing to SQL


G

Guest

My queries converted to views and functions (mostly functions) when I ran the
upsize wizard. I now have to manually convert the functions to views.
Otherwise, all references to the queries in the VBA cannot find the queries
(views). Any methods to easily convert the functions to views using a wizard
or batch approach?
 
Ad

Advertisements

T

Tony Toews

MikeB said:
My queries converted to views and functions (mostly functions) when I ran the
upsize wizard. I now have to manually convert the functions to views.
Otherwise, all references to the queries in the VBA cannot find the queries
(views). Any methods to easily convert the functions to views using a wizard
or batch approach?
You should be able to link to the SQL Server queries just as you would
link to a table.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Ad

Advertisements

G

Guest

Thanks for the reply. I was sidetracked doing other things. I think I did
not adequately express the problem. I still need help. When I ran the
upsizing wizard on the Access database, an Access project containing the
forms and code modules was created. The tables and queries moved to the SQL
server, but remained visible and accessible from the Access database window.
Within the SQL server, the queries were converted to functions, not views.
When I run the Access application, Access complains it cannot locate the
queries. (Queries are record sources for the forms, or may be accessed via
VBA). Access is looking for view objects, not function objects when it looks
for the queries. I had to use the SQL Query Analyzer to convert the
functions into views within the SQL server. Took quite some time to complete
this task. Then the Access project could see the queries. Once I complete
testing the conversion, I will repeat the process on the latest version of
our database. I need the Access queries to convert to views during the
conversion process. Appreciate any insight you may have.
 

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

Upsizing to SQL 1
upsizing to sql 5
Upsizing to SQL 2000 5
upsize to sql server 6
Help with SQL Upsize 0
Upsize to SQL - Query Criteria 4
Opinions on SQL Server upsize 13
SQL upsize 2 databases 2

Top