tags:

views:

39

answers:

0
Q: 

Access Database Connection

I am using C#.net application with oledbConnection to open database in exclusive mode

what exactly process in backend when we open database in exclusive mode , it not increse size of database compare to shared mode connectivity.

Is it doing Compat or Repair when it close connection of Exclusive Mode??

As we are facing unExpected Errors at time of open connection using Exclusive mode & its come abnormally even we have dispossed all connection properly.

Please share ur view ...if it doing compact/reapai at time of closing connection is there a way to wait before opening new Connection?

related questions

ADO.net Connection Pooling
How to deny accessing from OleDb Provider when Excel is opening?
Data is not saved in MS Access database
Object reference not set to an instance of an object - error
OleDB connection only working when debugging
Access Database connect C# local director
Can't update date in aspx to a MS-ACCESS table
How to force ADO.Net to use only the System.String DataType in the readers TableSchema.
OleDb database to DataSet and back in c#?
Windows Service hangs when opening OLEDB-connection to Excel-file
Why does 'MSysNavPaneGroupCategories' show up in a .NET OleDbProvider initiated query to an MS Access 2K database when the criteria specifies "WHERE MSysObjects.Name NOT LIKE 'MSys*'"?
Connecting MS Access 2000 Database (.mdfb) file in ASP.NET 3.5
OleDbConnection failed creating a new excel file
Example of Where cluase query including the MSACCESS database connection in C#
Reading an XLS file with the Microsoft Jet Engine
Excel reading in ASP.NET : Data not being read if column has different data formats
SELECT through oledbcommand in vb.net not picking up recent changes.
Obtaining First Excel Sheet Name With OleDbConnection
OLE DB Exception - database/user/password is too large
Excel cell-values are truncated by OLEDB-provider
Best way to check OleDbConnection state
C# Issue: What is the simplest way for me to load a .MDB file, make changes to it, and save the changes back to the original file?
ASP.NET OleDbConnection Problem
OLEDBConnection.Open() generates 'Unspecified error'