Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 06-27-2011, 02:39 AM   #1
Newly Registered User
Join Date: May 2011
Location: Lancashire, UK
Posts: 32
Thanks: 8
Thanked 4 Times in 4 Posts
Manic_Rach is on a distinguished road
Question Database Splitting

Hey guys, just wondering if you could clear a few things up for me.

I'm splitting a database so that multiple users on a network can use it.
I know how to split it both manually and using the wizard.

My questions are:

1. Is the end product different depending on whether you split it manually or through the wizard?

2. If two people are to enter the same information at the same time, will it save as duplicates (even though duplicates aren't allowed). If it won't allow the duplication, will both users get an error or just the one who saves later?

Manic_Rach is offline   Reply With Quote
Old 06-27-2011, 04:36 AM   #2
Newly Registered User
ChrisO's Avatar
Join Date: Apr 2003
Location: Brisbane, Australia
Posts: 3,202
Thanks: 7
Thanked 275 Times in 195 Posts
ChrisO is just really nice ChrisO is just really nice ChrisO is just really nice ChrisO is just really nice
Re: Database Splitting

1. I really can’t say because I’ve never used the wizard to split a database; I’ve always done it manually.
In general, if I can do something manually I don’t use wizards.

2. Refusal to accept duplication would be at the high end of reliability for Access.
First in best dressed; everyone else gets an error.

Access 2003, Win7, GMT +10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ChrisO is offline   Reply With Quote

database splitter , split , splitting

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Splitting a database Tumby General 4 01-25-2009 10:01 AM
Database splitting bikeboardsurf General 1 09-10-2005 06:10 AM
Splitting a database bill1282 General 2 05-03-2004 10:47 AM
database splitting? iangirven General 3 03-22-2003 09:50 AM
Splitting a database cliffsimms Reports 0 01-12-2001 11:18 AM

All times are GMT -8. The time now is 12:19 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World