|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Shared Database!!Hi..
I need your help please... I have an access database (2002) in a server.. I want to make it accessible for some users I gave them the authority or permission.. but the problem is that if it is open by one user the others can't access it.. also.. can i open the report without opening the access .. or at least make the background invisible??
Show quote
"Engo" <E***@discussions.microsoft.com> wrote in message Engo,news:C5B36D97-F213-4794-902D-D0F4E3C53C6C@microsoft.com... > Hi.. > I need your help please... > > I have an access database (2002) in a server.. > I want to make it accessible for some users > I gave them the authority or permission.. > but the problem is that if it is open by one user the others can't access > it.. > > also.. > can i open the report without opening the access .. or at least make the > background invisible?? > Regarding your first question: Assuming all users have read/write permissions to the directory in which the database resides it sounds like the first user is opening the database exclusively. Make sure users do not have the rights to do this. Regarding your second question: What do you mean by "the background"? If you mean the database window you can turn this off under Tools > Startup > Untick "Display database window". If you mean the MS Access window it is possible to do this, but is rather more trouble than it is usually worth (in my opinion). Post back if you want me to detail this for you... Ed Metcalfe. have you split your database? The tables on the server and the
forms/queries/.... on eache computer. Show quote "Engo" wrote: > Hi.. > I need your help please... > > I have an access database (2002) in a server.. > I want to make it accessible for some users > I gave them the authority or permission.. > but the problem is that if it is open by one user the others can't access it.. > > also.. > can i open the report without opening the access .. or at least make the > background invisible?? > i am attempting to do the same thing with my db. my problem is with the
permissions. i can't figure out how to give people permission to access the db. at first, i was getting the same message as Engo that only one person can open the db at a time. now i am getting a message as that says that someone else has "opened it exclusively..." there is no one else that has the db open and i tried taking the open/exclusive feature off of the users. when the error message appears, it displays the path on the server to where the backend of the db is, not where the front end is (where i am accessing it). am i missing something??? i have tried splitting the db and replicating the db to be able to share the db, and nothing that i have tried has worked. i am not an expert on access, and i think that i amy be attempting a task above my skill level, but i can't ask anyone at work for help. i heard that this place was a wealth of info with regards to finding info and troubleshooting. thanks in advance. Show quote "Eric Blitzer" wrote: > have you split your database? The tables on the server and the > forms/queries/.... on eache computer. > > "Engo" wrote: > > > Hi.. > > I need your help please... > > > > I have an access database (2002) in a server.. > > I want to make it accessible for some users > > I gave them the authority or permission.. > > but the problem is that if it is open by one user the others can't access it.. > > > > also.. > > can i open the report without opening the access .. or at least make the > > background invisible?? > > This is a Windows permission issue. All users of the database need modify permissions on the folder where the backend is located. This is so the associated ldb file can be created/modified by users. Without the proper permissions, the first person in can't create the ldb and the file is opened exclusively.
-- Show quoteJoan Wild Microsoft Access MVP "quonzilla" <quonzi***@discussions.microsoft.com> wrote in message news:4CDA8FA9-DF40-474F-8374-2FB126C30342@microsoft.com... >i am attempting to do the same thing with my db. my problem is with the > permissions. i can't figure out how to give people permission to access the > db. at first, i was getting the same message as Engo that only one person > can open the db at a time. > now i am getting a message as that says that someone else has "opened it > exclusively..." there is no one else that has the db open and i tried taking > the open/exclusive feature off of the users. when the error message appears, > it displays the path on the server to where the backend of the db is, not > where the front end is (where i am accessing it). > > am i missing something??? > > i have tried splitting the db and replicating the db to be able to share the > db, and nothing that i have tried has worked. i am not an expert on access, > and i think that i amy be attempting a task above my skill level, but i can't > ask anyone at work for help. i heard that this place was a wealth of info > with regards to finding info and troubleshooting. thanks in advance. > > > > "Eric Blitzer" wrote: > >> have you split your database? The tables on the server and the >> forms/queries/.... on eache computer. >> >> "Engo" wrote: >> >> > Hi.. >> > I need your help please... >> > >> > I have an access database (2002) in a server.. >> > I want to make it accessible for some users >> > I gave them the authority or permission.. >> > but the problem is that if it is open by one user the others can't access it.. >> > >> > also.. >> > can i open the report without opening the access .. or at least make the >> > background invisible?? >> > Thanks all. I was able to get the db working. I split the db (fe and be),
put them in a shared folder on our server, sent test users a copy of the fe to save to their local machines, and viola - it worked. I was even able to access it remotely from my lap top using a fe db, t-mobile aircard and a vpn. It is slow, but it works. This is exactly what I designed and intended the usage for. It also allows multiple users to input and access data simultaneously and generates reports in real time. Thanks to all that contributed. You guys are great. Rob Q Show quote "Joan Wild" wrote: > This is a Windows permission issue. All users of the database need modify permissions on the folder where the backend is located. This is so the associated ldb file can be created/modified by users. Without the proper permissions, the first person in can't create the ldb and the file is opened exclusively. > > -- > Joan Wild > Microsoft Access MVP > "quonzilla" <quonzi***@discussions.microsoft.com> wrote in message news:4CDA8FA9-DF40-474F-8374-2FB126C30342@microsoft.com... > >i am attempting to do the same thing with my db. my problem is with the > > permissions. i can't figure out how to give people permission to access the > > db. at first, i was getting the same message as Engo that only one person > > can open the db at a time. > > now i am getting a message as that says that someone else has "opened it > > exclusively..." there is no one else that has the db open and i tried taking > > the open/exclusive feature off of the users. when the error message appears, > > it displays the path on the server to where the backend of the db is, not > > where the front end is (where i am accessing it). > > > > am i missing something??? > > > > i have tried splitting the db and replicating the db to be able to share the > > db, and nothing that i have tried has worked. i am not an expert on access, > > and i think that i amy be attempting a task above my skill level, but i can't > > ask anyone at work for help. i heard that this place was a wealth of info > > with regards to finding info and troubleshooting. thanks in advance. > > > > > > > > "Eric Blitzer" wrote: > > > >> have you split your database? The tables on the server and the > >> forms/queries/.... on eache computer. > >> > >> "Engo" wrote: > >> > >> > Hi.. > >> > I need your help please... > >> > > >> > I have an access database (2002) in a server.. > >> > I want to make it accessible for some users > >> > I gave them the authority or permission.. > >> > but the problem is that if it is open by one user the others can't access it.. > >> > > >> > also.. > >> > can i open the report without opening the access .. or at least make the > >> > background invisible?? > >> > > keeping MDB secure is impossible
move to Access Data Projects Show quote "Engo" <E***@discussions.microsoft.com> wrote in message news:C5B36D97-F213-4794-902D-D0F4E3C53C6C@microsoft.com... > Hi.. > I need your help please... > > I have an access database (2002) in a server.. > I want to make it accessible for some users > I gave them the authority or permission.. > but the problem is that if it is open by one user the others can't access it.. > > also.. > can i open the report without opening the access .. or at least make the > background invisible?? >  |
|||||||||||||||||||||||
Other interesting topics