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