Connect to external DB from MS Access

Completed Posted Jul 18, 2009 Paid on delivery
Completed Paid on delivery

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

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #2806475

About the project

11 proposals Remote project Active Jul 20, 2009

Awarded to:

johncl007

See private message.

$33.15 USD in 14 days
(9 Reviews)
4.4

11 freelancers are bidding on average $63 for this job

illuminesoft

See private message.

$72.25 USD in 14 days
(373 Reviews)
7.8
Prashantskin

See private message.

$42.5 USD in 14 days
(579 Reviews)
7.3
fastudiovw

See private message.

$63.75 USD in 14 days
(731 Reviews)
7.5
mrrcomputers

See private message.

$29.75 USD in 14 days
(40 Reviews)
5.5
VedAlek

See private message.

$12.75 USD in 14 days
(53 Reviews)
5.3
ioanaprof

See private message.

$17 USD in 14 days
(43 Reviews)
5.0
edjr

See private message.

$157.25 USD in 14 days
(4 Reviews)
3.7
alm43

See private message.

$25.5 USD in 14 days
(31 Reviews)
3.7
nishatech

See private message.

$170 USD in 14 days
(27 Reviews)
4.2
deartec

See private message.

$68 USD in 14 days
(1 Review)
1.4