Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disconnect from a table

Status
Not open for further replies.
rewdee

rewdee

Programmer
Aug 17, 2001
295
US
I've seen a few posts regarding tabledefs and the connect method to connect to a table. Does anyone know how to DISCONNECT from a table in a remote database. Do I set some property or just delete the table to disconnect?

Thanks,
Rewdee
 
Sort by date Sort by votes
If you have created a Tabledef with the Connect method to work with an external database table, the only way I know to end the connection is just deleting the TABLE.

For example: dbasetempname.TableDefs.Delete Tablename

[afro]Cheers ! Balbino.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
673
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
654
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
426
Moss100
Moss100
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
372
Zyborg
Zyborg

Part and Inventory Search

Sponsor

Back
Top