Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / March 2007

Tip: Looking for answers? Try searching our database.

Access databases with Business O    bject’s Dashboard and Data Integ    ra

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EllenM - 21 Mar 2007 15:45 GMT
Hello,


Perhaps I should cut to the chase and ask my question followed by a bit of
background.

Does anyone know if you can use an Access 2000 database with Business
Object’s Dashboard and Data Integrator?

Our company hosts several Microsoft Access databases used for tracking our
projects throughout the year. As data expands, manageability has become labor
intensive. We've been discussing for well over a year the prospects of using  
a more user-friendly graphical interface with the help of a web application
know as Dashboard Manager (a component of Business Objects). Through careful
research, we have found that we need another component of the Business
Objects technology,  Data Integrator. This would serve as the bridge for
joining all of  our Access databases at the backend to the user-friendly
Dashboard at the front-end.


Here’s the question again (more expanded) : Does anyone know if you can use
an Access 2000 database as a data source for doing queries that would then
get packaged and formatted properly with the “Data Integrator” for delivery
to the Dashboard graphical environment?


We have read (or so it has been implied) that Access has to be converted to
a true Microsoft SQL Server in order to take advantage of the technology. Is
that true and how easy would this be to achieve if possible?

Business Object’s flash tutorials are provided below for more background.

http://www.businessobjects.com/global/flash/products/xi_tour/index.asp

Help is appreciated as always,


Thanks,
Ellen
Pat Hartman (MVP) - 21 Mar 2007 18:45 GMT
I can't answer your question specifically but I can suggest that it is
pretty easy to "upsize" your existing .mdb to link to SQL Server tables
rather than Jet tables.  I presume that that would solve your problem.  you
can keep your current application working against the SQL Server back end
plus add the BO functionality for reporting.  Don't go the .adp route which
is considerably more work and .adp's will not necessarily be supported in
future versions of Access (past 2007).

> Hello,
>
[quoted text clipped - 39 lines]
> Thanks,
> Ellen
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.