ODBC Q:

[Mike]

Hi all,
I connect to SQL2k via ODBC (System DSN -> SQLServer) where all my 20+
tables are stored.
The client has the front-end of ACC with queries, forms, etc.
Every so often I modify the front-end and redistribute it to the users.
The annoying part is when I do that, I need to reconnect via ODBC all over
again. Not only that but then I need to rename the tables from dbo_tblxyz to
tblxyz.... a painful task.
I'm probably doing it all wrong, if so, can someone please direct me to an
easy solution to my tiring task?
TIA
Mike

 

[Abe]

Could save you the hassel of renaming the links. Make a
query called tblxyz that is select* FROM dbo.tblxyz this
way you won't have to rename everything every time you
update. If you do this pften you might want to write code
that relinks the tables for you.