Thanks Shawn. I knew it would be something simple. It almost always is. I will give that a try. Looks like you are the real stud here! =P Take care. Dave~
>>> [EMAIL PROTECTED] 01/14/05 6:23 PM >>> Hey Stud, > First question is what is the best recomended data model > for a simple database. I'd recommend MS Access as the actual data store, and ADO as the data access technology. > Second question,(most important) how do I make sure the > code will know where to find the data source once the > program is packaged and distributed. The best way (esp. for ADO) is to build the path when the application loads. I use this type of code all the time: sDBPath = app.Path & "\" app.EXEName & ".mdb" > When you set up your data connections in VB it seems that > these values need to be hard coded during the design > process. I've tried to assign the path value at runtime > but I am not having any luck. The packaging process does > note seem to account adequately for this. Remove the connection before you package it. Have it do it all dynamically onload. Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================== It's all right letting yourself go as long as you can let yourself back. -- Mick Jagger '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links [Non-text portions of this message have been removed] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> 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/
