Connect Access Forms to SQL Server DB
I am able to link my Access DB to one of the tables in a
SQl Server DB that resides on the network fine (without
any code involved). On one of my forms, I have a drop-down
list which displays the contents of this linked SQL Server
table. However, when I close the Access DB, and then open
it again, the drop-down list on my form won't display the
data from the linked SQL Server table because it says the
table can't be found (although I can see the linked
table).
Is there any way, through code, that I can set the
connection to this linked table everytime the Access form
loads up?
Thanks,
Dar