[AccessD] MULTI ENTRY to database

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





More information about the AccessD mailing list