Emailing Database

[Laura737]

Hi
I need to email a copy of both the back and front ends of my Access 2007
database to another person so that they can use it and put their own data in
it. However, when I've zipped both front ends and back ends and put in an
email, when they try to open it, it is still looking for the back end that's
file path is on my computer so it obviously won't work. I have tried to use
the link table manager but it still doesn't seem to work. Does anyone have
any ideas of what I can do at this end to make the transition easy for the
person I designed the database for?

Thanks

Laura

 

[Arvin Meyer [MVP]]

The Link Table Manager should work fine. The only other alternative is to
delete and relink the attached tables.

 

[Jerry Whittle]

Find out the file path of the BE on the other person's machine. Create the
same path on your computer; put a copy of the BE there; then link the FE
before emailing.

Now that's simple if both of you are putting things on a C drive. If it's
going to be on a network drive, like a Q or P drive, things get a little more
difficult. You can create a virtual drive on your computer to match a network
drive by using the old DOS subst command.

Subst--Example

The following command creates a virtual drive Q for the path
C:\USER\BETTY\FORMS:

subst q: C:\user\betty\forms
Now, instead of typing the full path, you can reach this directory by typing
the letter of the virtual drive, followed by a colon, as in the following
example:
q:

If you are using long file names for the folders, use quotes.
subst q: "C:\My Databases"

To remove the virtual drive:
subst q: /d