.NET and Access

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi,

I work in a shop that has been getting by using Access 97
for a long time. Now that we are upgrading the server NT
4.0 to XP Professional (about time) we want to start
developing apps using .NET 2003. Can an app developed
using .NET open and print an Access report even though the
user does not have Access installed on their workstation?
Since we have tons of Access reports we would like to
still use these reports instead of having to redesign them
all using Crystal Reports.

Out of date programmer trying desperately to keep up with
the times..
 
While I must admit I don't know for certain, I'd be shocked if it was
possible.
 
..Net can open an Access report using automation but it cannot open it
without having not Access loaded on the machine. Any kind of attempt at
conversion to Crystal reports will be a study in complete frustration
because Crystal cannot begin to do most of the reporting that Access can.

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Don't know that particular product, but I somehow doubt that it'll be any
more able to do a complete job than any other of the products that purport
to be able to do such conversions.

There are simply too many diffferences in the controls available on Access
forms versus those available on VB (and VB.Net) forms.
 
Like Arvin said, you do need to have Access (or the Access run-time) on the computer.

For VB.NET, look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;317113.

For C# look at http://support.microsoft.com/default.aspx?scid=kb;en-us;317114.

There's also a bunch of Office/.NET info at http://msdn.microsoft.com/library/default.asp?url=/code/list/vsforoffice.asp and a
presentation at http://www.microsoft.com/seminar/shared/asp/view.asp?url=/seminar/en/20030801DEVT1_75/manifest.xml.

Even though you say you are out-of-date, I'm surprised you don't know about the Knowledge Base and MSDN. To get "up-to-date," go to
http://support.microsoft.com/default.aspx?scid=FH;EN-US;KBHOWTO and http://msdn.microsoft.com. Start looking for Office and .NET
articles.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top