Solved

Can Access connect to a DB3 database

Posted on 2003-11-08
7
1,124 Views
Last Modified: 2009-12-16
My company uses a DB3 (clipper) for its inventory. How can I use MS access to link to this database either directly or by creating an ODBC connection.

0
Comment
Question by:dumontls
  • 4
  • 3
7 Comments
 
LVL 9

Expert Comment

by:svenkarlsen
Comment Utility
Hi dumontls,
You will need an ODBC connector from Clipper, -from then on the principles are standard ODBC access.

Kind regards,
Sven
0
 

Author Comment

by:dumontls
Comment Utility
the databse is actually a dbase III version and they use Xdot as an interface
0
 
LVL 9

Expert Comment

by:svenkarlsen
Comment Utility
Hi Dumont,
then yo can connect directly to the inventory database, - just link the dbase datasets directly into your Access database and you can use them like any other Access table.

Regards,
Sven
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:dumontls
Comment Utility
how do i that
0
 
LVL 9

Accepted Solution

by:
svenkarlsen earned 250 total points
Comment Utility
dumontls:

From Access menu: Files > Get external data > Link tables

 then you select the DbIII file you need and follow the instructions.

You may need to go through the process a couple of times to get comfortable with the options, - don't worry if you make a link and regret it: you can just delete the link in the Access Database window (it will not influence or harm the DbIII-file in any way).

Regards,
Sven
0
 

Author Comment

by:dumontls
Comment Utility
Thanks, what i always used to do in the past was to import the whole file and then try to manipulate the data.

Now I might be able what I have already reduced from a days work to an hours work to even less

Thanks Sven muvh appreciated

Louis
0
 
LVL 9

Expert Comment

by:svenkarlsen
Comment Utility
Most glad to be of help!

Sven
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now