Friday, February 24, 2012

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!
JerryOne way is simply to have a user table in MSDE - when your application
connects, you query the table based on the current user's login name
(see SYSTEM_USER in Books Online), then retrieve what you need from the
table.

Simon

No comments:

Post a Comment