Error with connecting to mdb is currently open by other user

[Vinh]

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

[Simon]

Hello Vinh,

This is a permission issue. Please see this forum thread for more information.

Greetings,
Simon
the Telerik team

[Edward]

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.