A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Split database before or after sending out



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2010, 01:24 AM posted to microsoft.public.access.gettingstarted
forest8
external usenet poster
 
Posts: 196
Default Split database before or after sending out

Hi there

I am about ready to send the Access Database to a friend who's asked me to
create a database for him.

Since I don't know how his network is set up, should I split the database
before I send it to him or tell him how to split it after sending it out to
him?

Thank you

  #2  
Old April 9th, 2010, 02:23 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Split database before or after sending out

On Thu, 8 Apr 2010 17:24:01 -0700, forest8
wrote:

Hi there

I am about ready to send the Access Database to a friend who's asked me to
create a database for him.

Since I don't know how his network is set up, should I split the database
before I send it to him or tell him how to split it after sending it out to
him?

Thank you


By all means split it first. You'll need to send the recipient both databases;
instruct him to put the backend in a folder to which all the potential users
will have full (read, write, create, delete) permission. They can then open
the frontend and use Tools... Database Utilites... Linked Table Manager (in
2003 or before), or Database Tools... Linked Table Manager to connect to the
new location. Tell them to select all the tables and navigate to the backend
via Network (or Network Neighborhood). They can then make copies of the
frontend for all the users.
--

John W. Vinson [MVP]
  #3  
Old April 11th, 2010, 09:51 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Split database before or after sending out

The following link has a file which demonstrates how you can automatically
check the validity of links to the backend at start-up and provide a painless
way for the user to refresh the links. It includes versions for both single
and multiple back ends:

http://community.netscape.com/n/pfx/...g=ws-msdevapps


Ken Sheridan
Stafford, England

forest8 wrote:
Hi there

I am about ready to send the Access Database to a friend who's asked me to
create a database for him.

Since I don't know how his network is set up, should I split the database
before I send it to him or tell him how to split it after sending it out to
him?

Thank you


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.