splitting MDB

[Tim]

I just split (manually) my DB into front/back-end DBs. The
back end is located on a network drive (server). I created
the front-end in the same folder with the back-end on the
network drive. Now I'm a little bit confused distrubuting
the front-end to the workstations. Do I have to create the
front-end on each workstation manually?

 

[Joan Wild]

Just copy the frontend file from the server to a local folder on the users'
workstations.

You might also want to set up an automatic distribution of frontends. This
is handy should you ever have changes to the frontend that need to be
distributed. One method to this at
http://www.granite.ab.ca/access/autofe.htm

 

[Tim]

Joan,
That's what I did in the first place. I copied the FE on a
local C:\ drive of a workstation. When I tried to open the
copied FE it gave me an error 'disk or network error' on
the workstation. It's my guess, when I just copy the FE on
workstations, the FE has a path that was created on the
server so there's something I need (automatic
distribution..?)that changes it on workstations. Is it
right?

Then I created a new FE the same as on the server on a
workstation (not copy) and it worked. But it's too much
work as you know to do it on every single workstations.

 

[Joan Wild]

What if you copy that FE you made on the workstation, and copied it to the
server (then copy that one to other workstations)?

--
Joan Wild
Microsoft Access MVP

Joan,
That's what I did in the first place. I copied the FE on a
local C:\ drive of a workstation. When I tried to open the
copied FE it gave me an error 'disk or network error' on
the workstation. It's my guess, when I just copy the FE on
workstations, the FE has a path that was created on the
server so there's something I need (automatic
distribution..?)that changes it on workstations. Is it
right?

Then I created a new FE the same as on the server on a
workstation (not copy) and it worked. But it's too much
work as you know to do it on every single workstations.

 

[Tim]

I feel stupid, never thought that way, so simple...
Thank you Joan,
you have a nice weekend.

-----Original Message-----
What if you copy that FE you made on the workstation, and copied it to the
server (then copy that one to other workstations)?