local data

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!
Jerry
hi Jerry,
JerryWendell wrote:
> 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?
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/de...-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.shtmhttp://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