The_Vincester
Registered User.
- Local time
- Yesterday, 22:26
- Joined
- Jun 6, 2006
- Messages
- 71
I'm trying to build a small app for some of my employees to quickly archive (and still be able to access) their email. I've come up with a couple was to do things, but I want something more "efficient."
One way was to link a folder called "Archive" to the database, then have whatever they want to archive moved to that folder, then they could push a button to archive the data (using an append query), then they would be free to delete out of the archive folder. This would work except for the fact that each person would have their own separate app on their computer and how could I link dynamically to that specified folder? One thing to know is that I'll be distributing a runtime version for them to use, so everything must be pretty much "predetermined."
Another was was to distribute two files, one would be "Archive.mdb" You can natively export a folder from Outlook as an .mdb file, which they would do, and simply replace the Archive.mdb file with their own exported file. The structure is already set up, so the "frontend" would work. Again, they would archive using an append query. Same problem though is the linking. If they put the file in "My Documents" or their Desktop, how would I dynamically allow them to link.
The option I would like to go with is my first option, but how to have Access automatically or dynamically link their outlook.
It seems like it would be easy to when you open the Access app, it would link to the specified folder, as everyone's Outlook is set up exactly the same.
One way was to link a folder called "Archive" to the database, then have whatever they want to archive moved to that folder, then they could push a button to archive the data (using an append query), then they would be free to delete out of the archive folder. This would work except for the fact that each person would have their own separate app on their computer and how could I link dynamically to that specified folder? One thing to know is that I'll be distributing a runtime version for them to use, so everything must be pretty much "predetermined."
Another was was to distribute two files, one would be "Archive.mdb" You can natively export a folder from Outlook as an .mdb file, which they would do, and simply replace the Archive.mdb file with their own exported file. The structure is already set up, so the "frontend" would work. Again, they would archive using an append query. Same problem though is the linking. If they put the file in "My Documents" or their Desktop, how would I dynamically allow them to link.
The option I would like to go with is my first option, but how to have Access automatically or dynamically link their outlook.
It seems like it would be easy to when you open the Access app, it would link to the specified folder, as everyone's Outlook is set up exactly the same.
