Emailing MDB files

[Guest]

What is the easiest way for me to email an MDB file to a very inexperienced
user? I zipped it and she was able to extract it, but something is stopping
macros from running. Should I rename it and send it. She can't even see
extensions so I'm not sure what to tell her to get the file renamed. Is
there any other way to send this out without beating my brains out? I'm
doing tech support on this application and I live 215 miles away.
Happy Halloween!

 

[Van T. Dinh]

If the user can extract the zipped file, it is likely that the problem is
not in the sent file. She may be using Access 2003 with Macro Security set
to High or Intermediate.

Ask the user to change it to Low and see if it works for her ...

 

[Granny Spitz via AccessMonster.com]

I zipped it and she was able to extract it, but something is stopping
macros from running.

If it's Windows XP, right click the file in windows explorer, open the
properties and press "Unblock." Set macro security to low in Access with
Tools | Macro | Security.

 

[Bill Mosca, MS Access MVP]

Dealing with clients out of your reach is always tough. When they are PC
challenged, it's near impossible. Do both of you hve Win XP and an internet
connection? If so, she can use Remote Assistance through the help menu. It
acts like remote desktop where you can see her screen.

You can read more about it in the Windows Help files.

Something else you might ask her (if this is Access 2003)...is her macro
security set to low? By default, it will be set to medium and block some of
your code functionality. You can find the setting under
Tools>Macro>Security.

 

[Guest]

I did have the macro security set to low; I can't figure out where "Unblock"
is in Properties. I looked all over the Advanced options and can't find it.

Thanks for the help.

 

[Rick Brandt]

I did have the macro security set to low; I can't figure out where
"Unblock" is in Properties. I looked all over the Advanced options
and can't find it.

The unblock option is shown in file properties only on WinXP systems that have
service pack 2 installed. Of you don't have SP2 installed then the button won't
be there. It also is only present when the system recognizes that the file
originated on a different system.

When it IS present the button will be directly under the [advanced] button. If
you don't see it then the file is not blocked.

 

[Guest]

Hi Bill.
After I posted the message, the client told me that she extracts the zip
file, opens the MDB, and is only able to run as far as the first macro. Then
she says it locks up without any error messages and she has to go to the Task
Manager to end the application. Doesn't happen to me. I have sent this app
to her before and no problems, but who knows.

Anything significant about it locking up? Anyhow, I am going to do the
remote thing and check out her security. She claims she's seeing LDB files
around on her PC, so I'm suspicious about that too.

Thanks for the help!

 

[Guest]

Thanks.

If the user can extract the zipped file, it is likely that the problem is
not in the sent file. She may be using Access 2003 with Macro Security set
to High or Intermediate.

Ask the user to change it to Low and see if it works for her ...

 

[Granny Spitz via AccessMonster.com]

I can't figure out where "Unblock"
is in Properties. I looked all over the Advanced options and can't find it.

My apologies. That information was intended for you to give to your user if
she has Windows XP SP2 (which she should have patched by now) because the
file came from *your* computer, not hers. It gets the added security block
when we download an MDB file from the internet or from email.

 

[aaron.kempf]

it's impossible to email MDB files; outlook blocks them.. exchange
blocks them.. hotmail blocks them

MDB is for ****ing retards anyways; use SQL Server and build a web
interface