Split-Database. Keeping the front-end 'private'.

[BardiyaS]

Hi everyone,

I want to create a split-database. I want the entries made on the front-end to update into a combined table in the back-end.

Back-end: One table with everyones entry

Front-end: Multiple forms that feed into the back-end.

When person A accesses his front-end form, he can only see his entries.

When person B accesses his front-end form, he can only see his entries.

When manager A wants to look at the back-end, he can see everyones entry in one table.

[June7]

FE links to table in BE. One form can serve for all. Multiple identical forms is a maintenance headache. Use filter criteria on forms to restrict records to only the user's based on login identification. You can make users login to project or grab their login from the network login with VBA.Environ("USERNAME"). Need a table of users and their IDs.