DSN Connection - from Access to Access97.

[kramerica]

I have a simple problem.. and I am a little short on time.

I have a Windows 2000 Database on the local C: drive, I would like to be able to click a button and establish a DSN Connection to another Access database that is on a Web server.

NOTE THE OTHER DATABASE is across the WAN.

Once the connection is made I would like to SQL Update 1 field and then drop the connection.

I am having trouble establishing the DSN connection to the other Access 97 database.

Any help would be GREATLY appreciated.
Thanks,

Kramerica

 

[Frink]

Hallo,

Can you use the TransferDatabase method to link to the table in the other database?
It's an Access '97 thing. I guess it's in 2000. Have a look in the help,

- Frink

 

[kramerica]

Is TransferDatabase an acceptable method for sending Data across a WAN Link?

Kramerica

 

[Frink]

Hallo,

I don't know much about connecting to remote tables, but the example in the help seems to suggest that it TransferDatabase can be used:

DoCmd.TransferDatabase acLink, "ODBC Database", _
	"ODBC;DSN=DataSource1;UID=User2;PWD=[URL unfurl="true"]www;LANGUAGE=us_english;"[/URL] _
	& "DATABASE=pubs", acTable, "Authors", "dboAuthors"

- Frink