[AccessD] Read External File for Path String

Dan Waters dwaters at usinternet.com
Thu Jan 19 17:43:09 CST 2006


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




More information about the AccessD mailing list