470,614 Members | 1,524 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

local data

Jer
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

Jul 23 '05 #1
1 1083
One 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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bill Hernandez | last post: by
reply views Thread by JohnLH | last post: by
1 post views Thread by Jami Bradley | last post: by
reply views Thread by Steffen | last post: by
10 posts views Thread by Jim Devenish | last post: by
4 posts views Thread by rdemyan via AccessMonster.com | last post: by
2 posts views Thread by Filip Konvicka | last post: by
5 posts views Thread by =?Utf-8?B?SmVycnkgQw==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.