Propig
09-18-2001, 12:55 PM
Okay,
Question #3!
I am in the process of learning SQL Server and am not 100% sure of what I am talking about, but I will try asking this anyway.
I have an Access97 front end with SQL Server 2000 backend.
Here is a breakdown of what I am attempting to do.
My database is broken into 9 regions. Each region can only be viewed by one person at a time. Currently the database uses an Access query to segregate the data. I know that you can create a view in SQL Server to segregate the data, which I have accomplished(yeah!). My question is were do I go from here? I will, when I am done, have nine different views. Is the best way to connect the view to forms and reports by linking all nine views and then the datasource will change based on who is logged in? Or is there away to link the view as it is needed. Meaning, if I log into Region 2, the only view linked at the time would be for Region2 SPAMand then the view would become the datasource for forms and reports? If this second question is possible, can I link different views with the same name?
I am not sure if you know what I am asking. I am really only trying to determine the best, most effecient way of doing things.
:-/
Let me know if you have any suggestions.
Question #3!
I am in the process of learning SQL Server and am not 100% sure of what I am talking about, but I will try asking this anyway.
I have an Access97 front end with SQL Server 2000 backend.
Here is a breakdown of what I am attempting to do.
My database is broken into 9 regions. Each region can only be viewed by one person at a time. Currently the database uses an Access query to segregate the data. I know that you can create a view in SQL Server to segregate the data, which I have accomplished(yeah!). My question is were do I go from here? I will, when I am done, have nine different views. Is the best way to connect the view to forms and reports by linking all nine views and then the datasource will change based on who is logged in? Or is there away to link the view as it is needed. Meaning, if I log into Region 2, the only view linked at the time would be for Region2 SPAMand then the view would become the datasource for forms and reports? If this second question is possible, can I link different views with the same name?
I am not sure if you know what I am asking. I am really only trying to determine the best, most effecient way of doing things.
:-/
Let me know if you have any suggestions.