.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

MS ACCESS lock problem

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Dear all,

thanks for reading.

I got a problem which I have been suffering from for ages. we have a lot of MS access applications (Access '97) which link tables in sql server 2008. As you know the access application locks data extensively. And I can not use 'with nolock' table hint in access application. the result is we have a lot of long locks or even deadlock. How to minimize the amount of locks?

Is there anyone who came across this issue and please share your ideas.


View Complete Post

More Related Resource Links

Problem connecting to SQL Server 2008 R2 Express from Access 2007

I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Problem with access to a user in AD group

Hi all, We are managing our security in Sharepoint (WSS 3.0) with AD groups instead of Sharepoint groups. This worked fine until now. For an unknown reason, one single user from an AD group cannot access a page (while other users from the same group can). The group is also a distribution list in AD (so it's a security group and distribution list for emails). It includes several other distribution lists such as: L-All-Corporate-Employees    L-Administration          User 1          User 2           ...     L-Accounting         User 1         ... ...   So far I never had any issue with that kind of approach,  but yesterday we published a new web part page and wanted only the corporate employees to get access to it, so I broke rights inheritance on the page and added the L-All-Corporate-Employees group with View rights. As I already said, I tested with one user from the group (let's say from the L-Administration sub-group) and it works, now I receive an email from another user (let's say from the L-Accounting sub-group) which tells me he doesn't have access... But they're all part of the L-All-Corporate-Employees group, so they should all

Access violation in wpfgfx_v0400.dll - How to find the problem?

I have an access violation exception generated inside wpfgfx_v0400.dll. I have the minidump loaded in visual studio 2010 with all my program's symbols loaded in debug mode. Unfortunately, the stack is of little use. I have searched on the net for help but I could not find anything. I would like to know what I can do from here. Here is the stack for the thread that caused the access violation. Unhandled exception at 0x778b64f4 in WERE8E3.tmp.hdmp: 0xC0000005: Access violation reading location 0x24448900. >   ntdll.dll!778b64f4()      [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll]        wpfgfx_v0400.dll!6abb6d2e()          wpfgfx_v0400.dll!6ab9e2d5()          wpfgfx_v0400.dll!6ab22c98()          wpfgfx_v0400.dll!6ab22c98()          wpfgfx_v0400.dll!6ab22c98()          wpfgfx_v0400.dll!6ab23dca()          wpfgfx_v0400.dll!6ab22dbb()          wpfgfx_v0400.dll!6ab291e2()    

Problem with ODBC from MS Access 2007 to MS Sql Server 2008

Hi experts, I need some help with ODBC Connection Settings from MS Access 2007 to Sql Server 2008. Here is the Scenario, I have created a Database(StagingDB) with 5 tables on SQlServer 2008 and I have  Developed an MS Access 2007 Front End using Linked tables and ODBC to Insert/ Update data into these 5 tables. This is just working fine in my Dev database. ODBC Connection Settings are pointing to my DevServer. All I wanted to do now is, I want to point the ODBC Settings to the same database on my Test Server and then to Production Server. I have Changed the Server name in the ODBC File to point it to my Test Server and If I try to Insert  some data into test server its stil going into the database on Dev server. Is this the right way to do. Please help me with this. thanks In Advance..

Outlook web access - my calender log in problem

Hi there. We have an intranet solution built on Sharepoint 2010 enterprise. I'm trying to connect the My Calendar web part(found under Outlook web access web parts) to my clients outlook exchange -server. I've set the server to be https://webmail.[company].fi/exchange and the credentials in the web part properties. I get the signing in -part to show on my web part but for some reason cannot log in. There is no error or notification about what went wrong with the login. When I open up a new tab and go straight to https://webmail.[company].fi/exchange and log in with the same credentials that I tried on the web part, I can log in. Now when I go back to my original tab -having the my calendar web part- and refresh, the web part suddenly works and it displays the calendar as it's supposed to. Why can't I log in directly in the My Calendar web part? What could be the problem? Thanks in advance

Join Expression Not SHi All, I use Access 2007, and I have the following SQL problem: I have two t

Hi All,

I use Access 2007, and I have the following SQL problem:

I have two tables TransformerTypePeriodBOMProducts and TransformerTypePeriodProducts. The first table has 4 fields: TransformerTypeID, OutputProductID, PeriodID and BOM, while the second has the following 4 fields: TransformerTypeID, OutputProductID,PeriodID and AssemblyCapacity. So as you can see, there are 3 fields (TransformerTypeID, OutputProductID and PeriodID) that are in both tables.

I need to delete all records in the first table that have the field AssemblyCapacity in the second table equal to 0 (and of course have similar TransformerTypeID, OutputProductID and PeriodID fields).

I tried many trials, the last I got was:

SELECT TransformerTypeAssemblyPeriodBOMProducts.*
FROM ((TransformerTypeAssemblyPeriodBOMProducts INNER JOIN TransformerTypeAssemblyPeriodProducts ON TransformerTypeAssemblyPeriodBOMProducts.TransformerTypeID=TransformerTypeAssemb
lyPeriodProducts.TransformerTypeID) INNER JOIN TransformerTypeAssemblyPeriodProducts ON TransformerTypeAssemblyPeriodBOMProducts.OutputProductID=TransformerTypeAssembly
PeriodProducts.OutputProductID) INNER JOIN TransformerTypeAssemblyPeriodProducts ON TransformerTypeAssemblyPeriodBOMProducts .PeriodID=TransformerTypeAssemblyPeriodProducts.PeriodID
DELETE * FROM TransformerTypeAssemblyPeriodB

Strange Access Denied Problem


I have SP2010 stup with a TFS portal. Brand new machine for the job. Installed 2008R2, Installed SP2010 when release, Installed TFS when released. Set the relative TFS groups up to people could see work items and so fourth in the portal. Added the relative users to the relative SP groups and it all works fine Except everyone bar me gets Access denied if they have been logged out of portal for too long. The way this is fixed is by me logging in.

I'll try to be clearer.

User A tried to log into the portal first thing in the morning.
User A gets Access Denied.
User A SMSs Me (the admin)
I log in and do nothing but login, don't touch a single link, don't do anything, Just login.
User A can now Login in.

User A can be any none admin type user. It happens to everyone.

This has been going on since the day it was setup. Basicly the day after VS2010 was released. It has not been a majour issue so far as we are only doing prep work for a new project so only a couple of people have been adding documents but thats about to change so I need to sort it out.

Any Ideas.



Why is there a problem of access denial?

I tried to add a new mdf object to my MVC web project. Yet it says Access is denied. Can someone tell me why this happens? Thanks.

StreamReader.BaseStream.Read() problem in Random access reading of file


I am trying to randomly access a file but not fully understanding this class.

I have

 // Seek to the beginning of the field

System.IO.StreamReader srFile = new System.IO.StreamReader(_FileName.PathAndFileName);

srFile.BaseStream.Seek(FieldOffset, SeekOrigin.Begin);

// Read the field

int FieldLength = Field.FieldLength;  

int BUFFER_SIZE = (int)RecordLength;

byte[] bBuffer = new Byte[BUFFER_SIZE];

srFile.BaseStream.Read(bBuffer, 0, (int)FieldLength);

string FieldValue;
FieldValue = bBuffer.ToString();

but bBuffer is numbers like:

[0] 32

and the value of FieldValue is "System.Byte[]"

I'm trying to get text as this is a text file.


SharePoint Central Administration v3 access problem


When attempting to browse to SharePoint Central Administration v3 I get the following error:

Cannot connect to the configuration database.

Everything appears to running correctly, the SharePoint site comes up ok, but not the admin page.

Any ideas?

Problem with connectionstring in data access layer



I am developing a web application in Visualt Studio 2008. I have a data access layer that is automatically generated using Visual Studio. After publising my site to IIS and tested it for several hours, two exceptions occured:

Not allowed to change the 'ConnectionString' property. The connection's current state is connecting.	   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)     at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)     at C2T.DataAccess.UsersDataSetTableAdapters.UsersTableAdapter.InitConnection() in C:\sejanhe\Click2Track\C2T.NET\C2T.DataAccess\UsersDataSet.Designer.cs:line 1378     at C2T.DataAccess.UsersDataSetTableAdapters.UsersTableAdapter.get_Connection() in C:\sejanhe\Click2Track\C2T.NET\C2T.DataAccess\UsersDataSet.Designer.cs:line 1159     at C2T.DataAccess.UsersDataSetTableAdapters.UsersTableAdapter.InitAdapter() in C:\sejanhe\Click2Track\C2T.NET\C2T.DataAccess\UsersDataSet.Designer.cs:line 1251     at C2T.DataAccess.UsersDataSetTableAdapters.UsersTableAdapter.get_Adapter() in C:\sejanhe\Click2Track\C2T.NET\C2T.DataAccess\UsersDataSet.Designer.cs:line 1149     at C2T.DataAccess.UsersDataSetTableAdapters.UsersTableAdapter.FillByUserNamePasswordAndStatus(UsersDataTable dataTable, String Usr_Names, String Usr_Pwd, Nullable`1 Usr_Status) in C:\

Problem with vs 10 C# data access


I developed an application using C# and SQL EXPRESS 2008 on a windows 2003 server and it works fine

but after that in another PC which has windows 7 I installed SQL SERVER MANAGEMENT STUDIO and tried to access the database which was on the 2003 server then the database was accessible

I used the following on SQL MANAGEMENT STUDIO

Server Type : Database Engine

Server name : xxx.xxx.xxx.xxx\SQLEXPRESS

Authentication :

     Login : sa

     Password: <BLANK>


bt when I develop an application in that client PC and tried to access SQL SERVER EXPRESS using C# it din work it states that a



A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)



 SqlConnection cn = new
 SqlConnection("user id=sa;"

Problem of access when changing Roles


Hello friends,

well i have a simple application using an authentication (user and password) before accessing and there are several roles bound to each user.

in my web.config i have configured the acces for each page according to each role, this is an example below:

<location path="Home.aspx">
       <allow roles="administrator,role1"/>
       <deny users="*"/>
<!-- -->
<location path="admin.aspx">
       <allow roles="administrator"/>
       <deny users="*"/>

and i have 2 users:

1: admin (default role: administrator)

2: guest (default role: role1)

my problem is as follows:

if i give acces to the user "guest" to open the "admin.aspx" page with changin him his role from "role1" to "administrator", this one do not function except if i r

Connectivity problem between MS Access 2007 and SQL Server Express 2005


I have linked my tables, in SQL Server Express 2005, to MS Access 2007 and created a File DSN named LocalSQLServer.dsn. Both the front end (MS Access 2007) and the back end (SQL Express 2005) are on the same machine.

I am trying to check an open connection , and for that I have written a module -- Function CheckConnection(strFileDSNName As String, _

      strDBName As String, Optional strUN As String, Optional strPW As String) As Boolean

strConnect = "Provider=ODBC" & _

";FILE DSN =" & strFileDSNName & _

";Database=" & strDBName


I have created a form with a command button to check the connection, but it is giving the following error

"-2147467259; Method 'Close Connection' of Object'_CurrentProject failed


I am not able to figure it out, if the Connection Parameters that I have taken are correct or not. Please help me in this.



Problem using Office 2010 64 bit driver for MS Access


I've a 64 bit SSRS 2008 R2 server. My goal is to provide user the capability to create a report against Access 2003. In order to do that I am installed  Office 2010 64 bit driver for MS Access from the following site: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d. The driver got installed just fine, when I try a UDL, I do see the option: Microsoft Office 12.0 Access Database Engine OLE DB Provider. But when I try to create a Data Source in SSRS, I do not see that provider under OLEDB. Can anyone suggest what I should do? 



problem getting data from Access


What is the problem with this code?

DataTable dt = new DataTable();
        dt.Columns.Add("EventID", Type.GetType("System.String"));
        dt.Columns.Add("EventEnd", Type.GetType("System.String"));

        string connectionString = "provider = Microsoft.Jet.OLEDB.4.0;" + "data source =" + Page.Server.MapPath("App_Data\\database.mdb");

        System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connectionString);

        System.Data.OleDb.OleDbCommand cmd = conn.CreateCommand();

        cmd.CommandText = "SELECT * FROM [event]";


        System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader();

        DataRow dro;

        dro = dt.NewRow();
        dro["EventId"] = dr["EventID"].ToString(); 
        dro["EventStart"] = dr["EventStart"].ToString();
        dro["EventEnd"] = d

Access permission problem when verifying xml document, CspParameters ?


I have used the the CspParameters obeject and set the container name. Im then putting it into an RSACryptoServiceProvider object and then calling:

isVerified = signedXml.CheckSignature(rsaKey);

The full code is


public static Boolean VerifyLicenceFile(string xmlLicFilePathArg)
      bool isVerified = false;


        CspParameters cspParams = new CspParameters();
        cspParams.KeyContainerName = containerName;

        RSACryptoServiceProvider rsaKey = new RSACryptoServiceProvider(cspParams);

        // Create a new XML document.
        XmlDocument xmlDoc = new XmlDocument();

        // Load an XML file into the XmlDocument object.
        xmlDoc.PreserveWhitespace = true;

        // Check arguments.
        if (xmlDoc == null)
          throw new ArgumentException("Doc");
        if (rsaKey == null)
          throw new ArgumentException("Key");

        // Create a new SignedXml object and pass it
        // the XML document class.
        SignedXml signedXml = new SignedXml(xmlDoc);

        // Find the "Signature" node and create a new
        // XmlNodeList object.
        XmlNodeList nodeList = xmlDoc.GetElementsByTagName("Signature");

        // Throw an exception if no signature was 
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