Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access database

ResolvedVersion 2003

Felice has attended:
Excel Introduction course
Word Advanced course

ACCESS DATABASE

I have a database. In the database I have a lot of tables. I shall like to send one of the tables as an attachment in an email to somebody. I cannot seem to do it unless I copy the whole database and I do not want them to have the other tables. Can you please help me asap.

RE: ACCESS DATABASE

Hi Felice

Thank you for your question.

You will need to export the table into a new database that just contains that table.

Create the new database, and give it a meaningful name. You may also need to add in an empty table before Access will let you save the database. This done close the database.

Next, go to the database that contains the table, and select the table in the database window. (Do not open the table).

Click on File_Export and then select the new database you have created, and click Export. The table will then be copied over.

You can then email your new database as an attachment

Hope this helps

Regards

Stephen

Tue 16 Mar 2010: Automatically marked as resolved.

Access tip:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.