Also you should not allow your users to input data into tables. Make forms for them to input the data into instead. Neil Squires
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Root Sent: Sunday, June 03, 2007 8:45 PM To: [email protected] Subject: [ms_access] Re: merging data? Dimitris, As far as I know you can split your database into front-end and back-end. Then put the back-end (with all the tables and only tables) on the computer playing the role of server. Put the front-end (with forms, etc.) on the various client computers. Of course the front-end MDBs must point to the back-end MDB. This may be what you have already done, and should work. When I did that I was concerned with performance. Since my application was a bunch of additions where it was unlikely they would try to add the same data I increased performance by having the initial additions go into a "TEMP" table locally on the client MDB. Then at the end of a batch, in my case bills of lading, I did an insert into the master table from the TEMP table - - insert into tblBilloflading select * from tblTEMPBilloflading; At the beginning of the batch I did a - - delete from tblTEMPBilloflading; I did that in 2003 and its still working fine in production Dick --- In [email protected] <mailto:ms_access%40yahoogroups.com> , "Dimitris" <[EMAIL PROTECTED]> wrote: > > Hi all, > > Is it possible to have two ppl entering data separately to a table? > > Here's the situation: I have a database and in order to reduce the > input time I'm thinking of letting two or more ppl do the input, at > home and stand-alone. > > Would that be possible? Is it indeed possible to merge afterwards the > data of two different -but then again, completely identical- tables > belonging to different databases? > > Thanks :^) > Dimitris > [Non-text portions of this message have been removed]
