[AccessD] MULTI ENTRY to database

Gary Kjos garykjos at hotmail.com
Mon Apr 5 17:43:56 CDT 2004


Hi Tuan,

It could be that your users do not have full file creation rights in the 
folder where the database is. The users need to have the rights to create a 
file so a LDB locking file can be created. With no licking file it allows 
ONE user but not a second.

Access works fine with multiple users lots and lots of apps around that do 
that. You will do well to investigate how to best make a database that works 
well for multiple users simultaneously though. Generally a split database 
with a front end and a back end will be the best way although there are 
exceptions and special circumstances when this may not be entirely correct 
either. A front end database contains everything in the database EXCEPT the 
data tables, and the back end contains ONLY the data tables. You create 
LINKS in the front end to point to the tables in teh back end.   If you 
search in help on Multi-user database you should find some info on this 
issue.

In order to log when people sign in to your database and keep track of what 
they update, you will need need to create some tables to store that info and 
some code to populate those tables that track that info. Nothing is 
available in Access by itself to track those changes, you have to do it 
yourself. You can certainly dd a field like "LAST_UPDATE" and then write a 
small bit of code in your form to update that field whenever there is a 
change to the record. Look at the Before Update event on a form and set the 
"LAST_UPDATE" field to NOW()

Gary Kjos
garykjos at hotmail.com





>From: tuan nguyen <tuannj1810 at yahoo.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] MULTI ENTRY to database
>Date: Mon, 5 Apr 2004 09:13:45 -0700 (PDT)
>
>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

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.com/go/onm00200415ave/direct/01/




More information about the AccessD mailing list