Search results

Does access store a reference to documents inserted into the database anywhere else, as I have removed the entire field that has been setup to store the scanned documents (I have taken a backup of the orginal), but it has not reduced the size of the database. If I can get it to reduce the size...

I thought of creating an archive but it will oonly save around 58Mb. I think the scanned documents may be just linked. I think the process used is as follows: In the table the field is right clicked and Insert object is selected, then create from file then the document is selected. (Is this...

I think I know what is causing the problem. The database has managed to reach the 2Gb limit, mainly because it contains scanned documents. Do you know of any why to increase the limit?

I get the same 'Invalid Argument' when I try to compact and repair the database aswell. The problem doesn't occur when a new database is created. I have also tried to convert the database into Access 2002 format, but it just hangs the system.

I don't think that any validation should be taking place as the problem occurs even if I try to create a test table with one field in it. I also noticed that it was in an Access 2000 format when I am using Access 2002. Could this also be causing the problem?

I am having problems trying to create a new table in an existing database I am working on in Access 2002. When I try to save the new table I receive an error message saying 'Invalid Argument'. I have checked if the database is locked but can't find anything to suggest that it is. Can anyone...

I have entered the code into the database but when I click the apply filter button I receive the following error message: Run-Time error '2001': You canceled the previous operation. :confused: I am unsure as to how to correct this but the problem seems to occur at the point when the filter is...

I have created the combo box and it shows the values I want from the other table, but when I try to select on of the enteries, nothing happens and access just beebs. Could anyone suggest what might cause this.

I am creating a database to log faults with a system. I have created a form which allows the user to enter the details of the fault. But I also want to be able to display information about the location of the fault on the same form when a selection is made in the combo box. For example I have...

That looks like exactly what I need. I'll try it as see if it works. Thanks again.

I want to filter the information displayed on a form using the values I select in text or combo boxes. I want to filter the form using one or more of the following options. Call Ref - text box Location No - Combo box Area - combo box Status - combo box The combo boxes are taking their values...