VB.NET Error .... details explained inside. HELP!!!

From: D P (donp_at_sns-nf.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 05:13:47 -0700

Hello everyone, I am new here and I hope I can get the help I need.

I will be as descriptive as possible!!

I have developed an app using VB.NET that requires making a connection
to an access DB that sits on the same machine in which the app is
running. First off, this works PERFECTLY on my PC, but not on the PC
where it will be running.

It needs to open the local database and generate a snapshot of the
report that is specified ( .... the report DOES exist in the DB by the
same name that is used in code).

Here is the code snippet....
(I am using Northwind.mdb as a test DB!!!)

=============================================

Dim oAccess As Access.Application
Dim sDBPath As String 'path to DB
Dim sReport As String

'Testing
sReport = "Summary of Sales by Year"

' Start a new instance of Access for Automation:
oAccess = New Access.Application

sDBPath = "C:\NorthWindODBC\NorthWind.mdb"

***** Error occurs here on OpenDatabase *****
oAccess.OpenCurrentDatabase(filepath:=sDBPath, Exclusive:=False)

oAccess.DoCmd.Minimize()

oAccess.Visible = False

'Output in snapshot format to a temp file

oAccess.DoCmd.OutputTo(Access.AcOutputObjectType.acOutputReport,
sReport, "Snapshot Format", "C:\NorthWindODBC\temp.snp", False)

'Quit access
oAccess.Quit()

'Free
oAccess = Nothing

==============================================

This works as I mentioned on my PC but not on the PC where it will be
running.

I have dloaded and installed the .NET Framework on the target PC,
installed the latest MDAC.

I have copied the exe and reference file dlls from the bin folder of my
project folder to the target PC ... nothing works. Even creating setup
and installing it.

My PC is Windows XP, and Target is Windows 2000!

The error I get is .....

system.nullreferenceexception: Object Reference not set to an instance
of an object

This error is occuring on the line I indicated above (***)

Any ideas?? Thanks in advance to anyone with any ideas on how to solve
this!

OH .... and I have set permissions and things like that on the DB itself
and the folder where it is located!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Need help with a VB.NET error ... please help! Details within
    ... Dim sReport As String ... I have dloaded and installed the .NET Framework on the target PC, ... I have copied the exe and reference file dlls from the bin folder of my ... and installing it. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Need help with a VB.NET error ... please help! Details within
    ... > Dim oAccess As Access.Application ... > I have dloaded and installed the .NET Framework on the target PC, ... > project folder to the target PC ... ... > and installing it. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: sql 2005 ctp install didnt go so well
    ... > Setup Consistency Check Report for Machine: SERVER ... Result: Warning ... > Installing: sqlsupport on target: SERVER ...
    (microsoft.public.sqlserver.setup)
  • sql 2005 ctp install didnt go so well
    ... Setup Consistency Check Report for Machine: SERVER ... Installing: sqlsupport on target: SERVER ... Bootstrap\LOG\SqlSetup0002.cab" Error Code: 2 ...
    (microsoft.public.sqlserver.setup)
  • Re: temp internet folder cookies listing
    ... Tea Timer) *before* installing SP2. ... Settings\\Cookies <=this folder contains and shows your cookies. ... that there are cookies on my computer. ... cookies no longer appear in the Temp Internet Folder. ...
    (microsoft.public.windowsxp.general)