Re: Professional Database question - SQL Server, Access, etc - What's best?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Yes, it will work. Add the MDB file to your package.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"jonny" wrote:
Ok. I will try this on a computer that does not have Access installed. I will copy my access file in the path where my code is pointing.

mconAP.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Production Reporting System\Production Reporting System.mdb"


At this point you are saying it will work.

How can I get this to work with the VB exe. package deployment? So I don't have to have the user copy the mdb file to a certain file path?
.

Relevant Pages

  • Re: Package and Deployment Wizard Question
    ... When you build an app that uses the mdb file, the Package ... > package and deployment wizard available as an Access add-in. ... > Access files from the Developer CD's (Access install part) or from the ...
    (microsoft.public.vb.general.discussion)
  • Re: Package Wizard
    ... I tried to package the mdb file with my Office 2003 Package Wizard, ... Online Partner Support Specialist ...
    (microsoft.public.access.developers.toolkitode)
  • RE: dts package error
    ... > created package through sql using the all tasks extract info selected a ... > When it runs through the scheduler it cannot find the mdb file on the server. ...
    (microsoft.public.sqlserver.dts)
  • RE: Repost Cant populate 2nd listbox from selected value of firs
    ... As the .mdb file will be blocked by Exchange Server, ... in a zip package. ... Kevin Yu ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Deploying VB .NET application WITH MS Access db
    ... Friend Shared ReadOnly Property Assemblypath() As String ... Me.Datasource = Path.Combine(Assemblypath, strDatasource) ... ..mdb file to the Application folder too. ... changing the db's File Path to just the name of the db but that also didn't ...
    (microsoft.public.dotnet.languages.vb)