Re: Queries from Access

"James" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0A7325C1-039C-4765-BB72-9822A56E2F62@xxxxxxxxxxxxxxxx

I set up a linked connection to it and it worked fine. the lock file
appeared as well.

If I open up the database the lock file appears and the query shows all
the
records it should.

In which case, you need to apply the Sherlock Holmes logic which says that,
once you have eliminated the impossible, whatever is left (however
improbable) must be the answer...

If you have a web page which should be querying a Jet database but, when it
runs, the corresponding locking database doesn't appear and the Last
Accessed date of the Jet database is not updated, then at that precise
moment it isn't querying the database - it just can't be, however improbable
you find this to be...

If you rename the database immediately prior to accessing the page in
question, what happens...?


.

Relevant Pages

  • Re: Queries and OO
    ... >> counterpart to querying a collection of objects and applying logical ... >> operations to obtain projections on the original set, ... Relational theory is not about database tables. ... > manner there would be a corresponding OO way to query those objects to ...
    (comp.object)
  • Re: Query for an Auction
    ... "Nick 'The Database Guy'" wrote ... concurrent users, but not many people will contend that you can actually ... Jet database (see other threads, re: Access vs. Jet -- you are using a Jet ... with one or more being data source for the final Query. ...
    (comp.databases.ms-access)
  • Re: Insert dataset to another database
    ... another table in a different Jet database, all within the execution of a ... single query. ... If I've the Sales06 database file open and am working in it I shouldn't ... connection string or IN string". ...
    (microsoft.public.vb.database)
  • Insert dataset to another database
    ... another table in a different Jet database, all within the execution of a ... If I've the Sales06 database file open and am working in it I shouldn't have ... to specify that database path in the query, I'm theorizing, but regardless ... string or IN string". ...
    (microsoft.public.access.queries)
  • Re: Shall I use database in this application?And how?
    ... text files or storing to and querying a database? ... remove the underscores from my email address (and please indicate which newsgroup and message). ...
    (microsoft.public.windowsce.embedded.vc)