Hello,

I have an ASP / Access 2ooo Database issue :(



 I am working on a Forum program to help me learn ASP. Almost everything 

works great with a few exceptions.



 The exception that is giving me the hardest problem is Multiple Users 

Accessing Database error: "80040e21 You & another user attempt to change 

same data blah blah"



 I get this when my friend and I try to post a message at the same time to 

the forum. If we click submit too close to eachother boom error.



 My question is how to I resolve this issue? I would think anyone that has 

created an ASP guestbook or Message Board would have incountered this 

problem...



 How can I fix this??? My forum is basically useless if more than 2 people 

are on at once making changes :( How is everyone correcting this problem? 



1)Is there a way to que database accesses? 

2)or perhaps it has to do with now the database is open?

3)or ???



 Any help greatly appretiated.



Sel

One way to counteract this would be to upgrade to MSDE or SQL Server as 

Access is only file-server allowing only one user per table at any one 

time.  

Or you could try breaking your database/s into multiple tables to try and 

diffuse the attention.

You could also make a page that opens when there is an error and stores 

the submitted data.  all you would have to do then is say on this page:



Sorry there has been an error, press here to resubmitt



or something like that, with a link to the origionally requested page.



hope this is of help



> Hello,

> I have an ASP / Access 2ooo Database issue :(

> 

>  I am working on a Forum program to help me learn ASP. Almost everything 

> works great with a few exceptions.

> 

>  The exception that is giving me the hardest problem is Multiple Users 

> Accessing Database error: "80040e21 You & another user attempt to change 

> same data blah blah"

> 

>  I get this when my friend and I try to post a message at the same time 

to 

> the forum. If we click submit too close to eachother boom error.

> 

>  My question is how to I resolve this issue? I would think anyone that 

has 

> created an ASP guestbook or Message Board would have incountered this 

> problem...

> 

>  How can I fix this??? My forum is basically useless if more than 2 

people 

> are on at once making changes :( How is everyone correcting this 

problem? 

> 

> 1)Is there a way to que database accesses? 

> 2)or perhaps it has to do with now the database is open?

> 3)or ???

> 

>  Any help greatly appretiated.

> 

> Sel

>