Solved

Can Access connect to a DB3 database

Posted on 2003-11-08
7
1,253 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

628 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