Charlotte Foust
cfoust at infostatsystems.com
Fri Jan 20 10:18:11 CST 2006
That's VB syntax. Doesn't work in Access. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, January 19, 2006 9:46 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Read External File for Path String app.path may not work in Access. Drew -----Original Message----- From: Dan Waters [mailto:dwaters at usinternet.com] Sent: Thursday, January 19, 2006 5:43 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Read External File for Path String Drew, I tried this, but strTemp remains an empty string. Could you review? Thanks, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, January 19, 2006 12:13 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Read External File for Path String Dim f as Long dim strTemp as string f=freefile Open App.Path & "\dbpath.dat" for binary access read as f strtemp=space(lof(f)) get f,,strtemp close f Now strTemp is the contents of dbpath.dat Drew -----Original Message----- From: Dan Waters [mailto:dwaters at usinternet.com] Sent: Thursday, January 19, 2006 10:45 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Read External File for Path String Hi Drew! I assume you can create the dbpath.dat file by starting with a text file? What code do you use to read from the dbpath.dat file? Thanks, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, January 19, 2006 10:28 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Read External File for Path String I do that all the time, though it's usually for my VB projects. I create a dbpath.dat file, and put it in the same folder as my .exe, so when I go to connect to a database, I look the path up in dbpath.dat. Drew -----Original Message----- From: Dan Waters [mailto:dwaters at usinternet.com] Sent: Wednesday, January 18, 2006 6:38 PM To: 'AccessD' Subject: [AccessD] Read External File for Path String Hello Everyone, I just spent half the day struggling with the movement of a system from one server to another. The server path is hardcoded in one place in a startup form. What would have helped me a lot is to have the path in a text file or ini file external to the database and stored in the same folder. Security is not an issue here, just my convenience, as my plans for the day were pretty much blown up! Using a file for information like this sounds like it might be a fairly typical solution. Does anyone do this or something like it? Thanks! Dan Waters -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com