|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Access Networking & Security Issue.I've got an Access 2007 database that we've been trying to get running on a
network environment. Our db is located on a network file server (nas device). We share that same db with 3 users on the network. They all want to be able to keep the db open. For some reason they cannot run or open when the file is opened by more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista Ultimate. It seems like this was possible in the past now we can't.
Show quote
Hide quote
"Zacharia" <Zacha***@discussions.microsoft.com> wrote in message Don't share database files. Split the app and give each user their own news:7E6CAB69-0B12-4CDB-8F80-88409B1ED3F8@microsoft.com... > I've got an Access 2007 database that we've been trying to get running on > a > network environment. > > Our db is located on a network file server (nas device). We share that > same > db with 3 users on the network. They all want to be able to keep the db > open. For some reason they cannot run or open when the file is opened by > more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista > Ultimate. > > It seems like this was possible in the past now we can't. > > > front end file. More info here: http://www.granite.ab.ca/access/splitapp/index.htm Keith. www.keithwilby.co.uk Some NAS devices don't support that.
(david) Show quoteHide quote "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message news:7E6CAB69-0B12-4CDB-8F80-88409B1ED3F8@microsoft.com... > I've got an Access 2007 database that we've been trying to get running on > a > network environment. > > Our db is located on a network file server (nas device). We share that > same > db with 3 users on the network. They all want to be able to keep the db > open. For some reason they cannot run or open when the file is opened by > more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista > Ultimate. > > It seems like this was possible in the past now we can't. > > > I've reviewed both posts. I'm still a bit confused. It seems like we could do
this till Vista came around. ANyway. Putting VISTA aside. SInce the share we wanting to do would be on 2 - 3 XP Pro workstations. The same file would reside on our SNAP Server 1100 model. THe Access database would be opened by one user and also open/available to be opened by a second or third user with "View" only rights. SInce it's open on the first computer. However, now we can't seem to open the file on the 2nd or 3rd computer. WE get a access/share error. Show quoteHide quote "david" wrote: > Some NAS devices don't support that. > > (david) > > "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message > news:7E6CAB69-0B12-4CDB-8F80-88409B1ED3F8@microsoft.com... > > I've got an Access 2007 database that we've been trying to get running on > > a > > network environment. > > > > Our db is located on a network file server (nas device). We share that > > same > > db with 3 users on the network. They all want to be able to keep the db > > open. For some reason they cannot run or open when the file is opened by > > more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista > > Ultimate. > > > > It seems like this was possible in the past now we can't. > > > > > > > > > You can't normally have a user with "View" only rights.
Unless all the users are "View" only, all the users need to be able to create/read/write a shared lock file in the same folder as the database. If the View only user can't write locks on the lock file, the View only user can't share the database file with a R/W user. (david) Show quoteHide quote "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message news:039E09DA-B03F-4578-9A45-C933A471D863@microsoft.com... > I've reviewed both posts. I'm still a bit confused. It seems like we could > do > this till Vista came around. ANyway. Putting VISTA aside. SInce the share > we > wanting to do would be on 2 - 3 XP Pro workstations. The same file would > reside on our SNAP Server 1100 model. > THe Access database would be opened by one user and also open/available to > be opened by a second or third user with "View" only rights. SInce it's > open > on the first computer. However, now we can't seem to open the file on the > 2nd or 3rd computer. WE get a access/share error. > > > > "david" wrote: > >> Some NAS devices don't support that. >> >> (david) >> >> "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message >> news:7E6CAB69-0B12-4CDB-8F80-88409B1ED3F8@microsoft.com... >> > I've got an Access 2007 database that we've been trying to get running >> > on >> > a >> > network environment. >> > >> > Our db is located on a network file server (nas device). We share that >> > same >> > db with 3 users on the network. They all want to be able to keep the >> > db >> > open. For some reason they cannot run or open when the file is opened >> > by >> > more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista >> > Ultimate. >> > >> > It seems like this was possible in the past now we can't. >> > >> > >> > >> >> >> Well I think this has gone to an area that I didn't intend to.
To be clear again. I don't think this is a user permission issue. All users have Read and Write. As a matter of fact the users who access this database are all Administrators. Once again this is the issue I'm needing help with: The MS Access 2007 database will only allow one person to look/work at the database at a time. User 1 was in it and User 2 tried to just access it to look at something and it wouldn’t open. (the file is open on User 1's workstation) Is there any way for our database to be available so that both can be in at the same time. (one read only is fine) We have always done this in the past. Show quoteHide quote "david" wrote: > You can't normally have a user with "View" only rights. > > Unless all the users are "View" only, all the users need > to be able to create/read/write a shared lock file in the > same folder as the database. > > If the View only user can't write locks on the lock file, > the View only user can't share the database file with a > R/W user. > > (david) > > "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message > news:039E09DA-B03F-4578-9A45-C933A471D863@microsoft.com... > > I've reviewed both posts. I'm still a bit confused. It seems like we could > > do > > this till Vista came around. ANyway. Putting VISTA aside. SInce the share > > we > > wanting to do would be on 2 - 3 XP Pro workstations. The same file would > > reside on our SNAP Server 1100 model. > > THe Access database would be opened by one user and also open/available to > > be opened by a second or third user with "View" only rights. SInce it's > > open > > on the first computer. However, now we can't seem to open the file on the > > 2nd or 3rd computer. WE get a access/share error. > > > > > > > > "david" wrote: > > > >> Some NAS devices don't support that. > >> > >> (david) > >> > >> "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message > >> news:7E6CAB69-0B12-4CDB-8F80-88409B1ED3F8@microsoft.com... > >> > I've got an Access 2007 database that we've been trying to get running > >> > on > >> > a > >> > network environment. > >> > > >> > Our db is located on a network file server (nas device). We share that > >> > same > >> > db with 3 users on the network. They all want to be able to keep the > >> > db > >> > open. For some reason they cannot run or open when the file is opened > >> > by > >> > more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista > >> > Ultimate. > >> > > >> > It seems like this was possible in the past now we can't. > >> > > >> > > >> > > >> > >> > >> > > > If you have set Access to Open Exclusive, it will do that.
Otherwise, this is a file permission issue, or a NAS issue. It may be a Vista issue, if Vista has implemented a fix for a common NAS fault to prevent data corruption (this is possible). It may be an obscure network error or network configuration error. (david) Show quoteHide quote "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message news:8785338A-E81F-416F-8910-DFF69C6F6506@microsoft.com... > Well I think this has gone to an area that I didn't intend to. > To be clear again. I don't think this is a user permission issue. All > users have Read and Write. As a matter of fact the users who access this > database are all Administrators. > > Once again this is the issue I'm needing help with: > The MS Access 2007 database will only allow one person to look/work at the > database at a time. User 1 was in it and User 2 tried to just access it to > look at something and it wouldn't open. (the file is open on User 1's > workstation) > > Is there any way for our database to be available so that both can be in > at > the same time. (one read only is fine) > We have always done this in the past. > > > "david" wrote: > >> You can't normally have a user with "View" only rights. >> >> Unless all the users are "View" only, all the users need >> to be able to create/read/write a shared lock file in the >> same folder as the database. >> >> If the View only user can't write locks on the lock file, >> the View only user can't share the database file with a >> R/W user. >> >> (david) >> >> "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message >> news:039E09DA-B03F-4578-9A45-C933A471D863@microsoft.com... >> > I've reviewed both posts. I'm still a bit confused. It seems like we >> > could >> > do >> > this till Vista came around. ANyway. Putting VISTA aside. SInce the >> > share >> > we >> > wanting to do would be on 2 - 3 XP Pro workstations. The same file >> > would >> > reside on our SNAP Server 1100 model. >> > THe Access database would be opened by one user and also open/available >> > to >> > be opened by a second or third user with "View" only rights. SInce >> > it's >> > open >> > on the first computer. However, now we can't seem to open the file on >> > the >> > 2nd or 3rd computer. WE get a access/share error. >> > >> > >> > >> > "david" wrote: >> > >> >> Some NAS devices don't support that. >> >> >> >> (david) >> >> >> >> "Zacharia" <Zacha***@discussions.microsoft.com> wrote in message >> >> news:7E6CAB69-0B12-4CDB-8F80-88409B1ED3F8@microsoft.com... >> >> > I've got an Access 2007 database that we've been trying to get >> >> > running >> >> > on >> >> > a >> >> > network environment. >> >> > >> >> > Our db is located on a network file server (nas device). We share >> >> > that >> >> > same >> >> > db with 3 users on the network. They all want to be able to keep >> >> > the >> >> > db >> >> > open. For some reason they cannot run or open when the file is >> >> > opened >> >> > by >> >> > more than 1 user. 2 of them are on Windows XP Pro and 1 is on Vista >> >> > Ultimate. >> >> > >> >> > It seems like this was possible in the past now we can't. >> >> > >> >> > >> >> > >> >> >> >> >> >> >> >> >>  |
|||||||||||||||||||||||
Other interesting topics