Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Can Access connect to a DB3 database

Posted on 2003-11-08
7
Medium Priority
?
1,374 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

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

Accepted Solution

by:
svenkarlsen earned 750 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

773 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