98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » ACCESS DATABASE
ACCESS DATABASE
Resolved · Urgent Priority · Version 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Run with the totalOften when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses. |