Im getting a object required in the line strMDBPath = Textbox2.Text & "\" & Textbox3.Text ' mdb path of Database
-----Original Message----- From: Brian E Boothe [mailto:[EMAIL PROTECTED] Sent: Monday, November 08, 2004 7:48 AM To: [EMAIL PROTECTED] Subject: [Visual Basic 6 programming] Connecting to a database Once the directory is written and the MDB is copied into that directory how to I write my Connection string to that database,. ?? How can I use Textbox2.text= path of the database testbox3.text = database name in a connection string ?? As follows ? strMDBPath = "C:\SampleDir\sample.mdb"(Give your new direcotry path) g_constr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strMDBPath & _ "Jet OLEDB:Database " -----Original Message----- From: Rick Rose [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 8:25 PM To: [EMAIL PROTECTED] Subject: Re: [Visual Basic 6 programming] Connecting to a database If you have to update all your databases at the same time, you can use the FileSystemObject and cycle through your directories and update your databases that way. If you only have to update one database, then you should know the name of the database to update. It would be inputed by the user. Go to www.connectionstrings.com to get your connection string. I would recommend using ODBC with ADO. If further help is needed, let me know and I'll write some code for you. Rick Rose -------Original Message------- From: Brian E Boothe Date: 11/05/04 15:03:54 To: [EMAIL PROTECTED] Subject: [Visual Basic 6 programming] Connecting to a database I make a directory thru code by the name in a textbox and Copy a template MDB to that directory And the MDB is renamed by the text in another field soo How do I connect to that database to update it once all that is done, >? [Non-text portions of this message have been removed] Yahoo! Groups Links . [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129mpu6b8/M=295196.4901138.6071305.3001176/ D=groups/S=1705115364:HM/EXP=1099794416/A=2128215/R=0/SIG=10se96mf6/*htt p:/companion.yahoo.com> click here <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group s/S=:HM/A=2128215/rand=151846192> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] bscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=0/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=1/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> Get unlimited calls to <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=1/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> U.S./Canada <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=1/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> <http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1099 924241632586> <http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=group s/S=:HM/A=2343726/rand=950275689> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] bscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17924 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
