Re: Workgroup file information file error: OleDB to Access file

From: Paul Keister (bogus_info_bogus_at_bogus_pjpm.biz)
Date: 01/31/05


Date: Mon, 31 Jan 2005 07:46:45 -0800


"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:pqgsv0psnfa9cnv8rj67ded11evj9oks0l@4ax.com...
>
> Any chance the files are read-only or you don't have the appropriate
> permissions to open the
> database? I'm assuming that this is a VB.NET app and not an ASP.NET app.
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Yes, this is a .NET app, not and ASP.NET app. It's actually C#.NET. This
is a good thought, but this was not the problem. Here's what's wrong:
there's a typo in the connection string. It should be, "OLEDB:System
Database," not, "OLE DB:System Database." Doah!

I'm glad nobody noticed this. I feel dumb enough already. This is further
confirmation of one of my long-standing theories: the worst bugs are caused
by the dumbest mistakes. In other words, if you find yourself spending
hours on a problem, don't look for subtle explanations, look for glaring
errors!

Thanks for taking a look at this.

Regards,

Paul



Relevant Pages

  • Re: Security question ..
    ... something other than our app, they will inherit the role and be able to make ... the front end connecting directly to the database, lots of dynamic sql, no ... a user's permissions to a database are ... > What's wrong with SQL authentication? ...
    (microsoft.public.sqlserver.server)
  • Re: Troubles with User Permission
    ... I experience trouble when trying to access the windows registry and my app ... not sure about the database being read-only. ... That may or may not have anything to do with permissions or user privileges. ...
    (microsoft.public.vb.general.discussion)
  • Re: Copying access objects using .net
    ... Paul, ... I have 11 users for this app, ... The test database contains new queries that are used by new reports. ... > ¤ How do I program vb.net to copy a query or table from one MS Access database ...
    (microsoft.public.dotnet.framework)
  • Re: ASP.NET & Access database
    ... If I open my website on my app server, ... runs ok until I try to open the page that requests the access database. ... > There's two types of permissions needed in order to be ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Security settings
    ... is this proof that the hosts FP ... the FP permissions, ... >> Paul M ... >> access to your database, ...
    (microsoft.public.frontpage.client)