Recent content by JC3

Hi, I use a number of tables as data for Combo boxes (i.e. Equipment List, Site Lists etc.). Using these directly linked to the BE DB was quite slow so therefore I run queries on startip of the DB to copy the data from the BE to the FE and base the queries on the FE. This all works fine and I...

I tried using this code and while it didnt stop the error it did manage to hide it. Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 3021 Then Response = acDataErrContinue Else Response = acDataErrDisplay End If End Sub JC

I can't see any difference between the Table Definitions. The table was a direct copy from the FE to the BE with no changes so should be identical in every respect except it is on the BE. I have added another layer to work round this. i.e I am appending the data to a temporary file in the FE...

I am wanting to run a query in my FE which takes data from a Linked DB and copies this to my BE for general user access. The query itself contains three tables with the final table being a Left Outer Join. If I run this query to append to a table in my FE it runs fine. If I run it to append...

After given further thought to this I came up with the exceedingly simple solution. Simply take the Total Calls subtract the Calls in Area 1 & Area 2 and add this to the chart as Other Calls. Then all three fields can be plotted on the Primary axis thus avoiding the issue. Its funny how...

Hi I have three figures to display in a chart. The Total Ongoing Calls The Ongoing Calls in Area 1 The Ongoing Calls in Area 2 Ideally the Total Ongoing Calls should equal the other two but this is never the case due to calls in wrongs areas etc. To display this I have the Total Ongoing...

Hi I am in the process of designing a Intranet Site using Front Page. In the website there are a number of charts using Office Web Components which require data from an Access DB. The DB itself takes a data dump every 15 minutes from a SQL DB. This is to ensure that the data is up to date...

Thans Everyone. I will try the re-install and if that doesn't work I'll see if I can convince them to pay for an upgrade for Access 2000 users (I can always hope). Thanks again. JC

My machine has been fine therefore understandably all my testing has been on the users machine to try and identify the problem. I would also advise a) The DB's worked fine up until a week or two ago. There have been no major changes since then. b) Another DB is also showing exactly the same...

Hi all I have done some testing with the /decompile switch and when this is added to the DB shortcut the DB appears to run fine (slower obviously but no crashes). From everything I have read about Decompile people advise not to use it regularly. If this is true is there a way to...

The DB was and Access 2000 version originally created using 2002. I have tried to compile the DB and check for references and no errors. This wouldn't explain why it works fine the first time you go into it and not the second time. Is it possible that it is leaving some remnant in memory which...

Hi I have a DB which has been up and running with no problems for a couple of months. A couple of users have recently had new machines installed. These are XP SP2 with Office 2000. The Database FE is on the PC and the Backend is on the server. When FE is first downloaded and opened it...

Memo field limit This Audit Trail has been working for a few months on my DB but I am now getting Could not find Field 'Description' As far as I can see this is due to the large size of the Audit Trail field which in some cases can be as high as 20,000 characters. Has anyone got any better...

I can do that on an individual basis as and when it occurs. But it means unsecuring the backend, deleting and recreating references, resecuring the DB. And then next time there is an update rolled out it all starts from scratch. That is why I am trying to find a more user friendly way of...

Hi I have designed a couple of DB's using Access 2002 in Access 2000 format. While these all work perfectly in Access 2002 there a few users still using Access 2000 and are experiencing errors (specifically with Graph.exe which is 10.0 in 2002 and 9.0 in 2000 and also with the Calendar Control...