My Add from Outlook link won't work when I split my Access database

mkelly2384
mkelly2384 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Not sure exactly, but it seems like the "AddFromOutlook" command does not "see" the split Back end.

Author

Commented:
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?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<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

Author

Commented:
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
Commented:
PAQ

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial