Re: newbie question - local queries

Response as follows:

dbahooker@xxxxxxxxxxx wrote:
why would you need unique views for a particular workstation?
I have never used SQL Server, but have started reading and studying it.

I work in Access and a legacy program which permits queries to the
local workstation.

more appropriately; you can do this for a particular user.

but it's all hogwash.

why would susies' view be different than toms?

I understand a vew is a "RETUN" of a query. So two or more workstations
can execute the same sql or store procedure at same time then? As I
said, am inexperienced with SQL Server.

seriously; in great detail > do you know how to program?
I am inexperienced to SQL Server and attempting to educate myself. If
you are so experienced , then it would behoove you to have a better
attitude. It could possibly you business, but that's another matter.

local queries, local tables-- they're completely unnecessary and all
they do is make your application too complex.

Not interested in local tables. Need to educate myself on the
differences between Access and SQL Server.


-Aaron


larpup wrote:
I've been asked to re-write an access app with sql backend.. can anyone
enlighten me regarding "how to emulate Access local queries"? Since
sql server is all on the backend, how does one make unique views for a
workstation?

Any advice is appreciated.

Lar

.

Loading