Novice to splitting

J

jenniferspnc

My question(s) will sound silly but I am new to the splitting concept.

I put the database on the shared drive and then and went through the Split
Wizard where it created the export_be.mdb on the shared drive and the other
export.mdb (which I am assuming is the front end).

Now question, how do I get the other users to get to the FE? Do I have them
right click on the export.mdb and select create a shortcut? Or is there
another (better) way to do it? If someone can give me the step by step
instructions or point me to an article that does (based off the wizard) it
would be very helpful.

Thanks in advance!
 
F

fredg

My question(s) will sound silly but I am new to the splitting concept.

I put the database on the shared drive and then and went through the Split
Wizard where it created the export_be.mdb on the shared drive and the other
export.mdb (which I am assuming is the front end).

Now question, how do I get the other users to get to the FE? Do I have them
right click on the export.mdb and select create a shortcut? Or is there
another (better) way to do it? If someone can give me the step by step
instructions or point me to an article that does (based off the wizard) it
would be very helpful.

Thanks in advance!

On each user's computer, open their front end.
Then click on
File + Get external data + Link tables
Navigate to the back end database tables, and select them.
Click OK.
 
A

Albert D. Kallal

jenniferspnc said:
My question(s) will sound silly but I am new to the splitting concept.

I put the database on the shared drive and then and went through the Split
Wizard where it created the export_be.mdb on the shared drive and the
other
export.mdb (which I am assuming is the front end).

Now question, how do I get the other users to get to the FE? Do I have
them
right click on the export.mdb and select create a shortcut? Or is there
another (better) way to do it? If someone can give me the step by step
instructions or point me to an article that does (based off the wizard) it
would be very helpful.

I explain in detail some of the in's and out's of running a split database
here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

The above also explains what will happen when you try to modify table
structures, or add new fields to the database, and how now you have to
slightly change your approach as to how you make these changes.

To answer your question, the idea here is that you want to place a copy of
this new front end on each person's computer. after all, this is how most
users run and use their software, the software application is placed on each
computer.

Keep in mind this means that you want to link to the back end using the
linked table manager, but you wan to browse through network neighborhood to
get to the back end, not through a drive letter.
 
J

jenniferspnc

Sorry to sound dense, so to get the FE on the users desktop do I just copy
and paste the FE that sits on the shared drive? Both the FE and BE are on
the shared drive so I'm just wanting to make sure I get a copy to the users
desktops correctly...and sorry it may be way obvious but I don't want to mess
anything up. Thanks and I appreciate your patience.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top