access class microsoft training

access class microsoft training - Access

Resolved · Low Priority · Version Standard

Access

Alan has attended:
Access Introduction course
Access Intermediate course

by - delegate Alan [1 post] (2007 Dec 19 Wed, 16:38) Reply

I Have a table in Access That is linked to an excel file. Can the table in access be made a normal table ie not linked to the excel file?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access

by - trainer Pete platinum contributer [803 posts] (2007 Dec 20 Thu, 09:26) Edited on 2007 Dec 20 Thu, 09:27 Reply

Hi Alan, Thanks for the post, In answer to your question, I would copy the linked file in the Database window and then paste it back in again with data and structure kept. You can then give it a new name, however any reports, forms and queries from that table will have to be adjusted to look at the new name.
If you delete the linked table and name the new copy as the same name as the linked table had your linked objects should still retain their source data link.
I hope that helps best regards and have a happy holiday period Pete