(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