sql server msde: I am implementing an MSDE database and I would like to keep some data (like
user preferences) in the Access project so that I can filter data for each
user based on their selected preferences. In Access I just kept user
preferences in the application database on each workstation and used queries
to get only the data I wanted from the linked tables.
How can I do this in MSDE/Access projects?

thanks!

hi Jerry,
[quoted text, click to view]

Access is an application and a kind of integrated development environment,
where MSDE is just (<g>) a database management system that only stores
"data" (as long as other database objects to manipulate it...)
if you need a feature like that, you can perhaps save that kind of
information in a general user table related with the user and filter
depending on SYSTEM_USER
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts
_sysusr_3c8i.asp ) , or you can write the same stored procedure but with
different owners, where each user will execute his/her "private" procedure,
but this can lead to management nightmares..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply