Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Relinking Dependant Qry after Del Table

Status
Not open for further replies.
nstouffer

nstouffer

Programmer
Jan 11, 2002
52
US
ok, (access 97)

I have a query that is dependant on a linked Excel Table.
I need to either:

a) Change the linked file address during run-time of this linked table. (if possible, which property?)

or

b) Delete the linked table and recreate it using transferspreadsheet command. This part I have working fine but my dependant query now doesn't recognize it because I deleted the original, even though I've replaced it using same name. (so, how do you re-link a dependant query?)

thanks much
 
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
846
Andrzejek
Andrzejek
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
738
Andrzejek
Andrzejek
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
470
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top