Sending Linked Tables

[mlyles]

If I have tables that are linked to a database and I want to send those tables to a client how would I go about doing that. Since you can not view the forms unless the tables are linked properly the person I would be e-mailing the forms to cannot do anything. Here is where they are located (This is from the property Description of one of the tables.)
DATABASE=\\nawemugufs10vb\NAVSEA1$\CRNA\PED\PE30\QA42_QA43\QA43ML\IPMSD-CL-FY05-RAM-2004218.mdb;TABLE=tbl-Costs
I also have another problem the client can't accept mdb files so is there a way I can rename it to try and trick the database to something like md_
Thanks for your help.

 

[ghudson]

Zip up the back end .mdb and email him the zip file. No matter what you choose to do he will have to relink the tables since the front end will be looking for the tables in the location that they were origanally linked to.

 

[mlyles]

How would he go about relinking the tables and I figured to zip it would be a difficult code since I wanted to use a command button to mail the file.
Thank you for your help

 

[ghudson]

Search the forum for there are lots of posted examples on how to relink tables.

Also, search for the keywork "backup" and user "ghudson" for I have posted code on how to zip up a db if you have a licensed version of WinZip.

 

[rpadams]

Work arounds

Zip is best, but if that is impossible (no WinZip etc.), you can rename the files with an .abc extension, send them and then have recipient rename them back to .mdb. (.abc is not standard extension so it doesn't get blocked.)

If it is being blocked by Outlook or Outlook Express, you can change the default to allow the .mdb to pass.

Open Outlook and do the following:

Tools->Options->Mail Setup->Send/Receive->Edit->Download complete item including attachments

If you're using Outlook Express:

Tools->Options->Security and then Uncheck Do Not allow attachments.......