.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Microsoft Access Write conflict when using 5 Access modules concurrently

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
Iam new to using Access & SQL server. We use Microsoft Access as front end and SQL server as backend for data Access. I am trying to run a userdefined function(limit check) which takes 2 parameters and returns me a value.  I implemented this way: A subform on a main form connects to the Table. The first 2 columns takes the 2 parameters from the subform and 3 column (computed column specification which runs the userdefined function and gives me a value in 3 column) Iam returning the 3 column value back to Access from. The primary key is on first 2 parameter columns. This worked fine when using 1 Access module. But In production when 5 Access modules try to access the same subform I get "write conflict error" This record has been changed by user since you started editing it. If you save this record you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.The 3 options that I have save record, drop changes,copy to clipboard. Though the 2 records are different somehow sql is thinking that I am trying to modify the same record. When I drop changes press Esc, go back and re run the check it is working fine. Is there any way to get around this problem? There is a way to directly call the function in Access but I

View Complete Post

More Related Resource Links

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Microsoft Application Block for Data Access in .NET


Hi all,

I was rummaging the internet learning aspx and came across the concept of: Microsoft Application Block for Data Access in .NET

It seems great of course. The articles are all early 2003-5 such as


So the question is - is this tech still relevant and should I be using it?



Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0


What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000

Video: The Access Show: Demo of Microsoft Access 2010 Services and Web Databases

Ryan McMinn and Clint Covington have a big announcement for us - Access Services is new functionality as part of SharePoint 2010 that allows users to create databases with forms and reports that run in the browser. (Length: 24:00)

64 bit ODBC driver for Microsoft Access

Hello,I am trying to connect to one of my Access databases (.mdb file on my local) from ODBC connection. The problem is, I am using 64-bit Xp Pro and it does not see any Access driver on 64-bit architecture. Does anybody have 64-bit compatible ODBC driver for Microsoft Access ? Any other help also will be appreciated....

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access

Hi,I am importing Excel 2007 file into SqlServer 2005 (Sqlexpress). The office 2007 is not installed in the machine. I have downloaded and installed "AccessDatabaseEngine". When I execute following statement SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\File1.xlsx', 'SELECT * FROM [Sheet1$]');The following error is comming:Msg 7399, Level 16, State 1, Line 1The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.Msg 7350, Level 16, State 2, Line 1Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".Can any one suggest what should I do to resolve?Thanks,Parmeshthee. Learning .Net 3.5

Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.40' has been denied.

Hi all,   I am currently working on a stored procedure in SQL 2000 where I use OPENROWSET function to read data from an Excel file into a temporary table.   It works fine when I logged in with username 'sa' and psswrd 'sa' but when I log in with another user name and password I get the following error: "Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.40' has been denied. You must access this provider through a linked server."   I am using VB 6.0 as front end. Is there anyway i can overcome this error?   Please help.   Dhiraj

Does Microsoft plan to enhance SSRS to allow access to multiple data sources?

We have the need to join multiple data sources into one table in SSRS.  At present, as I understand it, this is not a part of current delivered functionality.  We get around it by creating links withing the source database to access other databases.  The links themselves have their own set of constraints and performance issues. The other option is to use sub reports.  It would be nice to be able to define connections to disparate databases to join data from multiple data sources.  Does Microsoft have plans to deliver such functionality in an upcoming release of the SSRS product?

is there any tool or add-on for write color and comfortable query on access-2007 ?

hi is there any tool or add-on for write color and comfortable query on access-2007 ? thank's in advance

can i use Microsoft Access Queries with ADO.net ?


Hello all , 

can i use Microsoft Access Queries with ADO.net like Stored Procedures in SQL Server ? 

Thanks in advance 

Kareem Naguib

access to Microsoft.Office.Server.dll


I'm customizing a login page for forms auth and get an error. I even allowed the internet user read access to:
c$\Program Files\Common Files\Microsoft Shared\web server extensions\12\ISAPI

Microsoft.Office.Server.dll date: 8/24/2007


I have login.aspx page that has the code in a user control Login.ascx and Login.ascx.cs.

using Microsoft.SharePoint;
using Microsoft.Office.Server;                       //errors here
using Microsoft.Office.Server.Administration;
using Microsoft.Office.Server.UserProfiles;


c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\myfiles\Login.ascx.cs(13): error CS0234: The type or namespace name 'Office' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)   at System.Web.Compilation.AssemblyBuilder.Compile()
   at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
   at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Bool

Access Violation in .NET 4 Runtime in gc_heap::garbage_collect with no unmanaged modules


Hi all,

We are experiencing an access violation in the .NET 4.0 runtime, in a piece of code that uses NHibernate heavily. None of our own code interops with native code directly, nor does the 3rd party code we are using (to the best of our knowledge). We cannot identify the memory pattern that is appears to be corrupting the GC heap, and we don't know whether the problem is in the GC itself or in some other piece of code that is corrupting it.

I've included below the stack trace of the offending thread, and the list of loaded modules.

We need some help debugging this issue. What should we do next?

Adam Smith
Director, Technology
Hubbard One
Thomson Reuters


0:000> !EEStack
Thread   0
Current frame: clr!WKS::gc_heap::find_first_object+0x64
ChildEBP RetAddr  Caller, Callee
0012bf30 791fa5b8 clr!WKS::gc_heap::mark_through_cards_for_segments+0x116, calling clr!WKS::gc_heap::find_card
0012bf38 791fa618 clr!WKS::gc_heap::mark_through_cards_for_segments+0x563, calling clr!WKS::gc_heap::find_first_object
0012bfc4 791faaa1 clr!WKS::gc_heap::relocate_phase+0x5b, calling clr!WKS::gc_heap::mark_through_cards_for_segments
0012c000 791f7a52 clr!WKS::gc_heap::plan_phase+0x851, calling clr!W

Microsoft Office Excel cannot access the file.There are several possible reasons: . The file name or

Hi all,
I am workin on Arc IMS web application project where I will be uploading an excel file containing data say city,addresszip(column headers in excel file)..etc..and load necessary column data in listboxes..and finally save the data to an excel file..when I run though Studio I dont get error..when I run through browser..I got errors ..I even modified DCOMCNFG...But..I get the below error..
Microsoft Office Excel cannot access the file 'E:\vijay\ArcIms\Excelsheets'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.
Here goes my code..
Imports Excel
Imports System.Data.OleDb
Imports System.Data
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim connection As New System.Data.OleDb.OleDbConnection
    Dim command As New System.Data.OleDb.OleDbCommand
    Dim dr As System.Data.OleDb.OleDbDataReader
    Dim cmd1 As New System.Data.Ol

Microsoft Excel cannot access the file


I am trying to import an excel content to a SharePoint list. When I choose an excel file and import I am saving the file Using "Microsoft.Office.Interop.Excel" object to the temporary folder location and reading it from there. When I try opening a file using "Microsoft.Office.Interop.Excel.Application.Workbooks.Open" I am getting the following error.

Microsoft Excel cannot access the file "TEMP" folder. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

I have tried impersonating the INTERACTIVE USER account. But this looks like the excel object doesn't have permission. Please share your inputs on this issue.

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.


Hello everybody.

I am in a critical situation. I first tried to make a project (file->new->project) using visual studio, where I displayed the content of a excel file by GridView. I was successful then, but when I attach it to my website located in inetpub I am getting this error :

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.xlsx'. There are several possible reasons:

. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.

At first I faced some COM related problem and found solution in Google, but this particular problem is not solving. Is there any way to access Excel document in asp.net website?

In my application there is a facility of uploading excel document to the server and then display its content. But I have failed to do this display operation, is there any turn around way, like store the excel document as dataset and then access it as required.

Please help. I am in great trouble. Thanks in advance.

Microsoft Access 2010 Error


"An error occured while initializing the access database."

I was trying to publish a access 2010 web database to SharePoint 2010 Enterprise.   


Larry Stupka

Tring to write to web.config file error Access to the path


Hi Friends.

Actually i m trying to make a setupfile for my project.That makes some processes and at the end of processes will change web.config Database connectionstring values and will run project.Evertthing is good but cant reach to web.config file beacuse of permissions.
Project will run on out of company hosting account.So i cant reach IIS to change permissions.

So please offer me a way or if you know solution.Please help.
I also thinking on downloading web.config file with ftp account and change it and reupload back with programaticly in code.
Waht you think???

System.Configuration.ConfigurationErrorsException: An error occurred loading a configuration file: Access to the path 'C:\Inetpub\vhosts\xxx.com\httpdocs\rouqudck.tmp' is denied. (C:\Inetpub\vhosts\xxx.com\httpdocs\web.config) ---> System.UnauthorizedAccessException: Access to the path 'C:\Inetpub\vhosts\xxx.com\httpdocs\rouqudck.tmp' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, B

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend