Database Splitter - Moving FE to local PC

[Guest]

I made a mistake when using the DB splitter to split the DB. The BE and FE
is placed on network server in the same folder. Can I copy the FE to each
user local PC? How do I create the shortcut on the users PC to run Access
from their PC and find the BE on the network server. I have 6 users that
will share/input info in the DB.

Thank you in advance for your help.

 

[Keith Wilby]

I made a mistake when using the DB splitter to split the DB. The BE and FE
is placed on network server in the same folder. Can I copy the FE to each
user local PC?
Yes.

How do I create the shortcut on the users PC to run Access
from their PC and find the BE on the network server. I have 6 users that
will share/input info in the DB.

If you've split correctly, then the linked tables in the FE will work from
your users' PCs (assuming their drive mappings, server names etc are the
same as yours). You don't say if you've implemented user level security.
If you haven't then just have your users open the FE on their PC from a
browser of a desktop shortcut.

If you have then each user will need a desktop shortcut with a command line
in the format (incl the quotes):

"Full path to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
to your WIF.mdw"

HTH - Keith.
www.keithwilby.com

 

[Guest]

When I split the DB, I went to My Network Places and travel over to the
folder where I need to place the BE. All 6 users are on the same server. I
did use user level security and the MDW file is placed in the same folder as
the BE. I will place the FE in each user's "My Documents" folder and follow
the instructions below to create the shortcut.

Also have you heard of Auto FE Updater, any thoughs or comments.

Thank You.

 

[Keith Wilby]

When I split the DB, I went to My Network Places and travel over to the
folder where I need to place the BE. All 6 users are on the same server.
I
did use user level security and the MDW file is placed in the same folder
as
the BE.

This is the "classic" configuration.

I will place the FE in each user's "My Documents" folder and follow
the instructions below to create the shortcut.

Also have you heard of Auto FE Updater, any thoughs or comments.

I have heard of it and I know a lot of people use and like it but I've never
had a use for it myself. All I do is place my FE in a public folder and
have the users' shortcuts point to a batch file which copies it to their HDD
and opens it. So as long as you keep the copy of the mdb in the public
folder up to date then the users always have the latest version.

Regards,
Keith.
www.keithwilby.com

 

[Guest]

I followed your instructions and all 6 users are up and running.

Since this is my first time doing this, you mentioned "So as long as you
keep the copy of the mdb in the public folder up to date then the users
always have the latest version." I will be adding additional users, do I
need to copy the MBD from one of the existing users local drive to the public
folder so when I setup the new user they will have the latest MBD. The MBD
file in the public folder is dated 5/23/06 9:27AM when I first copied to the
6 users. The 6 users have since updated the DB.

 

[Keith Wilby]

I followed your instructions and all 6 users are up and running.

Since this is my first time doing this, you mentioned "So as long as you
keep the copy of the mdb in the public folder up to date then the users
always have the latest version." I will be adding additional users, do I
need to copy the MBD from one of the existing users local drive to the
public
folder so when I setup the new user they will have the latest MBD. The
MBD
file in the public folder is dated 5/23/06 9:27AM when I first copied to
the
6 users. The 6 users have since updated the DB.

NO!

By "latest" I mean your most up to date development copy. Typically you'd
work on the design in a private folder, then when you're ready to roll it
out to your users, copy it to your public folder.

HTH - Keith.
www.keithwilby.com

 

[Guest]

Got It. I will continue to use the current FE in the public folder for new
users (unless the design have changed then I will copy into the public
folder). This is a learning experience and my first time using Access. I
truly appreciate your help. Thank you.

 

[Keith Wilby]

Got It. I will continue to use the current FE in the public folder for
new
users (unless the design have changed then I will copy into the public
folder). This is a learning experience and my first time using Access. I
truly appreciate your help. Thank you.

Glad I could help, good luck.

Keith.