microsoft access training

microsoft access training - ODBC

Resolved · Low Priority · Version Standard

ODBC

Maria has attended:
Excel Introduction course
Access Intermediate course

by - delegate Maria [4 posts] (2008 Jan 11 Fri, 16:09) Reply

How can I link access databace using ODBC's

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	5	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: ODBC

by - trainer David gold contributer [428 posts] (2008 Jan 29 Tue, 10:39) Reply

Hi Maria,

It is quite simple to create a ODBC connection to a Microsoft Access database. Please see the following W3C page for full instructions:
ODBC Access connection.

Hope you find this useful
David

· Access VBA Training Adds Power to your Databases
· Learn about Subqueries in Access Courses
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps

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

Rate this page: