Unanswered: Collect Data via Email in a split database
I am pretty new with designing a database, kindly help me with an issue I'm facing..
Have a database that collects data from a set of users via Access's feature "Collect data through E-mail messages". When I'm asked to share the table name containing recipients email ids. The "Associated tables" tab in the wizard is greyed out. I can't figure out a way to solve this and I don't wish to manually add email addresses in my Outlook program.
I have split the database with the Front End placed on the server and Back End in the same file on the server (this was for faster access although I'm still facing significant lags).
Employee Work Tracker Database, employee to update status via replying the auto mail sent by Access.
Version : Access 2007
OS: Windows 7 SP-2
Would be grateful for any kind of support provided.