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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Losing Access / SQL Server connection when runnng query

Status
Not open for further replies.
gillianm1

gillianm1

Programmer
Sep 8, 2000
26
IE
Hi all,
I am running an Access query from VB. The query includes a linked sql server table. When I execute the query directly from Access, it runs fine. However when I try to execute it from VB using command.execute the connection between Access and SQL Server is lost. Anyone have any ideas why?
Thanks [sig][/sig]
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
650
strongm
strongm
marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
645
marty1944
marty1944
sal21
  • Locked
  • Question
SIMULATE via code the message when i click on cerca
Replies
10
Views
718
strongm
strongm
sal21
  • Locked
  • Question
ARRANGE this Access coe to vb6
Replies
4
Views
288
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top