b******u
发帖数: 676 | 1 SQL db, Access front end, hosted on different servers. I can't figure out how
to set up DNSless ODBC connection between the two. Tons of sample codes, but I
just can't have it work...sigh...
So, I am doing this:
My end user uses short cut to access the Access reports. On every computer, I
set up same system DSN. Same name, and all pointing to the SQL db. Then, use
Access Link table.
When I modify the SQL table, seems that I can do it on any PC. just refresh
the linked table in Access Link Table | k*******d
发帖数: 237 | 2 I am not a Da Xia, but maybe a old Xia :=)
I ever worked on a software package like that. So it should be no problem.
And, you can write a MACRO or some code to let Access automaticlly update
links when starting
how
I
I
【在 b******u 的大作中提到】
: SQL db, Access front end, hosted on different servers. I can't figure out how
: to set up DNSless ODBC connection between the two. Tons of sample codes, but I
: just can't have it work...sigh...
: So, I am doing this:
: My end user uses short cut to access the Access reports. On every computer, I
: set up same system DSN. Same name, and all pointing to the SQL db. Then, use
: Access Link table.
: When I modify the SQL table, seems that I can do it on any PC. just refresh
: the linked table in Access Link Table
|
|
