Problem with Access Database With Linked Text File

[melody]

Hi,

I'm using an Access 2000 database with my ASP application,
and the db has a link to a text file.

Previously, the text file and the db were in the same
folder and everything worked fine. But after I moved the
text file into a subfolder (in the same folder where the
db is located), ASP is giving me this error :

Microsoft OLE DB Provider for ODBC Drivers
error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The text file
specification 'DEPENDENTS Link Specification1' does not
exist. You cannot import, export, or link using the
specification.

I already updated the link to the text file in the db to
its new location, but no avail. Really would appreciate
some help on this.

Thanks.

Melody

[Atrax]

is there a reason you moved the text file?





________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows]

melody wrote:

> Hi,
>
> I'm using an Access 2000 database with my ASP application,
> and the db has a link to a text file.
>
> Previously, the text file and the db were in the same
> folder and everything worked fine. But after I moved the
> text file into a subfolder (in the same folder where the
> db is located), ASP is giving me this error :
>
> Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] The text file
> specification 'DEPENDENTS Link Specification1' does not
> exist. You cannot import, export, or link using the
> specification.
>
> I already updated the link to the text file in the db to
> its new location, but no avail. Really would appreciate
> some help on this.
>
> Thanks.
>
> Melody

It's likely to be permissions: the IUSR_machinename account does not have
the needed permissions for the text file's new location.

Bob Barrows

[Melody]

I've checked, IUSR has full control over the new location
the txt file in :(

>-----Original Message-----
>melody wrote:

>> Hi,
>>
>> I'm using an Access 2000 database with my ASP

application,

>> and the db has a link to a text file.
>>
>> Previously, the text file and the db were in the same
>> folder and everything worked fine. But after I moved the
>> text file into a subfolder (in the same folder where the
>> db is located), ASP is giving me this error :
>>
>> Microsoft OLE DB Provider for ODBC Drivers
>> error '80004005'
>>
>> [Microsoft][ODBC Microsoft Access Driver] The text file
>> specification 'DEPENDENTS Link Specification1' does not
>> exist. You cannot import, export, or link using the
>> specification.
>>
>> I already updated the link to the text file in the db to
>> its new location, but no avail. Really would appreciate
>> some help on this.
>>
>> Thanks.
>>
>> Melody

>
>It's likely to be permissions: the IUSR_machinename

account does not have

>the needed permissions for the text file's new location.
>
>Bob Barrows
>
>
>.
>

[Melody]

Well, the reason for the move is this : the text file is
being updated weekly with data from an external source, so
just to organize things I created a subfolder and moved
the text file one level down (lets say the original
location is "//computername/db/", the new location of the
text file is now "//computername/db/newfolder/").

Another thing that I might mention is that the text file
is not in the web root folder.

>-----Original Message-----
>is there a reason you moved the text file?
>
>
>
>
>
>________________________________________
>Atrax. MVP, IIS
>[url]http://rtfm.atrax.co.uk/[/url]
>
>newsflash : Atrax.Richedit 1.0 now released.
>[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.R[/url]

ichEdit/

>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url]

***

>Don't just participate in USENET...get rewarded for it!
>.
>

[Bob Barrows]

Try deleting and recreating the link.

Bob Barrows
Melody wrote:

> I've checked, IUSR has full control over the new location
> the txt file in :(
>

>> -----Original Message-----
>> melody wrote:

>>> Hi,
>>>
>>> I'm using an Access 2000 database with my ASP application,
>>> and the db has a link to a text file.
>>>
>>> Previously, the text file and the db were in the same
>>> folder and everything worked fine. But after I moved the
>>> text file into a subfolder (in the same folder where the
>>> db is located), ASP is giving me this error :
>>>
>>> Microsoft OLE DB Provider for ODBC Drivers
>>> error '80004005'
>>>
>>> [Microsoft][ODBC Microsoft Access Driver] The text file
>>> specification 'DEPENDENTS Link Specification1' does not
>>> exist. You cannot import, export, or link using the
>>> specification.
>>>
>>> I already updated the link to the text file in the db to
>>> its new location, but no avail. Really would appreciate
>>> some help on this.
>>>
>>> Thanks.
>>>
>>> Melody

>>
>> It's likely to be permissions: the IUSR_machinename account does not
>> have the needed permissions for the text file's new location.
>>
>> Bob Barrows
>>
>>
>> .

[Melody]

Tried that, but I'm still getting the same error message.

>-----Original Message-----
>Try deleting and recreating the link.
>
>Bob Barrows
>Melody wrote:

>> I've checked, IUSR has full control over the new

location

>> the txt file in :(
>>

>>> -----Original Message-----
>>> melody wrote:
>>>> Hi,
>>>>
>>>> I'm using an Access 2000 database with my ASP

application,

>>>> and the db has a link to a text file.
>>>>
>>>> Previously, the text file and the db were in the same
>>>> folder and everything worked fine. But after I moved

the

>>>> text file into a subfolder (in the same folder where

the

>>>> db is located), ASP is giving me this error :
>>>>
>>>> Microsoft OLE DB Provider for ODBC Drivers
>>>> error '80004005'
>>>>
>>>> [Microsoft][ODBC Microsoft Access Driver] The text

file

>>>> specification 'DEPENDENTS Link Specification1' does

not

>>>> exist. You cannot import, export, or link using the
>>>> specification.
>>>>
>>>> I already updated the link to the text file in the db

to

>>>> its new location, but no avail. Really would

appreciate

>>>> some help on this.
>>>>
>>>> Thanks.
>>>>
>>>> Melody
>>>
>>> It's likely to be permissions: the IUSR_machinename

account does not

>>> have the needed permissions for the text file's new

location.

>>>
>>> Bob Barrows
>>>
>>>
>>> .

>
>
>
>.
>

[Bob Barrows]

Hmm, create a blank database and import all the objects (except the link)
from the original database. Move the original database somewhere, give the
new database the same name as the original and then create the link to the
text file in the new database.

Bob Barrows

Melody wrote:

> Tried that, but I'm still getting the same error message.
>

>> -----Original Message-----
>> Try deleting and recreating the link.
>>
>> Bob Barrows
>> Melody wrote:

>>> I've checked, IUSR has full control over the new location
>>> the txt file in :(
>>>
>>>> -----Original Message-----
>>>> melody wrote:
>>>>> Hi,
>>>>>
>>>>> I'm using an Access 2000 database with my ASP application,
>>>>> and the db has a link to a text file.
>>>>>
>>>>> Previously, the text file and the db were in the same
>>>>> folder and everything worked fine. But after I moved the
>>>>> text file into a subfolder (in the same folder where the
>>>>> db is located), ASP is giving me this error :
>>>>>
>>>>> Microsoft OLE DB Provider for ODBC Drivers
>>>>> error '80004005'
>>>>>
>>>>> [Microsoft][ODBC Microsoft Access Driver] The text file
>>>>> specification 'DEPENDENTS Link Specification1' does not
>>>>> exist. You cannot import, export, or link using the
>>>>> specification.
>>>>>
>>>>> I already updated the link to the text file in the db to
>>>>> its new location, but no avail. Really would appreciate
>>>>> some help on this.
>>>>>
>>>>> Thanks.
>>>>>
>>>>> Melody
>>>>
>>>> It's likely to be permissions: the IUSR_machinename account does
>>>> not have the needed permissions for the text file's new location.
>>>>
>>>> Bob Barrows
>>>>
>>>>
>>>> .

>>
>>
>>
>> .

[Melody]

It worked, except that I renamed the original database
instead of moving it. Thanks a lot for your help :-)

>-----Original Message-----
>Hmm, create a blank database and import all the objects

(except the link)

>from the original database. Move the original database

somewhere, give the

>new database the same name as the original and then

create the link to the

>text file in the new database.
>
>Bob Barrows
>
>Melody wrote:

>> Tried that, but I'm still getting the same error

message.

>>

>>> -----Original Message-----
>>> Try deleting and recreating the link.
>>>
>>> Bob Barrows
>>> Melody wrote:
>>>> I've checked, IUSR has full control over the new

location

>>>> the txt file in :(
>>>>
>>>>> -----Original Message-----
>>>>> melody wrote:
>>>>>> Hi,
>>>>>>
>>>>>> I'm using an Access 2000 database with my ASP

application,

>>>>>> and the db has a link to a text file.
>>>>>>
>>>>>> Previously, the text file and the db were in the

same

>>>>>> folder and everything worked fine. But after I

moved the

>>>>>> text file into a subfolder (in the same folder

where the

>>>>>> db is located), ASP is giving me this error :
>>>>>>
>>>>>> Microsoft OLE DB Provider for ODBC Drivers
>>>>>> error '80004005'
>>>>>>
>>>>>> [Microsoft][ODBC Microsoft Access Driver] The text

file

>>>>>> specification 'DEPENDENTS Link Specification1' does

not

>>>>>> exist. You cannot import, export, or link using the
>>>>>> specification.
>>>>>>
>>>>>> I already updated the link to the text file in the

db to

>>>>>> its new location, but no avail. Really would

appreciate

>>>>>> some help on this.
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> Melody
>>>>>
>>>>> It's likely to be permissions: the IUSR_machinename

account does

>>>>> not have the needed permissions for the text file's

new location.

>>>>>
>>>>> Bob Barrows
>>>>>
>>>>>
>>>>> .
>>>
>>>
>>>
>>> .

>
>
>
>.
>