Problem creating tables

[M_Mike]

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 suggest what might be the cause.

Thanks

 

[KenHigg]

I'm going to guess that you have some kind of problem with a validation rule...

 

[M_Mike]

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?

 

[KenHigg]

Hum...

I would try compacting & repairing the db. Do you get this problem when you create a new .mdb and attempt to create a new table?

 

[M_Mike]

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.

 

[KenHigg]

Hum...

One last attempt: Make a new .mdb and import all your objects into it.

???

 

[M_Mike]

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?

 

[KenHigg]

I think you're hosed unless someone else has any ideas...

Can't you archive some stuff?

 

[Hayley Baxter]

Is it necessary to store the scanned documents in the database itself? Could be an option just to create a link to the scanned documents, will free you up a lot of space.

Hay

 

[M_Mike]

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 the right way to link the documents to the database). Is there another way to do this?

 

[Hayley Baxter]

It sounds as though you are inserting the documents in the database. The files will all be stored somewhere on a shared drive I imagine so all you need to do is create a hyperlink field in your database and store the path link to where the file is sitting. This way you are storing the path of the file rather than the file itself.

Hay

 

[M_Mike]

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 should then be able to use hyperlinks to link to the documents.

 

[Hayley Baxter]

Have you tried compacting the database again or importing to a new db now that you have removed the field storing the documents?

 

[M_Mike]

The import solved the problem, the database size has been reduced and works alot quicker. I just have to now change the forms to use a hyperlink instead of the OLe object.

Thanks for all your help and advice

If I have any other problems I know who to ask.

 

[KenHigg]

Didn't I suggest that in post #6 ???

 

[Hayley Baxter]

Didn't I suggest that in post #6 ???

Yep you did indeed Ken but that was before the field storing the scanned documents had been removed.

 

[KenHigg]

Yep you did indeed Ken but that was before the field storing the scanned documents had been removed.

.
.
.
oh

 

[M_Mike]

Didn't I suggest that in post #6 ???

OOOOOOpppppppppss!!!

Sorry, I think I was convinced that it was something else at that point.

 

[M_Mike]

Sorry to bother you again. But I am still working with this database. I was wondering if there was any way to create a macro that when a command button is pressed it brings the user to the hyperlink window and automatically displays the folder which contains the scanned documents.

 

[Hayley Baxter]

This should open explorer and display the folder of your choice

Private Sub cmdExplore_Click()
On Error GoTo Err_cmdExplore_Click

Dim stAppName As String

stAppName = "C:\WINNT\explorer.exe c:\MyFolder"
Call Shell(stAppName, 1)

Exit_cmdExplore_Click:
Exit Sub

Err_cmdExplore_Click:
MsgBox Err.Description
Resume Exit_cmdExplore_Click

End Sub

Hay