Custom built small business software, bespoke database design, low cost systems.
Click For Main Menu
Click For Pricing Details
Clik to Know Why Choose Us?
Click For Software Details
Click For Contact Details


Connect to a MS Access Database via ODBC
(Windows XP)

Select 'Control Panel' from the 'Start' menu.

odbc control panel

Click to See Recordset GroupClick For Online Enquiry FormHow to manually set up a ODBC linkClick to Download Free Contacts DatabaseClick for Recordset Privacy Policy

Select 'Performance & Maintenance'

odbc admin
Select 'Administrative Tools'


odbc datasourcs
Select 'Data Sources (ODBC)

 

odbc dsn
Make sure the 'User DSN' tab is selected the click 'Add...'

 

odbc create
1.You will be presented with a list of drivers. Select 'Microsoft Access Driver (*.mdb) then

2. Click 'Finish'

 

odbc datasource
1. Enter the 'Data Source Name' i have sent in my E Mail

2. Click 'Select' to locate the database

 

odbc select database
1. Select the Drive (eg E:) where the database is stored (if not sure what drive a USB storage device is on then open 'My Computer' and check).

2. Once the drive is selected you will see a list of files and folders within that drive will appeae in window 2, browse to find the .mdb file then click to select.

3. This file will now appear in window 3 click to select the file will then appear in the 'Database Name' then click OK

 


Your database should now be listed in the 'User Data Sources' window. Click OK to finish

 

Repeat the process for each PC that needs to connect/share the database.



E: info@recordset.co.uk Copyright Recordset Solutions Ltd 2008. All Rights Reserverd