Upsizing to SQL

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

 

[Tony Toews]

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

 

[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.