This is a migrated thread and some comments may be shown as answers.

Error with connecting to mdb is currently open by other user

2 Answers 87 Views

ComboBox

This is a migrated thread and some comments may be shown as answers.

Vinh asked on 20 Dec 2010, 08:02 PM

Hi,

I'm using the following AccessDataSource

<asp:AccessDataSource ID="AccessDataSource2" runat="server"

EnableCaching="true"

CacheDuration="300"

DataFile="\\servername\myfile.mdb"

SelectCommand="SELECT `CustomerNo`, `Company`, `Attention`, `City`, `State` FROM `Customers`" >

</asp:AccessDataSource>

for

<telerik:RadComboBox ID="ddlCustomers" runat="server"

Width="150px" Height="150px"

Skin="Vista"

DataSourceID = "AccessDataSource2"

DataTextField = "CustomerNo"

DataValueField = "CustomerNo"

DropDownWidth="410px"

EmptyMessage="Select a Customer"

EnableItemCaching="true"

EnableLoadOnDemand="true"

EnableVirtualScrolling="true"

HighlightTemplatedItems="true"

SelectedValue='<%# DataBinder.Eval(Container, "DataItem.CustomerName") %>'

AllowCustomText="true"

OnSelectedIndexChanged="ddlCustomers_OnSelectedIndexChanged" AutoPostBack="True"

>

<HeaderTemplate>

<table style="width: 400px" cellspacing="0" cellpadding="0">

<tr>

<td style="width: 100px;"> Customer No</td>

<td style="width: 150px;">Company Name</td>

<td style="width: 150px;">City</td>

</tr>

<tr>

<td style="width: 100px;"></td>

<td style="width: 150px;">Attention</td>

<td style="width: 150px;">State</td>

</tr>

</table>

</HeaderTemplate>

<ItemTemplate>

<table style="width: 400px" cellspacing="0" cellpadding="0">

<tr>

<td style="width: 100px;"><%# DataBinder.Eval(Container.DataItem, "CustomerNo")%></td>

<td style="width: 150px;"><%# DataBinder.Eval(Container.DataItem, "Company")%></td>

<td style="width: 150px;"><%# DataBinder.Eval(Container.DataItem, "City")%></td>

</tr>

<tr>

<td style="width: 100px;"></td>

<td style="width: 150px;"><%# DataBinder.Eval(Container.DataItem, "Attention")%></td>

<td style="width: 150px;"><%# DataBinder.Eval(Container.DataItem, "State")%></td>

</tr>

</table>

</ItemTemplate>

</telerik:RadComboBox>

and if that Access file not open, then its fine otherwise I can received this error "Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Could not use ''; file already in use." I can open this Access file fine without any error when other is opening it.

Thanks

Vinh Vu

2 Answers, 1 is accepted

answered on 24 Dec 2020, 12:22 PM

In that case, I suggest you to set user permission in Access database as per your requirement.
After making such settings you never have to face such Error with connecting to mdb is currently open by other user like issues.
Here is how to manage user permission in Access database.