U
uGek
Hello,
I have a database application with a back end on a shared folder on the
network and the front end on the same folder also. I'm the only one that
uses the front end database. But now I've decided to create a Data Access
Page to allow multiple users (about 10) to go into the DAP and either view a
"report" from a recordset in one DAP or make edits to a list of records that
is populated on the DAP from a parameter query on another DAP. The DAPs are
located on the intranet.
I have encoutered two issues with this set up as far as the record editing
DAP goes.
1) Users can view and retrieve the recordset on the DAP based on the
parameters they enter but cannot make any modifications to the records. I am
the only one that can actually make changes to the records.
2) If a user goes in the DAP before I do I cannot make any changes to the
recordset I retrieve and they still cannot make any changes to the records
retrieved.
My question then is what in the world is going on here?! From what I know
mulitple users can go into the DAP and view and edit records. Maybe there
could be a problem if two users try to edit the same record at the same
specific time. I have both my BE and FE DBs set as "Shared" and "No Locks"
under the advanced settings tab. The shared parameter in my connection
string is set as SharedDenyNone. I don't know what else to do here, and I'm
starting to think that I'm beating a dead horse with a stick here.
Can anyone be so kind and explain to me how would the DAP work in a
muli-user environment and how I could make it work so that multiple user can
go in and edit records at the same time. They would not be the same records
as each user would have different records assigned to them for edit.
Any help with this would be much appreciated.
I have a database application with a back end on a shared folder on the
network and the front end on the same folder also. I'm the only one that
uses the front end database. But now I've decided to create a Data Access
Page to allow multiple users (about 10) to go into the DAP and either view a
"report" from a recordset in one DAP or make edits to a list of records that
is populated on the DAP from a parameter query on another DAP. The DAPs are
located on the intranet.
I have encoutered two issues with this set up as far as the record editing
DAP goes.
1) Users can view and retrieve the recordset on the DAP based on the
parameters they enter but cannot make any modifications to the records. I am
the only one that can actually make changes to the records.
2) If a user goes in the DAP before I do I cannot make any changes to the
recordset I retrieve and they still cannot make any changes to the records
retrieved.
My question then is what in the world is going on here?! From what I know
mulitple users can go into the DAP and view and edit records. Maybe there
could be a problem if two users try to edit the same record at the same
specific time. I have both my BE and FE DBs set as "Shared" and "No Locks"
under the advanced settings tab. The shared parameter in my connection
string is set as SharedDenyNone. I don't know what else to do here, and I'm
starting to think that I'm beating a dead horse with a stick here.
Can anyone be so kind and explain to me how would the DAP work in a
muli-user environment and how I could make it work so that multiple user can
go in and edit records at the same time. They would not be the same records
as each user would have different records assigned to them for edit.
Any help with this would be much appreciated.