Recent content by Mez

That was my first impression from the error message Access gave me, saying a user 'unexpectedly' quit the program. But I have run the Db in a test environment, with limited users, and am almost 100% certain the crash occured when all users were in the Db, and had not exited. However, I use links...

Database Crashes Never did sort this :mad: Db is still crashing on a regular basis, I now think it is something to do with the number of concurrent users, which has grown from about 5 when I first wrote it to around 30 now. Dont think Access likes that many users, so am in the process of...

Many thanks but this does not really help, the database can repair itself each time, I do not think it is actually getting corrupted, or if it is it is only minor, the fact this is happening regularly, and has only been happening for a short period of time, at first made me think it could be a...

Access 2000 ver 9.0.3821 SR-1

Hello All, In the last 4 days my Access database has crashed 15 times, coming up with the message 'Run Time Error 3343 - Unrecognised Database Format'. The DB is used in a multi-user environment, and has been running smoothly (ish!) for about a year, this has only just started happening. If I...

:D Many thanx people, all my problems are now sorted. OK, rounding 1/2 pennies up aint all my problems, but hey, its a start.

Hello all, hope one of you can help me before I throw myself under a bus! Got an access query with a Net figure in one of the fields (£351.00). Working out the VAT with the rounding command (Round(([Net]*1.175),2). Getting £61.42. Should be £61.43 as the actual unrounded fig is £61.425. Any...