Moving to network drive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have an MDW file with a shortcut and security files. I have also
split this database so that it has a front end.
I need to move these to O:\Csg.
How do i go about it and what do i need to move?
Matt
 
Matt Dawson said:
I currently have an MDW file with a shortcut and security files. I have
also
split this database so that it has a front end.
I need to move these to O:\Csg.
How do i go about it and what do i need to move?
Matt
Click to expand...

Put your back end and mdw files on the server and put a copy of the front
end on each user's PC.

Regards,
Keith.
www.keithwilby.com
 
Right ok, I have never done this before and am slightly confused.

I hav four files i need to work with. The security (mdw), the back-end, what
i think you call the front end, and then the shortcut that I currently run
off.

The security file and the main database (ie what the shortcut runs off) are
currently on the network. Does the back-end need to be on there too and then
the shortcut on each user's computer?

Matt
 
Matt Dawson said:
Right ok, I have never done this before and am slightly confused.

I hav four files i need to work with. The security (mdw), the back-end,
what
i think you call the front end, and then the shortcut that I currently run
off.

The security file and the main database (ie what the shortcut runs off)
are
currently on the network. Does the back-end need to be on there too and
then
the shortcut on each user's computer?
Click to expand...

Not quite. You need the back end mdb (ie tables only) and the mdw on your
server. You then need a copy of the front end (ie all other objects plus
linked tables) on each user's PC and a shortcut on their desktop in the
following format:

"Full path to MSACCESS.EXE" "Full path to your local front end.mdb" /wrkgrp
"Full path to your workgroup file.mdw"

including the quotation marks.

HTH - Keith.
www.keithwilby.com
 
Cheers Keith, thats brilliant.

I assume it does not matter where the front end is located on their computer
as long as it is signified in the shortcut target?

Many Thanks
 
In addition Matt, you'll need to open the frontend and refresh the links to
the tables in the backend in it's new location.

Just do this in one frontend. Then copy that frontend to the server. Then
you need only copy the FE from the server to each workstation (the path to
the backend will travel with it).

The copy of the frontend on the server, is only there for ease of
distribution; no one will actually use that frontend directly.
 
Matt Dawson said:
Cheers Keith, thats brilliant.

I assume it does not matter where the front end is located on their
computer
as long as it is signified in the shortcut target?

Many Thanks
Click to expand...

That's right :-)

Keith.
 
Keith,

I also need to update the tables once a week with new data that comes in. Do
I simply add this to the back-end tables? I dont see how the link from the
network drive (where the back-end is) will link to the shortcut that the
agents run from as there is no link to it within the shortcut target!

Matt
 
Matt said:
Keith,

I also need to update the tables once a week with new data that comes
in. Do I simply add this to the back-end tables? I dont see how the
link from the network drive (where the back-end is) will link to the
shortcut that the agents run from as there is no link to it within
the shortcut target!
Click to expand...

It doesn't. The shortcut is pointing at the front end file and the links
inside the front end point at the back end.
 
Back
Top