My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 multiple instances
|
|
 Jul 28 2006, 06:35 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 152 From: New York, NY  |
I have three related .mdb files - db1, db2, and db3. (Based on suggestions from my illustrious advisors here), db1 all the tables, db2 and db3 have only table links to the first portion.
Also, tblMain has the majority of the information. db2 writes to part of the data table and db3 writes to another portion of that same data table. 1. If users are entring data into tblMain through db2 and db3 at the same time, will that cause a problem? 2. Can I generate multiple instances of db2 and db3 to be used at the same time as long as there is still only one set of real data tables in db1? Jason |
 |
 
|
|
Jul 28 2006, 07:28 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 7,990 From: Philippines |
Hi;
It is called ... Back-End (BE) -- Tables Only '*** Placed in a Server or in a dedicated PC (Always have power ON) Front-End (FE) -- Linked tables from BE -- Queries -- Forms -- Reports -- Macros (I used only Autoexec and AutoKeys) -- Modules '*** to be placed in each PC/Workstation HTH. |
|
|
|
|
Jul 29 2006, 08:59 PM
Post
#3
|
|
|
UtterAccess Addict Posts: 152 From: New York, NY |
I understand the names. Maybe it's a dumb question, but if I have multiple front-ends accessing the same tables with no fancy append functions, but just direct data entry through the forms, will it be a problem?
Like db2#1 and db2#2 are on two computers and open at the same time. Also, db3#1 and db3#2 are also lined up. User #5 has the other application and wants to view all the records. All users see 500 records to start with, for example. users 1 and 2 start a new record and enter info into fields 3-6. users 3 and 4 enter info into fields 7-10. If after all this all the users refresh the forms they're using, they will alll see 504 records, no problem with the right info? |
|
|
|
|
Jul 30 2006, 11:02 PM
Post
#4
|
|
|
UtterAccess VIP Posts: 7,990 From: Philippines |
It would depend on how you design and normalize your database.
|
|
|
|
|
Jul 30 2006, 11:06 PM
Post
#5
|
|
|
UA Forum Administrator Posts: 38,073 From: Birmingham, Alabama USA |
No 2 users can edit the same record at the same time ...
Other than that .. all should see and edits or additional added records. It will require a periodic refresh on each machine to update the changes and new records ... RDH |
|
|
|
|
Jul 30 2006, 11:18 PM
Post
#6
|
|
|
UtterAccess Addict Posts: 152 From: New York, NY |
It sounds like things will work out ok. I'll do some testing on it and see. Thanks for the info.
|
|
|
|
|
Jul 30 2006, 11:20 PM
Post
#7
|
|
|
UA Forum Administrator Posts: 38,073 From: Birmingham, Alabama USA |
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 24th May 2013 - 04:12 AM |