Forum Discussion
Two users at once
Email? Internal users are one thing. External would be another. I'm assuming both of you are in the same building....
Here's a screenshot from my little home network of two computers. It shows the actual UNC from one to a folder on the other computer, starting at the "Network" and selecting the second computer, then drilling down its folders to the one I want.
Here's that same location mapped as "G" (for this illustration only).
Put the backend containing the tables on the network in a shared folder.
Make sure you update the linked table locations in the frontend.
Then give EACH user their own copy of the frontend database.
This needs to be placed on their own workstation hard drive ...NOT on the network
PMFJI. Due to time zone differences, Colin may be offline at the moment.
If you are not able to see changes in the DATA and you believe you should be using the same linked tables in two different FE files, the problem could be down to a few different things.
One, are you sure the tables in question are actually in a single accdb on a network in a shared folder? There should be one and only one shared accdb BE. All accdb FEs link to the tables in that one accdb.
Is it possible that the tables in question remain in one or both of the accdb FEs? I.e. is one or both of the accdbs still using local tables, not the linked tables?
Is it possible that there are also multiple accdb BE files? Is one person's FE could be linked to one accdb BE while another person's accdb FE is linked to a different accdb BE? Low likelihood, of course, but strange things happen.
Is there an issue with form's refreshing? In other words, if the second user has a form open bound to a table, the new or changed records you enter in a different FE won't show up in that open form until it is refreshed (or requeried).
If one of those things isn't behind this problem, further digging is called for.- Thank you for your response I think the problem was me linking it with the wrong back end actually. Now that I try to link it on my computer with the back end and send the FE via email to the other computer it’s giving me the error message “make sure you’re on the server where the file resides” I made it open to edit by anyone.. if I figure one thing out the other is an issue
Progress!
Okay, where does the BE accdb reside? On a LAN I presume? And both you and the other user have permissions to the folder on the LAN where it is located? So far so good.
When you link the FE to that working, or production, copy of the BE accdb, make sure you use the full UNC path, not a mapped drive. There are advantages to mapped drives, but they are not always the same for different people. For example, you may map \\MyCompanyServer\DatabaseApplications\ as "M:\" while someone else uses "N:\" for that same fileshare. If you link the accdb FE to M:\MyRelationalDatabaseApplicationBE.accdb, YOU can use it, but it will fail for the user who would have to have it as N:\MyRelationalDatabaseApplicationBE.accdbTherefore, the recommendation is to always use the full UNC path for linked accdb be files.
\\MyCompanyServer\DatabaseApplications\MyRelationalDatabaseApplicationBE.accdb
That way both of you are linking to the same pathway to the same BE.