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

x
?
Solved

Viewing data from a linked table in Microsoft Access

Posted on 2004-04-14
4
Medium Priority
?
182 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
2 Comments
 
LVL 8

Accepted Solution

by:
alexhogan earned 252 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 248 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Loops Section Overview
Suggested Courses

876 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