open Access database in MS Query

From: Peter Wilde (anonymous_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 05:18:09 -0700

Is there a way to open an access file using MS Query? I
have the username and password but the database won't
open because of error "You do not have security
permission". I can open the databases very easily in
Access 2000 using the username and password. What is the
probelm? Can someone please help me!

Relevant Pages

  • Re: Database Results Wizard Error Message
    ... > I would any other access file with ASP pages. ... > SQL statement to query the file. ... >> database when you get this error. ...
    (microsoft.public.frontpage.client)
  • RE: Make Table Query in NEW ACCESS file
    ... another database like SQL Server, Oracle, or MySQL. ... database file each month, Access is not the right tool for your job. ... Then i wiil create one new access file then use the make ... table query from my old access file using "Another Database" option. ...
    (microsoft.public.access.queries)
  • Re: [PHP] IPB post date check
    ... database it does store the date/time of each post. ... conditions your query should be something simple like this: ... WHERE username = '$username' ... Or if you don't want an array you could ...
    (php.general)
  • Re: Linking Access databases (Jet SQL)
    ... >Access file, using this syntax: ... the external table in the database which contains the query (primary ... Then you open the primary database with a System.mdb file ...
    (borland.public.delphi.database.ado)
  • Re: Last usage
    ... Rena - you might make a table with two fields: username and loginDate. ... when your startup form opens, run a query to update this table, setting ... > database. ...
    (microsoft.public.access.security)