Splitting a database with BE on one server and FE on the desktop

[Guest]

I am splitting a database so that the BE will reside on a server to which the
user normally has no access. I understand that I should create a folder on
that server and grant the users involved read/write/create/delete
permissions. I further understand that I can then copy the FE to their
desktops.

How can I make sure that the path from the FE on their desktops to the BE on
the server is correct? Where is this information stored in the split
database?

 

[Joseph Meehan]

I am splitting a database so that the BE will reside on a server to
which the user normally has no access. I understand that I should
create a folder on that server and grant the users involved
read/write/create/delete permissions. I further understand that I
can then copy the FE to their desktops.

How can I make sure that the path from the FE on their desktops to
the BE on the server is correct? Where is this information stored in
the split database?

It's stored in the FE. You can re-link the files for each FE after it
is installed if the path may be different for each user. If they are all
going to be the same, then put a FE on your desktop, re-link and then copy
that one for the other users.

I suspect there are other ways, but that has worked for me.

 

[Tony Toews]

I am splitting a database so that the BE will reside on a server to which the
user normally has no access. I understand that I should create a folder on
that server and grant the users involved read/write/create/delete
permissions. I further understand that I can then copy the FE to their
desktops.

How can I make sure that the path from the FE on their desktops to the BE on
the server is correct? Where is this information stored in the split
database?

To add to Joseph's post, and if required, Relink Access tables from
code
http://www.mvps.org/access/tables/tbl0009.htm

Also I specifically created the Auto FE Updater utility so that I
could make changes to the FE MDE as often as I wanted and be quite
confident that the next time someone went to run the app that it would
pull in the latest version. For more info on the errors or the Auto
FE Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

To add to Joseph's post, and if required, Relink Access tables from
code
http://www.mvps.org/access/tables/tbl0009.htm

Also I specifically created the Auto FE Updater utility so that I
could make changes to the FE MDE as often as I wanted and be quite
confident that the next time someone went to run the app that it would
pull in the latest version. For more info on the errors or the Auto
FE Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

ok....i feel really stupid here.....I have had a class at college in Access
so I have a fair understanding...but....

I have looked at the file made by Dve Ashish and the Auto FE and I just
understand what you are supposed to DO with them. Copy and paste to make a
macro or something? I like the idea of the Refreshlinks, you jsut don't say
what to do with it.

Help me please.

Amy