avoiding id duplication in shared file

[ll]

I'm working with a project log form in Access which is 'shared' and on
the local network.
The form uses the record number as the 'project number' .
When several users are using the log at the same time, it will save
the entries as desired for the first person to access the form, but
the other people will get subsequent numbers. Besides locking access
down to one user at a time, is there a way to notify the user of the
number changes, perhaps by email?
Thanks,
Louis

 

[Todos Menos [MSFT]]

if simple things like autonumber aren't reliable enough for you-- then
you should move to SQL Server and Acces Data Projects

 

[ll]

Thanks for your help,
Louis

 

[Tony Toews [MVP]]

if simple things like autonumber aren't reliable enough for you-- then
you should move to SQL Server and Acces Data Projects

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[ll]

Well, I'm relieved. ;-)

 

[Todos Menos [MSFT]]

why are you relieved?

because you're fat and lazy and you don't need to learn a new language

your job should go to india, ****tards in america are too lazy to use
a real database

 

[Todos Menos [MSFT]]

SQL Server allows trigger notification via email

CREATE TRIGGER and XP_SENDMAIL

 

[Tony Toews [MVP]]

why are you relieved?

because you're fat and lazy and you don't need to learn a new language

<additional racist comments snipped>

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Todos Menos [MSFT]]

RACIST? RACIST?

HOW IS IT RACIST TO SAY THAT LOW-END DATABASE WORK GOT OUTSOURCED TO
INDIA A DECADE AGO?

note that tony is neither

MOST
VALUABLE
or a
PROFESSIONAL


anyone with a clue would have started using SQL Server a decade ago;
it is a completely superior platform in all regards-- with no
negatives

only a retard that can't learn a real database would ever use Access
MDB
I mean get real-- move to ADP or real VB-- either way, Access MDB is
dead and it has been for a decade