Macro doesn't work when using a linked table

  • Thread starter Thread starter jmanlp
  • Start date Start date
J

jmanlp

I split my access 2007 contacts database so that I could create one
front-end environment that would later link to all of my databases.
The problem I am experiencing is with a macro to save outlook
contacts. The macro works great when I have the table in the same
database file, but once split the macro simply doesn't work. All of
the other data still appears on my form and in my queries. I even
imported the table again just to check and it work once it was
"physically" in the same .accdb file, and once removed and linked, it
didn't work. The command I am using in my macro is
"SaveAsOutlookContact". Do I need some additional parameters or
something? I've been struggling with this for hours now and searching
has turned up very little. Thanks.
 
Coincidentally I can only use this command with the template contacts
table that is supplied with the software. If I setup a table with the
same properties and field names, I cannot get to the command to work.
I am starting to wonder if the supplied contacts template table has
some embedded code to work with this command that I cannot see. If it
was possible to track down this information it would be possible to
get the linked table to work. Anyhow, any thoughts on the matter would
be greatly appreciated. Thanks.
 
jmanlp said:
I split my access 2007 contacts database so that I could create one
front-end environment that would later link to all of my databases.
The problem I am experiencing is with a macro to save outlook
contacts. The macro works great when I have the table in the same
database file, but once split the macro simply doesn't work. All of
the other data still appears on my form and in my queries. I even
imported the table again just to check and it work once it was
"physically" in the same .accdb file, and once removed and linked, it
didn't work. The command I am using in my macro is
"SaveAsOutlookContact". Do I need some additional parameters or
something? I've been struggling with this for hours now and searching
has turned up very little. Thanks.
Click to expand...
 
I have exactly the same problem and concluded that it works with embedded
tables, but not linked. It would be very helpful to have a comment from
Microsoft.
 
Back
Top