Re: Can't Open OleDb Connection to Access Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Scott M. (NoSpam_at_NoSpam.com)
Date: 03/16/05 

Date: Tue, 15 Mar 2005 20:14:13 -0600

When setting the data source in the connection string, you must put a full
physical path to the Access db. Indicating a server share is not
acceptable.

"David" <deaton@nospamever.dsnonline.org> wrote in message
news:%231L7FmcKFHA.484@TK2MSFTNGP15.phx.gbl...
> I'm trying to open an OleDb connection to an Access .mdb file to fill a
> datareader and display the records in a datagrid on a web form (using
> Visual Studio .NET). It all works great when the .mdb file is local, but
> when I try to connect to an .mdb file on a network share, the web page
> displays, "The Microsoft Jet database engine cannot open the file
> '\\CoSvr2\backends$\Base.mdb'. It is already opened exclusively by another
> user, or you need permission to view its data." But the file isn't open
> and granting full control permissions on the share to everyone doesn't
> work. Any help would be greatly appreciated!
> David
>

Relevant Pages

  • Re: Connect to an mdb file resource
    ... Well the problem is that the mdb file is embedded in the executable as ... a resource. ... So I don't now how to point the connection string to it ... Basicly what do I enter for the Data Source? ...
    (microsoft.public.dotnet.general)
  • MailMerge with SQL Server, OpenDataSource problem
    ... Attaches the specified data source to the active document, ... Microsoft Query file instead of a specifying a data source, ... connection string, and a query string. ...
    (microsoft.public.office.developer.automation)
  • Re: Word cannot find data source problem
    ... The string will be saved either in the connection string, or in the SQLStatement, or split across the two, depending on how Word chose to make the connection. ... Can you tell me where the path to the data source is saved when I do the ... location of a data source into a "database" and a "table". ...
    (microsoft.public.word.mailmerge.fields)
  • Re: OpenDataSource in vba creates an error
    ... if all the connection information is in the Connection string, ... if you are using Integrated Security for SQL Server access, ... > I have a problem connecting to data source in mail merge. ... > I created a datasource through the Select Data Source screen to connect to ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word cannot find data source problem
    ... "Peter Jamieson" wrote: ... could you tell me if any data source information is stored in my ... >> the database part of the data source's locatoin in a /Connection>> string/, ... Word constructs a connection string ...
    (microsoft.public.word.mailmerge.fields)