jsawicki
asked on
Splitting an Access Database within a network
I work for a state agency which consists many file servers depending on an individual's location. Although all staff have access to all file servers if they know the path and how to map to it, each person is usually assigned to a specific server.
A database was recently created that IT staff would use in updating computer equipment during a refresh. The database was successfully split and the front ends were placed in regional folders for IT staff to access. When staff assigned to a different file server than what this one is located on tried to access the front end, they received an error message stating the path was not found. They were however able to open the back end successfully which is on the same file server as the front end.
My question: Is this lack of access to the FE because their assigned file server is different than the file server the database is located on? If so, is there any sort of work around on this issue or setting modifications that can be made within access?
A database was recently created that IT staff would use in updating computer equipment during a refresh. The database was successfully split and the front ends were placed in regional folders for IT staff to access. When staff assigned to a different file server than what this one is located on tried to access the front end, they received an error message stating the path was not found. They were however able to open the back end successfully which is on the same file server as the front end.
My question: Is this lack of access to the FE because their assigned file server is different than the file server the database is located on? If so, is there any sort of work around on this issue or setting modifications that can be made within access?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
" If you are on a WAN, not a LAN, I encourage you to read the following article: http://www.kallal.ca/Wan/Wans.html"
Sorry ... but it CAN be done as you know. Albert is kind of living in the past with regards to what can be done, especially with today's systems and networks, His article gives the wrong impression in that context.
Sorry ... but it CAN be done as you know. Albert is kind of living in the past with regards to what can be done, especially with today's systems and networks, His article gives the wrong impression in that context.
Joe, you will note that I said "most likely have significant connection", not "you will have significant connection" problems.
I know Albert's article is quite a bit out of date, but it is still a good read for the uninitiated.
Yes, it can be done, and more and more so every day. But your situation, my friend, is still in the top 5% (wild ass guess) of connectivity. The vast majority of companies cannot come close the bandwidth you have available. ;-)
I know Albert's article is quite a bit out of date, but it is still a good read for the uninitiated.
Yes, it can be done, and more and more so every day. But your situation, my friend, is still in the top 5% (wild ass guess) of connectivity. The vast majority of companies cannot come close the bandwidth you have available. ;-)
" But your situation, my friend, is still in the top 5% (wild ass guess) of connectivity. "
Sorry, but I doubt that is the case.
"The vast majority of companies cannot come close the bandwidth you have available."
Do you have data to support that ?
Sorry, but I doubt that is the case.
"The vast majority of companies cannot come close the bandwidth you have available."
Do you have data to support that ?
Only anecdotally. I don't currently have any clients that operate a WAN. Most are small businesses operating on LANs.
We could take a poll on the Access experts discussion thread, but that wouldn't be very scientific. Would be interesting to see those numbers though.
We could take a poll on the Access experts discussion thread, but that wouldn't be very scientific. Would be interesting to see those numbers though.
"We could take a poll on the Access experts discussion thread, but that wouldn't be very scientific. "
Let's not bother, lol. We already know how that would turn out :-)
Anyway ...
mx
Let's not bother, lol. We already know how that would turn out :-)
Anyway ...
mx
I get it Joe, I just wish my day job was in an environment where:
1. Access is appreciated for its capabilities
2. I had the bandwidth for our remote sites (as much as 2500 miles) that you do.
Dale
1. Access is appreciated for its capabilities
2. I had the bandwidth for our remote sites (as much as 2500 miles) that you do.
Dale
Yeah, no kidding.
"Access is appreciated for its capabilities"
Thing is ... there are many Access developers who really don't know the full capability. Sadly, many are living in the past as to what could (or more like couldn't) be done in the 1990's and early 2000's. A LOT ... has changed since then. In many ways, Access has only been limited by the hardware/networks of a given time period.
I've offered many times for peeps to drop by and see what can ... be done.
"Access is appreciated for its capabilities"
Thing is ... there are many Access developers who really don't know the full capability. Sadly, many are living in the past as to what could (or more like couldn't) be done in the 1990's and early 2000's. A LOT ... has changed since then. In many ways, Access has only been limited by the hardware/networks of a given time period.
I've offered many times for peeps to drop by and see what can ... be done.
ASKER
While the question was pending i determined that cause for lack of access which was described in the best solution. Awarding Fyed the points since he attempted to assist me with the question and would have helped more if i required it.
Click the "Request Attention" hyperlink at the bottom right corner of your original question, then indicate that you would like to reopen the question so that you can correct you solution selection.