Solved

Viewing data from a linked table in Microsoft Access

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FINDNOCASE 2 557
2 containers on one webpage 4 249
unable to connect to host / dreamweaver cs3 11 157
Does Adobe/Dreamweaver Have Free Website Templates? 2 416
For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

777 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