Solved

Viewing data from a linked table in Microsoft Access

Posted on 2004-04-14
4
178 Views
Last Modified: 2010-04-25
I have a case management system which can export data in CSV format. I have then created a linked table in Microsoft Access however, dreamweaver (coldfusion) does not "see" the linked table, only tables with a .mdb postfix. The linked table has a .ldb postfix which I assume is the problem.

I wish to avoid having to import the csv file into a table in Access every day - i.e. if the Access database can look to the CSV file for its data, and the website looks to the Access database, everthing can be done automatically.

Do you have any solution?
0
Comment
Question by:MinaMorris
[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 Comments
 
LVL 8

Accepted Solution

by:
alexhogan earned 63 total points
ID: 10823284
You can connect to the csv file directly using either a dsn or a connection string.

Creating another dsn using the Microsoft Text Driver would be the easiest.
Then you can create a connection in DW to access that file and bind the data anyway you want.

If you are using a connection string then you would simply replace the Microsoft Access Driver string with Microsoft Text Driver.
0
 
LVL 19

Assisted Solution

by:webwoman
webwoman earned 62 total points
ID: 10824212
The linked table in Access is set using a path in Access -- and that path is based on YOUR setup. Not only do you have to have BOTH databases/files (and the ldb is NOT the linked file), you have to replicate the path that was on YOUR computer.

alexhogan is right -- you need to have a second connection to that table/database, and use it directly.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

615 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