adOpenForwardOnly

The backend of my database is being placed in a read only state some
how. I use several queries with the following statements:
rsCCurrentStatus.Open sCCurrentCustomstatus, dcnn, adOpenForwardOnly,
I close the connection and set it to nothing each time. If a user is
running that sub and closes it without letting it finish could this
place my backend in a read only state?

.

Relevant Pages

  • Re: Multi users in one form
    ... queries, forms, reports, modules, macros, or in table links. ... tables in the backend. ... All your queries/forms/reports in the frontend will ... permissions) on the folder where the backend is located. ...
    (microsoft.public.access.security)
  • Re: backend security question
    ... I have thought about using RWOP, and actually have all the queries ... >> open the backend and view that table, it has everyone's SS#'s, ... > permissions) queries for all data interaction. ...
    (microsoft.public.access.security)
  • Re: Multi users in one form
    ... queries, forms, reports, modules, macros, or in table links. ... tables in the backend. ... All your queries/forms/reports in the frontend will ...
    (microsoft.public.access.security)
  • Re: Update Queries dont work in form
    ... I split the database with the splitter in access and placed the backend ( ... the Tables) on a server running XP and the Front end on ... Now I go to run a query I get the message "Operation must use an Updateable ... Not all queries are updateable. ...
    (microsoft.public.access.forms)
  • Re: Passing Parameters To Stored Procedure
    ... "David Paynter" wrote in message ... > a DataProcessor A2K DB by linking to the BackEnd tables. ... > A2K DB mainly consists of select & action queries. ...
    (microsoft.public.access.modulesdaovba)