My Add from Outlook link won't work when I split my Access database
I am using the Contacts Management template built in to MS Access 2007. When I split the database, some of the links don't work anymore, specifically the Add from Outlook link. It gives an error message saying that the command or action isn't available now. It continues that "you may be in a read-only database or an unconverted database from an eariler version of Contact Management Database. The type of object the action applies to isn't currently selected or isn't in the active view."
Any idea why the links stop working when the database is split?
Any idea why the links stop working when the database is split?
Jeffrey Coachman
Not sure exactly, but it seems like the "AddFromOutlook" command does not "see" the split Back end.
ASKER
Right--that is what I was thinking. But why would they not make it able to be split and still keep the features? Poor design, I would say. And is there a way to make it see the back end, if that is truly the problem?
Yes, I tried this as well, and got the same result.
1. I reccomend clicking the "Provide Feedbak button" and telling them your issue.
2. This is why many developers do not use templates.
Thet are great for pointing you in the right direction.
But if you don't know exactly how thay work, they can be hard to customize.
They may also contain functionality that you may not need.
3. This functionality is called by a Macro.
This macro has the Error Handler set to "Next" which means it will not actually show you the error.
It just seems to do nothing.
With the Error Handler turned off, here is what really happened:
JeffCoachman
untitled01.JPG
untitled02.JPG
1. I reccomend clicking the "Provide Feedbak button" and telling them your issue.
2. This is why many developers do not use templates.
Thet are great for pointing you in the right direction.
But if you don't know exactly how thay work, they can be hard to customize.
They may also contain functionality that you may not need.
3. This functionality is called by a Macro.
This macro has the Error Handler set to "Next" which means it will not actually show you the error.
It just seems to do nothing.
With the Error Handler turned off, here is what really happened:
JeffCoachman
untitled01.JPG
untitled02.JPG
ASKER
Yeah, I had deleted the line that hid the error message, too (which is how I was able to type out what the error was), but I was just wondering if there was a way to get this functionality back somehow. Surely there is a way to add your contacts from Outlook into a split database.
<Surely there is a way to add your contacts from Outlook into a split database.>
Perhaps, but it is not inherently obvious how to do this with this particular database...
Again, use that "provide Feedback" button.
;-)
Jeff
Perhaps, but it is not inherently obvious how to do this with this particular database...
Again, use that "provide Feedback" button.
;-)
Jeff
ASKER
I used the "provide feedback" button. Thanks.
I realize this is an old post but there is a work around that I found on the internet but was unable to find again to send link. The abbreviated instructions are:
1. In split database front end create a new table from the "Contacts" template.
2. Create an update query to add current record to new LOCALTABLE
3. Create a dialog form with the data connection pointed to LOCALTABLE that says "Would you like to add current record to outlook?" with a button that either uses vb or macro to runcommand saveasoutlookcontact and closes form.
4. Back on original form create a new button or change original saveasoutlookcontact button that runs a vb script that runs the following:
DoCmd.SetWarnings False
DoCmd.RunSQL "Delete * from NEWLOCALTABLE"
(Runs the created update query to add current record to NEWLOCALTABLE, or add sql)
DoCmd.SetWarnings True
DoCmd.OpenForm "OutlookContactDialog", acNormal, acDialog
1. In split database front end create a new table from the "Contacts" template.
2. Create an update query to add current record to new LOCALTABLE
3. Create a dialog form with the data connection pointed to LOCALTABLE that says "Would you like to add current record to outlook?" with a button that either uses vb or macro to runcommand saveasoutlookcontact and closes form.
4. Back on original form create a new button or change original saveasoutlookcontact button that runs a vb script that runs the following:
DoCmd.SetWarnings False
DoCmd.RunSQL "Delete * from NEWLOCALTABLE"
(Runs the created update query to add current record to NEWLOCALTABLE, or add sql)
DoCmd.SetWarnings True
DoCmd.OpenForm "OutlookContactDialog", acNormal, acDialog
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am not sure how this is an accepted solution since the original question revolves around how to get the add from Outlook function to work in a split database but the solution is to add a contact to Outlook