multi-user question

[mseifman]

I'm designing a multi-user database, which is something I've not done before. I already have coding planned for filtering records and reports by userID, and plans to institute a security table containing userID's and departments (restricting some of the users to only view records in their department).

I've never done a multi-user database before, and am looking for suggestions and tricks that might make deployment easier. If you have any suggestions or tricks for me, please post them. I would appreciate it.