Connect to external DB from MS Access

已完成 已发布的 Jul 18, 2009 货到付款
已完成 货到付款

I need a code module written in MS Access that will show a "file open" dialog box and allow the user to select a directory or file. An optional parameter will specify wether to return the specific file or ALL the files in that directory of that type. Access will than attempt to establish links to all of the tables in the directory that are of this type, or the single file selected. This needs to work specifically for Paradox tables at the moment, but should be generic enough to attach to DBF files as well.

The primary purpose of this is that we have a directory structure with multiple projects, each containing 30-40 identical Paradox tables, all with the same structure -- I want to be able to develop some reporting and than easily/quickly switch the project I am getting the data from -- this seems to be the best approach. Also, there will be other computers this needs moved to with same structure.

I think this is the best way to accomplish this but am open to better suggestions as well

工程 微软Access MySQL PHP 软件构架 软件测试

项目ID: #2806475

关于项目

11个方案 远程项目 活跃的Jul 20, 2009

授予:

johncl007

See private message.

$33.15 USD 在14天内
(9条评论)
4.4

有11名威客正在参与此工作的竞标,均价$63/小时

illuminesoft

See private message.

$72.25 USD 在14天内
(373条评论)
7.8
Prashantskin

See private message.

$42.5 USD 在14天内
(579条评论)
7.3
fastudiovw

See private message.

$63.75 USD 在14天内
(731条评论)
7.5
mrrcomputers

See private message.

$29.75 USD 在14天内
(40条评论)
5.5
VedAlek

See private message.

$12.75 USD 在14天内
(53条评论)
5.3
ioanaprof

See private message.

$17 USD 在14天内
(43条评论)
5.0
edjr

See private message.

$157.25 USD 在14天内
(4条评论)
3.7
alm43

See private message.

$25.5 USD 在14天内
(31条评论)
3.7
nishatech

See private message.

$170 USD 在14天内
(27条评论)
4.2
deartec

See private message.

$68 USD 在14天内
(1条评论)
1.4