Allowing receiving of Access MDB file

[Guest]

I am creating an application that the main operator will press a button in a
Access program, and it will query certain info., package it in new table,
e-mail it to a user, he will update the data, send it back, and then the data
will be updated into the main table. Although I've haven't worked out all
the details yet, a big stumbling block is how Outlook 2003 will receive the
data, as it currently doesn't, unless the mdb file is renamed to *.doc or
something. (Outlook 2003 will not receive access files - unless someone knows
away to disable that limitation). But if I do that, it wouldn't be easy for
the user to open Access automatically. Any one send and receive data back
and have to do anything like this? Your insight would be a blessing.

Thanks in advance.......

 

[Guest]

Hi Bill,

To disable the limitation of Access files being blocked, follow this
article, I have used it many times :-

Recent Outlook Versions Outlook 2003, Outlook 2002 and Outlook 2000 SP3 (but
not Outlook 98 or earlier Outlook 2000 versions) allow the user to use a
registry key to open up access to blocked attachments. (Always make a backup
before editing the registry.) To use this key:
Run Regedit, and go to this key:

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Security (change
10.0 to 9.0 for Outlook 2000 SP3 or to 11.0 for Outlook 2003)

Under that key, add a new string value named Level1Remove.

For the value for Level1Remove, enter a semicolon-delimited list of file
extensions. For example, entering this:

..mdb;.url

would unblock Microsoft Access files and Internet shortcuts. Note that the
use of a leading dot was not previously required, however, new security
patches may require it. If you are using "mdb;url" format and extensions are
blocked, add a dot to each extension. Note also that there is not a space
between extensions.

Paul