Re: Need help with a VB.NET error ... please help! Details within
From: Peter van der Goes (p_vandergoes_at_toadstool.u)
Date: 05/20/04
- Next message: Cor Ligthert: "Re: multiple search/replacements in a single Regex.Replace?"
- Previous message: Lisa: "Re: tooltip for tabcontrol headers?"
- In reply to: D P: "Need help with a VB.NET error ... please help! Details within"
- Next in thread: Cor Ligthert: "Re: Need help with a VB.NET error ... please help! Details within"
- Reply: Cor Ligthert: "Re: Need help with a VB.NET error ... please help! Details within"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 May 2004 09:01:02 -0500
"D P" <islesfan@hotmail.com> wrote in message
news:%2359goPmPEHA.3044@TK2MSFTNGP10.phx.gbl...
> 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!
>
>
Do you have a full installation of the same version of MS Access on the
target PC as exists on the development PC?
You don't need Access installed to use an Access database with VB.NET, but
you are using an Access application object.
-- Peter [MVP Visual Developer] Jack of all trades, master of none.
- Next message: Cor Ligthert: "Re: multiple search/replacements in a single Regex.Replace?"
- Previous message: Lisa: "Re: tooltip for tabcontrol headers?"
- In reply to: D P: "Need help with a VB.NET error ... please help! Details within"
- Next in thread: Cor Ligthert: "Re: Need help with a VB.NET error ... please help! Details within"
- Reply: Cor Ligthert: "Re: Need help with a VB.NET error ... please help! Details within"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
