Solved

Can Access connect to a DB3 database

Posted on 2003-11-08
7
1,161 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
ID: 9708095
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
ID: 9708153
the databse is actually a dbase III version and they use Xdot as an interface
0
 
LVL 9

Expert Comment

by:svenkarlsen
ID: 9708164
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:dumontls
ID: 9708446
how do i that
0
 
LVL 9

Accepted Solution

by:
svenkarlsen earned 250 total points
ID: 9708498
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
ID: 9708579
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
ID: 9708590
Most glad to be of help!

Sven
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

831 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