Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
The UK's most regular 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
Resolved · Low Priority · Version Standard
Reply Fri 7 Mar 2008, 16:46Delegate Sylvia said...
Sylvia has attended:
Access Intermediate course
Access
I am using one database at the moment which I will need to split - what is the best way to do this - save as the database and delete the columns I don't need from each?
For upcoming training course dates see: Pricing & availability
RE: Access
Hi Sylvia, Thank you for your post, welcome to the forum, if you are going to split a single database into two separate access databases the way you have suggested is perfectly acceptable. Alternatively you could create a query which has the fields in it that you wish to keep and then create a table from that query (Make Table Query), open a new database and import the table to your new database, that sounds a little long winded I know but would be probably safer in the long run. I hope that helps, best regards Pete.
|