wuwu... I hate doing this... - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

wuwu... I hate doing this...

wuwu... I hate doing this...# Database - 数据库

b*u2002-03-22 08:03

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*d2002-03-22 08:03

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