ADE access to SQL View issue

  • Thread starter Thread starter Lost
  • Start date Start date
L

Lost

We have created an .ade file to process and display
information from our accounting system which has a SQL 7.0
database. We have created a user "readonly" to log into
the database. Everyone accesses the database through a
private IP number. The .ade file runs perfectly on our
local LAN. Our problem is that folks operating in our
remote office get an error that a certain 'view' does not
exist. If we copy the same .ade file to our local office -
it works. If a remote office user changes his/her
Connection/Login information to the SA account - it
works. This would lead you to believe that a 'rights'
issue is presenting itself but the same .ade file works
here with the 'readonly' user. What are we missing?
Thanx for any assistance...
 
Check all your forms and reports to make sure that the
data record source has dbo. in front of it. If you have
drop down boxes with different record sources make sure
they also have dbo. in front of the source. If you have a
select statement in the row source property make sure in
the from clause the dbo. is present. For example, instead
of data record source = viewname change it to dbo.viewname

We had the same problem and this resolved all of our
issues.
 
Back
Top