Shared DB

May 13, 2005

can anybody tell me why my colleague cannot add records to a DB I set up on my pc.

i have a DB with 3 tables linked (all one-to-one).

i can add records into it fine on my pc but when my colleague tries on her pc it allows her to enter data but when it comes to moving onto the next record it wont allow her to save the record.

To explain further. there are 3 tables as mentioned before. lets call them Table 1, Table 2 and Table 3. When my colleague uses the form to add a record it wont let her save it as it says a related record is needed in table 2.

any ideas why it works perfectly on mine but not on hers?

View Replies


ADVERTISEMENT

Db Shared Is Read Only!

Jan 2, 2007

Hi, i've a problem

there's a database in a shared folder (two pc connected NOT in a LAN).
the database is on the pc called "A", i'm in the other (called "B") ; i open the db and i've a message "read only". so i cannot enter, modify, ...
how can i give to the pc "B" the possibilty to modifiy the db??

thx in advance

bye

View 5 Replies View Related

Shared Drive

Oct 23, 2007

Hello,

I have an exrternal shared drive "E:"where I put my be files (which are constantly accessed by users with fe's from different terminals). Everytime
I reboot the computer that I am working on (where the external drive is), I have to set up the permissions of the shared drive "E:" all over again, otherwise other computers have no access to E. Is there a way that I could
fix this and not having to set permissions every time I reboot my computer?
For some reason, the permissions are lost.

View 4 Replies View Related

Shared Database

Nov 2, 2007

Hello,

Im having some problems sharing a database. I need multiple users to be able to open the database at the same time. I have check TOOLS - OPTIONS - ADVANCED and my option is set to shared, but for some reason it will still only allow 1 user to open it at a time.
Does anyone know why this could be?

Thanks

View 2 Replies View Related

File Already In Use?? It's A Shared DB!!

Mar 14, 2008

Hey folks, me again...

I have a big problem and it's stopping us from rolling out the db to our call-center... cliff-notes at the end...

I have a database that tracks customer calls.
The db files are located on the network in a folder that everybody has access to.

The db is arranged as such:
A backend that holds all the tables.
A front-end for Customer Service Reps with tables that are linked from the backend
A front end for Managers linked in the same way.
And a front end for our corporate folks which is also linked in the same way.

I've tried replicating, making mde's and creating a shortcut on each CSR's desktop. I've also made sure that I use the UNC to link the tables. I've also made sure the db's are shared (I think)

Cliff-notes:
when I have the front-end open on my desktop, and somebody else tries to open it, they get an error. "The file is already in use"

Am I doing something wrong Or am I missing some type of setting??

View 14 Replies View Related

Access File Shared

Nov 9, 2005

Can an Access being shared and by multiple users concurrently?

View 1 Replies View Related

Shared Database Problems

Dec 19, 2006

hello everyone... with the help i have gotten from this site I embarked upon producing a online booking databse for my workplace ...

since the work enjoys having an intranet i simply placed the database in a shared folder and things have worked great for nearly a year ...

Ive tinkered and modified and everyone is happy till today ....


while an administrator was deleting a booking things went haywire ....

a message came up about couldnt delete because someone else was deleting ...things froze and a message about path problems came on the screen..

the only thing we could do was delete the database and replace it with the backup copy we have.... everything worked great for an hour or so and then things went wonky again with same error messages...

also I noticed that the database grew in size from 1.6md to 2.5 mb ....

again I replaced it with the backup copy and did a repair and compress ..and it seems to be ok ..

but im dreading tommorrw since i anticpate it happening again ..any suggestions appreciated... ps ..the databse is a booking form for booking ict suites in a school and I am the schools technician

cheers

harry

View 14 Replies View Related

Shared Folder Problems

Feb 1, 2007

I'm currently having problems with splitting my database.

The situation as present it:

- I have a shared folder on my laptop, to which i have given full permission rights to a collegue, in this folder is the backend of the db which i split from a database also sat in the shared folder

- I can then go to the front end of my database either on my desktop or shared folder and update tables

- However, this is where the problems start. The copy of the front end that my collegue has (an exact replica of mine) cant access or open any tables. Even if he opens the exact front end that I'm successful with in the shared folder. The following error message appears

"Could not find the file 'D:Testdb_be.mdb'"

the D drive on my computer is where the shared folder 'test' is stored.

Any hints or advice on why this isnt working?

Thanks in anticipation

Ross

View 10 Replies View Related

Shared And Exclusive Databases

Mar 6, 2008

I was just wondering what the drawbacks for using Shared and exclusive databases.
id like to create a shared database but has anyone come across any problems?

what happens when 2 people at the same time access the same row and save at the same time? is the first persons work get overwritten?

View 3 Replies View Related

Different Paths For Shared Drive

Feb 2, 2006

Hello all:

I have the following code to retrieve doucments:

strPath = "G:CorpCustomer Files"

Application.FollowHyperlink strPath & "" & textbox1 & "-" & textbox2 & ".doc"

This works fine from my computer because the shared drive on my computer is saved on the G drive.

I tried using the code from a coworker's computer, but got an error because her shared drive is : "X:CorpCustomer Files"

Basically anyone can access the Corp server through any drive depends on how it was mapped.

How do I get around this so that it works from any computer as long as the user has the Corp share drive?

Thanks much.

View 5 Replies View Related

Securing A Shared Database

Jul 17, 2007

Have created a database that will be placed on a shared drive, giving access to others to add, delete, modify records. That aspect of it is fine -- but how to I prevent someone from deleting a field?

View 2 Replies View Related

Deleting From A Table In A 'shared Environment

Oct 4, 2005

Hi,
Im working on a database that has to be shared by 3 or 4 users. In on of the actions that the database performs, it has to delete records from a table first.
When sharing the database, it always asks the users (using access viewer) whether 'they are sure that the want to delete the records'. Does this always happen? And why? How can I get rid of it? Would it matter if I change it from a table to a query?

Thanx,
Stacey

View 5 Replies View Related

DB Security On A Shared Networked Drive

Jan 31, 2006

I've created a database on put it on a shared network drive. I have several people who will need to use this database but I dont want some of them to be able to edit the database in anyway.

Ive tried creating individual user accounts for the database but I don't think I'm grasping how the security works.

When on my machine I'm promted for a username and password but when on someone elses machine they can open up the database with full access.

How do i create individual user security accounts on a database I want to share on a network drive?

View 4 Replies View Related

How To Link 4 Databases To Shared Tables?

May 19, 2006

I have 4 databases that share 3 tables.

Each database is used for different purposes and other tables which do not relate to the other databases.

My question is: how do I set up the back ends so each database can retrieve and enter data into the 3 shared tables without conflicts??

I know how to split each of the databases to front and back ends but how would I link them all to the 3 tables they share? Should I create one back end with only the 3 shared tables and link the separate back ends for each database???

Any help much appreciated!

View 4 Replies View Related

Shared MDE Gives Exclusive Access Warning

Jul 3, 2007

We have shared MDE, when second user opens gets message: [B]You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.
The message seems to repeat for each compiled object (Form, Report and Module).
Helptext states occurs when in design mode - but not in design mode!
Any ideas as to how we can suppress the warning?

View 6 Replies View Related

Shared Access To A Database Problem

Dec 27, 2007

I have a problem related to shared access to a MDB file:

- I designed an Acccess Database and need shared access to everybody for read forms , and also I need (just for me) to do some "real time" modifications in the tables. I work in a huge company and cannot make changes in the Access of each user, just can work on my laptop. The file is placed in a shared folder.

- I can assign policies to the folders (for example I made a read only folder, with admin rights for me, but when somebody opened the mdb, I got an 'open only advice, and couldn't update any table; It's curious because the users coudn't generate the LDB file but still the access denied me the chance to modify any table when the file is opened by anybody).

- I tried playing with tools-security, but I cannot change every user settings, it didn't helped me.

I've been looking for related links to this problem but still I couldn't solve it. And at this point I wonder if it's just possible to do that?

Thank you very much

View 1 Replies View Related

Shared Access To DB - Anyway To Refresh Automatically?

Apr 28, 2005

I'm trying to get one database to be shared by multiple users so that the file on the server is always updated as others add new records....in real time. Is there a way for this to work? What settings will I need?

View 2 Replies View Related

Command Button Not Working In Shared DB

Jan 7, 2008

I just created my very first db... I used the wizzard to create it most of it, including command buttons that permit you to move from the one form to another form/report. I saved the db to a shared drive (two people total accessing/updating it) only to find that the command buttons don't work for her. I created the db in 2003, but she has 2007. If I upgrade to 2007 and convert the db, could this solve the problem? THANKS!!

View 5 Replies View Related

Users Cannot Access Data Entered By Others In A Shared BE!!!

Nov 27, 2007

Hi folks,

I've a BE/FE database where the BE is on the server and the FE on different PCs. I have got linked tables in my FE and the connection between them and the BE is correct; however, users cannot view data entered by others. They can only view data entered by themselves!!

I'm not sure if the records are getting locked that's why they can't see others inputs.


Any help will be very much appreciated,
B

View 5 Replies View Related

Passing Variables Between Forms In Shared Mode

Sep 28, 2006

Before I go any further w/this current application, I want to make sure this will work.

I have an access database w/a few forms that will sit on a shared drive on a network. Each user will also have their own username and password because each user will have a certain level of access to what they are allowed to see. The problem I am facing is that if I put the users ID into the global variables module, and two users log on at the same time, then access seems to somehow use both of the IDs when running queries. This makes sense that all uses can see it, since it's Global... but I need a way for simultaneous users to have a persistant unique id so I can query data that's only meant for them. I found this example of code that might remedy the situation by passing variables between the forms.

Call the code below in frmOne to pass the variable.

DoCmd.OpenForm "frmTwo", acNormal, , , , acWindowNormal, "Count=2"


Call the code below in frmTwo to get the variable.

Dim i as Integer
i = CInt(GetTagFromArg(Me.OpenArgs, "Count" ))



Will I end up w/the same result? Will all users be able to see this variable as well?

View 6 Replies View Related

Forms :: Cascading Combo Box On A Shared Subform

May 30, 2013

I have a subform that I use on two parent forms. The subform has a cascading combo box. The LocationID field gets filtered after CompanyID (named: cboCompanies) is updated. The problem is that I can only get the combo box to work on one form (Contacts_All). When I open the second form (Contacts_Clients), it asks for the Parameter Value.I am entering this into the criteria for the LocationID field:

[Forms]![Contacts_All]![SUBFRMContactsCompanies]![cboCompanies] Or [Forms]![Contacts_Clients]![SUBFRMContactsCompanies]![cboCompanies]

So, the "Or" is not working.Do I need to make a separate subform for each parent form or is there some way to get this working? I already feel as if I am managing way too many forms and need to simplify.

View 1 Replies View Related

Modules & VBA :: Subquery Where Subform Is Shared Between 2 Forms

Mar 28, 2015

There are 2 mainforms and both of them share a subform. This subform is an add subform and I want the mainform to be refreshed after the data entry.Prior to the sharing, I had it coded it the way below and it works fine

Code:
Forms!frmMainformnoproc!frmActiveTasks.Requery

How would I recode this requery when it shared between 2 forms. frmMainformnoproc is the name of one of the main forms.The code above was present after an update was completed in the subform. Maybe I should be doing it after I close the subform and refresh the mainform. Based on that line of thinking I tried to add the code in the Activate event / Got Focus event of the mainform but the form did not get refreshed.

View 13 Replies View Related

General :: Accessing Shared Folder In Different Machine

Aug 11, 2015

I am facing a issue in accessing my db file in server. I just splitted my database into front end and back end , placed in a local folder which is shared in network . I opened the files in network from my colleague machine and everything was working fine yesterday .. but right now i am getting error like "the network path is not found " 0X80070035 which tells that check whether the source machines is able to accept file sharing ..I googled and tried 2 solutions Like turning off windows firewall and enabling NetBIOS Over TCP/IP..

View 10 Replies View Related

General :: Security For Database On Shared Drive

Oct 3, 2013

I need securing an Access database. I am about to put the database on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information (along with being able to view everything like forms and reports), and my boss to ONLY be able to view everything (form/report wise).

I found this post [URL] .... about how to secure a database. I spent all day doing it, but it didn't work at all! I just got a bunch of errors whenever I tried to do anything, so I deleted the database and re-used an earlier version.

View 6 Replies View Related

Forms :: Split Database In A Shared Folder

Nov 9, 2014

I have recently been experimenting with adding an Access database to a shared folder (in a network HomeGroup) and have it working on two networked PCs. Then tried the same with the database split but I get a path error on the PC joined to the HomeGroup (where the database resides) whenever the backend (tables) are accessed by a form or from the Tables listing. If I however open the backend file directly from the file directory, the tables all open as expected.

The path stated as being invalid in the error message starts with "C:Usersetc..... instead of LAF-PCUsersetc..... so it looks (to me at least) that it is attempting to load the file from the local hard drive rather than the host computer.

Why a split database works differently in this situation than a non-split.

View 13 Replies View Related

Shared Drive Path To Save Attachments

Aug 27, 2014

Saving attachments to shared drive.

I have a order database and i receive invoices from suppliers and there are different users updating the records. I want to save the invoices in shared folder so all of the users can view/access the invoices.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved