Here is my situation:
I work in a call center where sales data is tracked for two different teams on two different servers, each with their own database and front end. My agent activity reports are limited to the data for each individual server. Management would like a universal report. The database and front in are both in Access. One caveat is the information is mapped to same drive letter & file names but on two different servers. I don't want to combine the data into one database becuase that amount of data would take too much space. Can this be done in PHP to where the results would not take the literally 20 mintues for access to run a query? I do not know PHP but am willing to learn if I can accomplish this task. Is this something I can construct in a month or two, or is this advanced task? I think a web-based solution would be a great way to make sure everyone has a user-friendly interface and easy access to our information. Let me know what you think, or if there is a better solution.
Thanks,
Thomas
Need advice on making universal database solution
Moderator: General Moderators
http://adodb.sourceforge.net/ will do exactly what you need. It will allow you to connect to multiple database sources (of multiple types), and access the data in php to do with as you please.
I recently completed work connecting to access files via odbc using adodb. Of course, you could also simply use the native php odbc calls.
I recently completed work connecting to access files via odbc using adodb. Of course, you could also simply use the native php odbc calls.
-
Simulacrum
- Forum Newbie
- Posts: 13
- Joined: Wed Apr 13, 2005 11:58 pm
You could create linked tables in Access DB1 to Access DB2. That would then let you create Access Query objects that could span both databases.
The Access report builder is also pretty good.
At the very least you could offer a simple Access report to begin with, and then look at making this available through the web later.
I wouldn't advise doing everything in PHP, unless the report requirements are very simple.
The Access report builder is also pretty good.
At the very least you could offer a simple Access report to begin with, and then look at making this available through the web later.
I wouldn't advise doing everything in PHP, unless the report requirements are very simple.