Solved

Viewing data from a linked table in Microsoft Access

Posted on 2004-04-14
4
175 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
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dreamweaver - Spell check extension 4 491
thumbnails in content 11 296
Regular Expressions find/replace needed 10 145
Adobe Muse CC instead of Adobe Dreamweaver CC? 8 77
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

828 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