My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 To Split or not...
|
|
 Mar 19 2007, 08:19 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 237 From: Ohio  |
This is the question .
I have been asking several people about splitting a database or not. There will be 2,possibly 3 users on a shared drive. I am getting conflicting answers....sooooooooooooooooooo.... I need opinions; the good, the bad, and the ugly! Thanks, Trish |
 |
 
|
|
Mar 19 2007, 08:24 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 9,209 From: Maryland |
|
|
|
|
|
Mar 19 2007, 08:31 PM
Post
#3
|
|
|
Utterly Banned Posts: 6,006 From: Brisbane Qld Australia |
There is no alternative. SPLIT.
The Ugly is with an unsplit system you run the risk of Data Corruption. |
|
|
|
|
Mar 19 2007, 08:35 PM
Post
#4
|
|
|
UtterAccess Addict Posts: 237 From: Ohio |
Got it...the database shall be split!
Thank much Trish |
|
|
|
|
Mar 19 2007, 08:38 PM
Post
#5
|
|
|
Utterly Banned Posts: 6,006 From: Brisbane Qld Australia |
Glad you got the hint.
|
|
|
|
|
Mar 19 2007, 08:47 PM
Post
#6
|
|
|
UtterAccess Editor Posts: 16,032 From: Northern Virginia, USA |
... Did anyone tell you to go with the Split database configuration? ...
. . . (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif) . . I even split my db apps when they are single user!!! It is also important to note that the FE (Front End - Forms, Report, Queries, etc ..) is NOT shared ... each user should have their OWN copy of the FE either on their own hard drive or on a private network folder... |
|
|
|
|
Mar 19 2007, 09:11 PM
Post
#7
|
|
|
UtterAccess Addict Posts: 237 From: Ohio |
Everybody so far has said to split it...so I will. I have only created single user DB's so I never really had this issue before. I will check out the suggested link and practice on my own sample stuff first.
Thanks for the input! Trish |
|
|
|
|
Mar 19 2007, 10:49 PM
Post
#8
|
|
|
UtterAccess Editor Posts: 13,813 From: England (North East / South Yorks) |
Brent says:
>>> "I even split my db apps when they are single user!!! " I say: Everyone should split their applications even when only a single user! :-) |
|
|
|
|
Mar 19 2007, 11:54 PM
Post
#9
|
|
|
UtterAccess VIP Posts: 18,427 From: Oklahoma City, Oklahoma |
Split!
Is there any other way? I always create split Access databases. Even for single users. It just makes development so much easier ( Example, linking to test data sets). Backups are easier. etc. ... |
|
|
|
|
Mar 20 2007, 07:53 AM
Post
#10
|
|
|
UtterAccess Addict Posts: 237 From: Ohio |
I am going to split it tomorrow ..BUT...everyone be prepared for more questions when I do!
|
|
|
|
|
Mar 20 2007, 10:01 AM
Post
#11
|
|
|
UtterAccess Editor Posts: 16,032 From: Northern Virginia, USA |
... Don't worry ... we will all split! ... just kidding! ... we will all do our best to help you out!!!
|
|
|
|
|
Mar 23 2007, 05:29 PM
Post
#12
|
|
|
UtterAccess Addict Posts: 237 From: Ohio |
I think I have this working. I created an MDE form the MDB. I split the MDE and distributed it tonight (practicing on my home computers first!). So far so good but me thinks updating is going to be a pain in the tush!
Does this process work the same for an ADE with a SQL background? The school I work at needed a form added to the database...easy enough. I put the form in the ADE, again, all is well. Now I am terrified to split/replace the original. Does this make sense or do you need more info? |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 19th June 2013 - 05:26 PM |