How to detect if current directory is on a CD

[ipellew]

Hi;

I have a DBS that that generates some javasript and allows the user to
alter table contents.

If the database is being executed on a CD/DVD how can I tell is the
current directory is unwritable from within the Access VB module?

Regards
Ian

[RoyVidar]

"ip*****@pipeme dia.co.uk" <ip*****@pipeme dia.co.ukwrote in message
<11************ *********@i42g2 000cwa.googlegr oups.com>:

Hi;

I have a DBS that that generates some javasript and allows the user
to alter table contents.

If the database is being executed on a CD/DVD how can I tell is the
current directory is unwritable from within the Access VB module?

Regards
Ian

I would probably work with some of the objects, methods and properties
of the filesystemobjec t.

With a reference to Microsoft Scripting Runtime, you should be able to
do something like this

dim fs as scripting.files ystemobject
dim dr as scripting.drive

set fs = new scripting.files ystemobject
' or late bind, and use
' set fs = createobject("s cripting.filesy stemobject")
set dr = fs.getdrive(str YourDrive) ' currentproject. path

debug.print dr.drivetype

Drivetype 4, I think, is CD/DVD.

Usage of the scripting libaries, are frowned upon in these newsgroups,
I think, due to scripting being disabled by some, and I think this
http://www.mvps.org/access/api/api0003.htm is more PC ;-)

--
Roy-Vidar

[Tom van Stiphout]

On 22 Jul 2006 05:23:05 -0700, ip*****@pipemed ia.co.uk wrote:

A simple way would be to try to create a small file, and handle the
runtime error that is thrown when it fails.
-Tom.

>Hi;

I have a DBS that that generates some javasript and allows the user to
alter table contents.

If the database is being executed on a CD/DVD how can I tell is the
current directory is unwritable from within the Access VB module?

Regards
Ian

[Terry Kreft]

.... which more generically answers the question the OP really needs to know
which is "can I write to disc in the current folder".

--

Terry Kreft
"Tom van Stiphout" <no************ *@cox.netwrote in message
news:8q******** *************** *********@4ax.c om...

On 22 Jul 2006 05:23:05 -0700, ip*****@pipemed ia.co.uk wrote:

A simple way would be to try to create a small file, and handle the
runtime error that is thrown when it fails.
-Tom.

Hi;

I have a DBS that that generates some javasript and allows the user to
alter table contents.

If the database is being executed on a CD/DVD how can I tell is the
current directory is unwritable from within the Access VB module?

Regards
Ian