MS Access ( Now you See Them ... Now you don't !!!)

[razzaj]

well ... yes Imagine working on a 10 table DB for an Internet (ASP) project ... when suddenly out of nowhere MS Access starts Generating nice "unidentified error" and others .. while you know your code is working just fine ... coz 2 minutes ago it was ... well yes I guess Now you See them Now you dont ....

The problem occures when multiple users are trying to access the DB ont the NT Server Via ASP from different PCs...

Now the problem is solved ... you guessed how ??
SQL Server 7.0 .... ( Many kisses to SQL 7)

But If anyone knows Why MICROSOFT <--- (WOW) Access goes nuts on multiple access ???? let us Share ...

[JasonGS]

I don't know if it's the cause of your problem or not, but a while back before I realized the importance of recordset lock types, I would get corrupt and strange data in Access. Now that I use lock types and use them correctly, I can't say I have had a problem since.

[razzaj]

I always pay attention to locking types ... and I never omit them ... I am pretty sure I use them correctly depending on what I want to do ... Read/Write etc...

Besides The same Code Works Perfectly On SQL 7 , with as many users as one wants.

I really dont know .... All I know is that I hate Microsoft for their Bugs ...