Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking

	98.1 % recommend us
	More live stats...

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

Training information:

Linking

Resolved · Low Priority · Version 2003

Reply Thu 22 Jan 2009, 08:03Delegate Eduardo said...

Eduardo has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Linking

why do i get a #num reference when i link access tables to Excel tables?

For upcoming training course dates see: Pricing & availability

Reply Sun 25 Jan 2009, 22:51Trainer Rajeev said...

RE: Linking

Dear Eduardo

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link. You'll note that it talks about Excel 97 but I am sure it also applies to 2003.

http://support.microsoft.com/kb/162539

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Tue 3 Feb 2009: Automatically marked as resolved.

Access articles

· Up The Professionalism Of Access Files Thanks To Digital Signatures
· Build International Databases With Microsoft Access
· How To Create Navigation Forms In Microsoft Access
· Be Top Of The Form With Access 2007
· Learn The Secrets About Splitting An Access Database

Please browse our web site to find out more about
microsoft-access-courses and other Microsoft training courses.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips