MS Access Database Network Path

Hi,
I have some MDB (MS Access 2000) files on our server. It is small
application created by one of our employee long time ago. I see this
application is on Network Drive G: and H: (both drive has same
databases, I don't know why). When user accesses this aplication it
opens Timecard.MDB from H: drive. (when I disconnect computer from
Network I get error saying couldn't find H: Drive).

I have copied all these MDBs to my XP computer on my local C:\AccessDB
folder, when I try to open it opens and let me access the Database but
again when I disconnect my computer from network I get message saying
"Disk or Network Error". Can somebody help me how to change the path of
MDB application from H: to C:.

Thanks,
Mukesh

It's not magic which path to use for an Access application. The path will be
contained in the desktop shortcut, or in your command line if you use that
approach, or determined from the folder in which you double-click the
application.

It is possible, I suppose, that the implied workgroup file is not used if
you are the only user, and would have been created on drive H:, but you
don't have delete permissions? Anyway, assuming you have access to the MDB
source, you can get a third party tool such as Find & Replace (from
www.rickworld.com) or Speed Ferret (from www.moshannon.com) and search to
see if you find "H:" coded in the database.

Larry Linson
Microsoft Access MVP

<mukeshhtrivedi@gmail.com> wrote in message
news:1147280234.290828.296100@g10g2000cwb.googlegr oups.com...[color=blue]
> Hi,
> I have some MDB (MS Access 2000) files on our server. It is small
> application created by one of our employee long time ago. I see this
> application is on Network Drive G: and H: (both drive has same
> databases, I don't know why). When user accesses this aplication it
> opens Timecard.MDB from H: drive. (when I disconnect computer from
> Network I get error saying couldn't find H: Drive).
>
> I have copied all these MDBs to my XP computer on my local C:\AccessDB
> folder, when I try to open it opens and let me access the Database but
> again when I disconnect my computer from network I get message saying
> "Disk or Network Error". Can somebody help me how to change the path of
> MDB application from H: to C:.
>
> Thanks,
> Mukesh
>[/color]

Thanks Larry.

I am have full access to DB but I don't how to change the path so that
each time I access this DB on my local computer can have access without
network conenctivity.

Mukesh

Hi Larry,

I want to change to C: drive from G: which shows G:\SH Data.MDB. Can
you please guide how to do change this. I am not good at Access but
knows little about MS Access.

C:\Access DBs\TIMECARD.mdb
Wednesday, May 10, 2006

Table: TBL_TIMECARD
Page: 1

Properties

Attributes: Linked Connect:
;DATABASE=G:\SH DATA.mdb
Date Created: 7/12/2002 3:35:36 PM Filter:
((TBL_TIMECARD.WEEKENDDATE=#8/2

0/2002#))
GUID: Long binary data Last Updated:
1/21/2005 2:44:19 PM

NameMap: Long binary data OrderBy:
TBL_TIMECARD.WEEKENDDATE DESC

OrderByOn: True Orientation:
0
RecordCount: -1 Source Table
Name: TBL_TIMECARD

Updatable: False

It seems the TIMECARD.MDB actually links to another MDB "SH DATA.mdb"
which sits on the network drive G:

You can verify that by opening the TIMECARD.MDB, goto "Tools" ->
"Database Utilities" -> "Linked Table Manager". You'll see any linked
tables involved.

mukeshhtrivedi@gmail.com wrote in
news:1147280234.290828.296100@g10g2000cwb.googlegr oups.com:
[color=blue]
> I have some MDB (MS Access 2000) files on our server. It is small
> application created by one of our employee long time ago. I see
> this application is on Network Drive G: and H: (both drive has
> same databases, I don't know why). When user accesses this
> aplication it opens Timecard.MDB from H: drive. (when I disconnect
> computer from Network I get error saying couldn't find H: Drive).
>
> I have copied all these MDBs to my XP computer on my local
> C:\AccessDB folder, when I try to open it opens and let me access
> the Database but again when I disconnect my computer from network
> I get message saying "Disk or Network Error". Can somebody help me
> how to change the path of MDB application from H: to C:.[/color]

Are you sure it's not just linked tables pointing to the H: drive?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hi Ray,

Yes I agree but I want to change path from G: drive to C: on SH
Data.MDB and other all linked DBs. Can you please guide me from where I
can change the path so when I open any database, it will look or try to
open linked database which I am copying in C: drive.

Thanks,
Mukesh

<mukeshhtrivedi@gmail.com> wrote in message
news:1147376764.470799.113980@i40g2000cwc.googlegr oups.com...[color=blue]
> Hi Ray,
>
> Yes I agree but I want to change path from G: drive to C: on SH
> Data.MDB and other all linked DBs. Can you please guide me from where I
> can change the path so when I open any database, it will look or try to
> open linked database which I am copying in C: drive.[/color]

If all you need to do is to change so the linked tables are, by default, on
your C: drive, open the linked tables in Design View (from the main database
window), right-click in the bar at the top where the table name is shown,
choose properties, and you'll find that path embedded in the Description
property. You may still need to use the Linked Table Manager one more time
on the tables with revised Connect strings.

Is that what you need to do?

Larry Linson
Microsoft Access MVP

Thanks Larry.

I think this is what I want to get. I will try to change the path for
all linked DBs to C: as I am going to have all these DBs in my C:
folder and want to access from C: drive only.

I will post once I am succeeded in what I am looking for.

Again thanks,
Mukesh

Also you can use the following way:

Got to linked table manager
select all tables that you want to change to C drive
check the box in the lower left hand corner that says ask for new
location.
Click OK.

When the open window comes up, select the mdb on the c drive that has
the tables.

If ALL the tables are now on the C drive then it will probably only ask
once, if not then any times it comes up select the drive/mdb that
contains the table it is asking about.

This is also what you would do but in reverse to put the mdb back to
pointing to the network drives.