Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 28th, 2007, 05:08 PM
Registered User
 
Join Date: May 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Distributed VB6 App With D/Base !! Help...

Hi Folks

I'm having a real problem with an application I've built.

All works perfect when in design mode in VB6.

Also works when I package using the Package & Deployment WIzard.

However, the database (its an Access database) is referring to the SAME database (i.e. filepath!!) I am using for dev...

I include it with the package and this does work but it still refers to the absoloute reference I am using within VB6!!!

Any ideas on how I can get round this? OBviously wiht using the data control I need to specify the database at design time but how do I alter this so when its pacakged, it uses the database in the pacakge???

All help most gratefully appreciated - tearing my hair out here!!

Thanks

Col

 
Old May 29th, 2007, 07:33 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there...

you have to pass the connection strings at runtime to the controls...
or you can try not to have full path but relatives (I don't remember is this works with controls)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old June 2nd, 2007, 01:45 PM
Registered User
 
Join Date: May 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Cheers for that ... figured it out that I should have been updating the reference to the database in runtime!!! Pain but sorted now. Cheers again






Similar Threads
Thread Thread Starter Forum Replies Last Post
Depencies for my VB6 app Tank Beginning VB 6 3 December 22nd, 2005 07:39 PM
VB6 Excel App to .NET problem zayasv VB.NET 0 October 24th, 2005 04:08 PM
VB6 App with CR9 problem ioates Pro VB Databases 0 May 10th, 2005 10:37 AM
Running a VB6 app as a service adman Pro VB 6 3 April 6th, 2004 02:21 PM
Out of Memory error from VB6 App on Win98 pavel Pro VB 6 3 January 12th, 2004 07:00 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.