Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access class microsoft training - Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access class microsoft training - Access

Resolved · Low Priority · Version Standard

Reply Wed 19 Dec 2007, 16:38Delegate Alan said...

Alan has attended:
Access Introduction course
Access Intermediate course

Access

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 20 Dec 2007, 09:26 Edited on Thu 20 Dec 2007, 09:27Trainer Pete said...

RE: Access

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

Access articles

· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· User-Proofing Your Access Database: Part 1
· How To Sort And Filter A Table In Access 2010
· Find Microsoft Access Templates For Any Task
· Build International Databases With Microsoft Access

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips