Joseph O'Connell
joconnell at indy.rr.com
Mon Apr 5 15:12:52 CDT 2004
>From the database window go to Tools|Options. Click on the Advanced tab. Change the "Default open mode" from Exclusive to Shared. Then click the Apply button. Joe O'Connell -----Original Message----- From: tuan nguyen <tuannj1810 at yahoo.com> To: accessd at databaseadvisors.com <accessd at databaseadvisors.com> Date: Monday, April 05, 2004 11:52 AM Subject: [AccessD] MULTI ENTRY to database |I am creating a customer database. the idea is that more than 2 |people can come in the file and update the record. however, whenever |there are more than 2 people on the file, there is a message something |like "you dont have exclusive access to the file, yr work might not be |saved"...(i set "shared" in tools/ options/advanced/ ) some times, other can not log on if i am on the file. then i have to get out before other can get in. |is there anyway to solve this? | |if i want each person input there initial when the log on the file |and want to have the file tells me who update the file last, is it |possilbe. can it tell the time it was updated? | |generally, does access work well with multi entry - many people working on same file, doing updates...? | |tks for help. | |tuan nguyen | |maersk inc, |madison, nj | | | | |--------------------------------- |Do you Yahoo!? |Yahoo! Small Business $15K Web Design Giveaway - Enter today |-- |_______________________________________________ |AccessD mailing list |AccessD at databaseadvisors.com |http://databaseadvisors.com/mailman/listinfo/accessd |Website: http://www.databaseadvisors.com