Split Access Database Optimizing Help
I have created a Access 07 database that we store employee info along with vaction time requests. The db was intended for maybe a max of 2 people from the resource management team to be in it at a time but was just told that now I have to make it available for the employee's managers. It could be out company network but working in Access over a network is a nightmare when I split it.
I thought about creating a front end for the managers that would pull only their employee info into a temp local table. Once they were done working in records some code would just update the modified records but I think I am making it sound much easier than it really is.
More than anything I am looking for any resources out there that might be able to help with the network issue such as optimizing tips or examples that anyone might know about. At this point I have a split database and I am striping is bare to make it as lean as possible but it just doesnt look like its helping.
thank you,
I thought about creating a front end for the managers that would pull only their employee info into a temp local table. Once they were done working in records some code would just update the modified records but I think I am making it sound much easier than it really is.
More than anything I am looking for any resources out there that might be able to help with the network issue such as optimizing tips or examples that anyone might know about. At this point I have a split database and I am striping is bare to make it as lean as possible but it just doesnt look like its helping.
thank you,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I guess you mean a pseudo disconnected scheme ?
"but working in Access over a network is a nightmare when I split it. "
There are remedies for this, some of which are eluded to in Luke's KB.
Here at work, I have 38 dbs in use by a combination of 160+ users over a 1Gb Fiber Optic WAN. So ... trust me, it can be done :-)
For the dbs that have a large number (say >20) simultaneous users, I do employ a pseudo disconnected scheme - instead of Linked tables. And I also employ the Persistent Connection mentioned in Luke's KB.
mx
"but working in Access over a network is a nightmare when I split it. "
There are remedies for this, some of which are eluded to in Luke's KB.
Here at work, I have 38 dbs in use by a combination of 160+ users over a 1Gb Fiber Optic WAN. So ... trust me, it can be done :-)
For the dbs that have a large number (say >20) simultaneous users, I do employ a pseudo disconnected scheme - instead of Linked tables. And I also employ the Persistent Connection mentioned in Luke's KB.
mx
ASKER
I think I might be missing something. The article says that it can be used for multiple backend dbs. Is the person assuming that the front end db may have multiple connections to backends? So does the code go into each frontend or each backend?
Were you able to understand it better than I am DatabaseMX?
Were you able to understand it better than I am DatabaseMX?
ASKER
I think the part that is really confusing me is when it says
"For instance, if you have a form that controls the application and remains open during the entire time the user is using your database, add the code to the OnOpen and OnClose events."
i dont really have just one form open the whole time. Seems to me like that would be a cluster and make it confusing for the user. "Controls the application?" Could he be referring to like a "HOME" form or something? I dont know.
"For instance, if you have a form that controls the application and remains open during the entire time the user is using your database, add the code to the OnOpen and OnClose events."
i dont really have just one form open the whole time. Seems to me like that would be a cluster and make it confusing for the user. "Controls the application?" Could he be referring to like a "HOME" form or something? I dont know.
"Is the person assuming that the front end db may have multiple connections to backends?"
Yes ... the code takes that into account.
So does the code go into each frontend or each backend?
FE.
I will be back on line later tonight ... and we can drill down on it.
mx
Yes ... the code takes that into account.
So does the code go into each frontend or each backend?
FE.
I will be back on line later tonight ... and we can drill down on it.
mx
Have you ruled out a SQL back end?
And possibly doing the initial split using Access and then later building out an internal intranet website for it?
And possibly doing the initial split using Access and then later building out an internal intranet website for it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jim, I have and a SQL server would have been my first choice although we are not allowed to maintain our own. This is a departmental project and I've been given a stick and a rock to create fire.
Scott, most of the managers have dockable laptops that they use in the office. When they are home they use VPN. Now that I know has cause a ton of issues in the past with corrupt files. That is a great idea about the hidden form so I am trying that now. You are right conflict resolution is not something I have the time for or the desire to take on.
Employees currently submit Infopath forms when requesting vaction time which then submits to the database. In order to limit the about of hands in the db I set up a Infopath form for the resource team to process the request. From there the record just sits there.
Where the managers play a role in the process is that they need the information to reconcile their employee timesheets. For example once an entry has been recorded then they would check our HR system to see if the item is there and correct then add a check mark in our database to indicate that its out there. I tried to also create a Infopath form for them to do this but they complained about not being able to create custom filters among other things.
Scott, most of the managers have dockable laptops that they use in the office. When they are home they use VPN. Now that I know has cause a ton of issues in the past with corrupt files. That is a great idea about the hidden form so I am trying that now. You are right conflict resolution is not something I have the time for or the desire to take on.
Employees currently submit Infopath forms when requesting vaction time which then submits to the database. In order to limit the about of hands in the db I set up a Infopath form for the resource team to process the request. From there the record just sits there.
Where the managers play a role in the process is that they need the information to reconcile their employee timesheets. For example once an entry has been recorded then they would check our HR system to see if the item is there and correct then add a check mark in our database to indicate that its out there. I tried to also create a Infopath form for them to do this but they complained about not being able to create custom filters among other things.
ASKER
Thanks everyone for the help. I came up with an idea but I thought it would require another post. Here is the link to the new question. Any assistance with that question would be much appreciated. Link to New Question
ASKER