Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

connecting to a linked table in Access from Ultrad

Posted 30 May 2002 17:03:49
1
has voted
30 May 2002 17:03:49 Dl Smiff posted:
I'm trying to connect to a linked table (a table where the contents are imported from a .txt file and converted into an Access format) In ultradev, when I create a recordset it doesn't recognise a linked table. How can I get around this etc.??<font face='Verdana'></font id='Verdana'><font size=2></font id=size2>

Replies

Replied 30 May 2002 17:11:12
30 May 2002 17:11:12 David Behan replied:
I had this problem when I was playing around with linked Excel files. I had a macro in excel pull in all my log files and automatically format them in one big table. I then linked the table to Access.

UD couldn't see the linked table so what I did was create a query on the linked table with no filters. This brought all info into access that UD could read.

Try that... regards,

Dave

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

Reply to this topic