Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / April 2008

Tip: Looking for answers? Try searching our database.

Novice to splitting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jenniferspnc - 30 Apr 2008 20:52 GMT
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!
fredg - 30 Apr 2008 21:01 GMT
> My question(s) will sound silly but I am new to the splitting concept.  
>
[quoted text clipped - 9 lines]
>
> 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.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

jenniferspnc - 30 Apr 2008 21:19 GMT
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.

> > My question(s) will sound silly but I am new to the splitting concept.  
> >
[quoted text clipped - 15 lines]
> Navigate to the back end database tables, and select them.
> Click OK.
Albert D. Kallal - 30 Apr 2008 21:18 GMT
> My question(s) will sound silly but I am new to the splitting concept.
>
[quoted text clipped - 9 lines]
> 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.

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.