[AccessD] Read External File for Path String

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



More information about the AccessD mailing list