Connecting to a Linked Table in Access

[cmb290t]

I am using Dreamweaver MX 2004. I am trying to connect, via Dreamweaver, to a
linked file in Access. The linked file is connected to a text file that will
be updated daily. Dreamweaver is looking for a table to connect to but it is
not recognizing the linked file within the Access database as a table. I used
a OLE DB connection string to try to connect in DW. The problem arises when I
try to create a record set and choose the connection. The error reads "Unable
to retrieve tables from this connection, click on the 'Define...' button to
test this connection." An OBDC connection will not work with this type of data
source. I can connect to the data source by hard coding, but I would like to
complete my project using DW, instead of hard coding everything.

Any help is greatly appreciated! Thanks.

[Paul Whitham TMM]

Bad news for you mate.

Linked tables are achieved via something within the Access program that is
not available when the database is accessed via SQL on a webserver. You are
going to have to find a different method to access the information

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"cmb290t" <webforumsuser@macromedia.com> wrote in message
news:d1cf75$7mk$1@forums.macromedia.com...

> I am using Dreamweaver MX 2004. I am trying to connect, via Dreamweaver,

to a

> linked file in Access. The linked file is connected to a text file that

will

> be updated daily. Dreamweaver is looking for a table to connect to but it

is

> not recognizing the linked file within the Access database as a table. I

used

> a OLE DB connection string to try to connect in DW. The problem arises

when I

> try to create a record set and choose the connection. The error reads

"Unable

> to retrieve tables from this connection, click on the 'Define...' button

to

> test this connection." An OBDC connection will not work with this type of

data

> source. I can connect to the data source by hard coding, but I would like

to

> complete my project using DW, instead of hard coding everything.
>
> Any help is greatly appreciated! Thanks.
>