Re: Querying Data from Secured Access Database with VBA

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 17:18:58 -0500

Perhaps someone here is an expert on this, but I know I am not. I would
recommend posting in an Access newsgroup for a more definitive answer. the
only relevance to Excel is that you are doing it through Excel VBA, but that
would be true for Word, PowerPoint, VB and so forth. 

-- 
Regards,
Tom Ogilvy
"VBA Dabbler" <VBADabbler@discussions.microsoft.com> wrote in message
news:D8BBE1A3-656B-46FC-AB62-7172569753FB@microsoft.com...
> Tom,
> Yes.  However, the database is on a network share and so is the workgroup
> file.  I browsed your site - the closest match I found to my situation is
"If
> using a Workgroup (System Database)" under "OLE DB Provider for Microsoft
Jet
> ".  It's below:
>
> oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
>            "Data Source=c:\somepath\mydb.mdb;" & _
>            "Jet OLEDB:System Database=MySystem.mdw", _
>            "myUsername", "myPassword"
>
> How do I point to the workgroup file?  Replace the "MySystem.mdw"
reference
> to the path/name combination of the workgroup file?
>
> Thanks,
>
> VBA Dabbler
>
> "Tom Ogilvy" wrote:
>
> > Do you mean something like this:
> >     Set adoConn = New ADODB.Connection
> >     adoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
> > sAccessDB & "; USER ID=Admin; PASSWORD=abcd;"
> >
> > or does the database itself have a password:
> >
> >
> >
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet
> >
> > Look for the section 'If MDB has a database password'
> >
> > -- 
> > Regards,
> > Tom Ogilvy
> >
> > "VBA Dabbler" <VBADabbler@discussions.microsoft.com> wrote in message
> > news:FA2A4C22-C5B3-422F-BEED-C5D8DF6C5F77@microsoft.com...
> > > Does anyone know the syntax to establish a workspace/connection to
query
> > data
> > > from an Access database that has security set up?
> > >
> > > I've set up a special UserID and Password for this purpose.
> > >
> > > Thanks,
> > >
> > > VBA Dabbler
> >
> >
> >

Relevant Pages

  • Re: Querying Data from Secured Access Database with VBA
    ... using a Workgroup (System Database)" under "OLE DB Provider for Microsoft Jet ... "Tom Ogilvy" wrote: ... >> VBA Dabbler ...
    (microsoft.public.excel.programming)
  • Re: Sorting out security
    ... > MS Access security. ... > created a new workgroup, added a password for the Admin role, added ... > remote logins to a secured database. ... The location of the current workgroup file is recorded in the ...
    (microsoft.public.access.security)
  • Re: Workgroup file connection problem!!!
    ... While it's possible to attach a new workgroup file to Access, ... The shortcut must include the full path to msaccess.exe, ... Doug Steele, Microsoft Access MVP ... I have some question concerning attachments of new users to the database ...
    (microsoft.public.access.security)
  • Re: Basic security questions
    ... Your ASP page would "connect" to the file on the Unix box via ADO or ADO.NET ... Password protected databases are different from database protected by ULS ... ULS protected databases require the use of the .mdw workgroup file ... >> If you double-click an mdb file, the sequence of actions is as follows. ...
    (microsoft.public.access.security)
  • Re: No login prompt
    ... log in through a workgroup file - even on a new, fresh install of Access, ... transfer a database to any machine with Access installed and open it. ... > Access window stay open, and then try to open a db, it does not prompt me ... >>> and passwrd and simply opens ...
    (microsoft.public.access.security)