Database contains reference to H: drive ?

[groleau]

An Access DB that hasn't changed (other than the actual data) complained on open that it could not access 'h:'

Searching the VB found no reference to 'h:'

The macro we were trying to run does a bunch of Transfer_Spreadsheet but all of the spreadsheets
are in the same directory as the DB, and all of
them are referenced UNC ( i.e., \\Svr0903\vol1\.... )

None of the tables are linked tables.

?????

--
Wes Groleau

http://www.Parkview.com/

 

[genomon]

Try going to Tools|Options|General and see if your default directory was inadvertently renamed.

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[groleau]

I'll check on that, thanks.

That appears to be a per-user setting, rather than per-DB so I'll have to check with the person who normally does the updates.

thanks

--
Wes Groleau

http://www.Parkview.com/

 

[groleau]

> Try going to Tools|Options|General and see
> if your default directory was inadvertently renamed

Yes, that was it. But it happened again two weeks later.
The person that runs this database is not technical and
would not have known how to changed it--nor had any
reason to do so. And it certainly can't be done accidentally (four or five mouse actions).

So what makes this change?

--
Wes Groleau

http://www.Parkview.com/

 

[lordfidan]

I don't knowm if this is the same with you, but our default is automatically set by our IT department.

 

[groleau]

That might be it--we have Novell, so applications are frequently reinstalled. Hmmm. thanks

--
Wes Groleau

http://www.Parkview.com/