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

B

bjnova

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?
 
T

Tony Toews

bjnova said:
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?
Click to expand...

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
 
A

amy navarro

Tony Toews said:
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
Click to expand...
 
A

amy navarro

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
 
Top