Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2006-06-23 : 22:53:35
|
| The question is about an application design.This is going to be a win form client server app. Access Adp or run-time will be embedded through Access Object Library (MSACC.OLB). the front end of Access will be Reports only. All the forms and code modules will be in vb.net 1.1.There reports are less product list or sales by region types, but more of Invoice/Credit Memo types.The reason for using ADP/Run-time is to avoid mdb’s license requirement. The reason of using access reports instead of Crystal or SQL Reporting Services is that there are a large number of existing access reports.I have inherited a server vb6 app that has access mdb as its reporting engine.My concern areas are:1) Dose access object library has the same power controlling ADP as controlling MDB?2) If the reports changes as the business needs evolved, can I import the replacement reports (with the same name) , but without recompiling the executable? My guess is these reports have to be late binding, but I doubt this is possible.Anybody has either used or seen these combinations in production?Any good recourse will be greatly appreciated!Thanks! |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-06-28 : 11:49:40
|
| The answer is No!I found out 2003 Access object library (MSACC.olb) has limited capability of controling/manupulating .ADP. And there isn't any good resourece on the subject. |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-06-28 : 13:14:59
|
| Depending on the version of Access you have, there is a runtime that you can distribute. I think you need the developer edition or something like that. Do some googling or check the MS web site. It works quite well -- I've used the runtime for Access 2000 in the past and it works like a charm. |
|
|
|
|
|
|
Is this (vb.net + Access ADP) a sound design?