Locking File

[DW]

When user log in to edit the Data Access Page, Access creates an ldb on my
side, and I can not enter the database while they have the DAP open. I can
get into the web site for the DAP simultaneously, but not into the .mdb
database. How can I configure this so I can get into the database while users
are using the DAP?

 

[Jack Leach]

Split it into two seperate files, one for your DAP user and one for you.
This assumes that you already have a seperate file for the backend.

If you don't have a file for the backend, you'll want to make one (and use
the linked table manager in your two front ends to connect to it).

At no point should there ever be more than one person in a db at a time...
you have the backend, which many frontends may connect to (but no users
should actually have that open), and you'll have as many local copies of the
frontend as required so each user has thier own.

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[DW]

Jack,

Thank you. If I split the database, should the connection string on the DAP
refer to the front end or the back end? Also, let me ask about security
settings. In order for the DAP to work, anonymous access must be granted on
the folder that contains the database so users in the field who do not have
LAN access can access it through the Page. Would it work if I put the back
end on a folder with anonymous access and the front end in a folder with
limited security settings?

 

[Jack Leach]

I've never really used DAPs before, but in a standard setup, all frontends
should connect to one backend...

/--FE1
/
BE---FE2
\
\--FE3

All data is stored in the backend, and forms/reports etc are stored in the
frontends.

You should never really be connected an app to a frontend (not that I can
think of anyway)

In order for the DAP to work, anonymous access must be granted on
the folder that contains the database so users in the field who do not have
LAN access can access it through the Page. Would it work if I put the back
end on a folder with anonymous access and the front end in a folder with
limited security settings?

If you are required anonymous access for the DAP user, I would assume they
must have anon access to the FE. Although I honestly don't know for sure...

hth

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)