Disconnect ODBC connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Momo - 28 May 2007 14:00 GMT

I have this problem. I'm connecting to Navision native DB from AccessXP via
CODBC (unfortunately still 2.6). There is standard linked table. How can I
disconnect from Navision DB if I don't want to close whole application?

Reply to this Message

Douglas J. Steele - 28 May 2007 14:20 GMT

You can delete the linked table. (Don't worry: this has no impact on the
data in the actual table)

Of course, that means you'll have to have code to recreate the linked table
when you want to reconnect to the database.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have this problem. I'm connecting to Navision native DB from AccessXP via
> CODBC (unfortunately still 2.6). There is standard linked table. How can I
> disconnect from Navision DB if I don't want to close whole application?

Reply to this Message

Momo - 30 May 2007 12:51 GMT

OK, I try link and delete it direct from code. Thanx.

Reply to this Message