473,320 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Unable to close connection to Access database

Hi Everyone,

I recently developed an application using VB6 calling Crystal Report bundled with VB.NET.

Problem lies here, whenever i make a call for a report view from MS Access in VB.NET. They will retrieve the data from MS Access and display it in the report viewer. But once i closes the viewer, the ldb file remains there and i can't do any other actions related to MS Access.

How can I force remove ldb file in VB .NET? Or is there any alternative to close the file since automatically it will be closed but Crystal Report doesn't do that.
Mar 1 '07 #1
2 5234
MMcCarthy
14,534 Expert Mod 8TB
Hi Everyone,

I recently developed an application using VB6 calling Crystal Report bundled with VB.NET.

Problem lies here, whenever i make a call for a report view from MS Access in VB.NET. They will retrieve the data from MS Access and display it in the report viewer. But once i closes the viewer, the ldb file remains there and i can't do any other actions related to MS Access.

How can I force remove ldb file in VB .NET? Or is there any alternative to close the file since automatically it will be closed but Crystal Report doesn't do that.
If the ldb file is still open this indicates that the instance of the application is not being closed. You will have to trigger a close of the Access Application. If you check your system processes you will probably find that Access is still running.

Mary
Mar 1 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
If the ldb file is still open this indicates that the instance of the application is not being closed. You will have to trigger a close of the Access Application. If you check your system processes you will probably find that Access is still running.

Mary
You might find this tutorial on Application Automation useful.

Mary
Mar 1 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: René Kabis | last post by:
People, I am at my wit's end. I am using the exact code from http://aspnet.4guysfromrolla.com/articles/071002-1.aspx And yet, the code does not manage to update the database. When I go to...
0
by: bazzer | last post by:
hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in...
3
by: Greg Strong | last post by:
Hello All, Is there any way to close an ODBC connection via DSN without completely closing the Access front-end? I'm doing some testing with using Access as a front-end to Oracle 10g Express...
8
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query...
7
by: stan.kolker | last post by:
HI, I am just trying to open vss: try SourceSafeTypeLib.IVSSDatabase vssDb = new VSSDatabaseClass(); vssDb.Open(@"C:\Program Files\Microsoft Visual...
4
by: =?Utf-8?B?VG9kZCBKYXNwZXJz?= | last post by:
Hey guys, I've written a web application that I'm simply trying to use to access a database. When I run the application locally (or as an NT Service) it can easily access the remote SQL...
6
Cintury
by: Cintury | last post by:
Hi all, I've developed a mobile application for windows mobile 5.0 that has been in use for a while (1 year and a couple of months). It was developed in visual studios 2005 with a back-end sql...
2
by: vegeta456 | last post by:
I have a really strange problem. I am using Microsoft Access 2003 under Windows XP Professional. I am trying to read a CSV file using VBA in Access using the following procedure. Public Sub...
0
by: ll | last post by:
I'm working with 'pure ASP upload' script which is designed to redirect to an alert/error message, should a file larger than the set limit be attempted to be uploaded. The problem is that, while...
2
by: user | last post by:
Hello, I simply make some aspx web page to update data in a mdb access database..But when this database is open (not table, juste the mdb in access) with MS Access, i have an error with my asp.net...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.