Subscript Out Of Range Error

[bloukopkoggelmander]

Hi all. I use Access 2007. I have linked tables set up to a AS400 server. When I try to split the database, I get the following error : Subscript out of range.

I have no idea what this mean. I have googled it, but not much clearer on this.

Any idea anyone?

[ADezii]

Hi all. I use Access 2007. I have linked tables set up to a AS400 server. When I try to split the database, I get the following error : Subscript out of range.

I have no idea what this mean. I have googled it, but not much clearer on this.

Any idea anyone?

You typically get this Error when you try to reference, or set a value to, an invalid Array Index. The following code will generate this Error, since you are trying to assign a value to an invalid Array Index (11). I don't have the slighest idea why this type of Error would occur during an operation that you described.

ReDim MyArray(1 To 10) As String
MyArray(11) = "Some String"

[FishVal]

Hi all. I use Access 2007. I have linked tables set up to a AS400 server. When I try to split the database, I get the following error : Subscript out of range.

I have no idea what this mean. I have googled it, but not much clearer on this.

Any idea anyone?

Hi!

Try to split your database manually.
1) Open blank database.
2) Link in it all tables from your database.
If it fails, try to link tables one-by-one to localize your problem. I think the problem may be with your server linked tables.
3) Import all other objects: queries, forms, reports, modules.

Good luck.

[bloukopkoggelmander]

ADezii,FishVal

Thank you for the replies from both of you. ADezii, as you described, yes it is a bit strange that that error will appear as I am not even close to an Array( Only have 1 in my database so far anyway). I am only trying Accesss's split tool.

FishVal, I will try your suggestion and then see if it works ok.

Thanks to both

[bloukopkoggelmander]

Hey FishVal

I tried your suggestion and it works fine. Opened a new database, linked all the tables to the AS400 server and then imported the queries,macros and forms from the original database and all tested fine.

Thanks!

[FishVal]

ADezii,FishVal

Thank you for the replies from both of you. ADezii, as you described, yes it is a bit strange that that error will appear as I am not even close to an Array( Only have 1 in my database so far anyway). I am only trying Accesss's split tool.

FishVal, I will try your suggestion and then see if it works ok.

Thanks to both

As far as I know Access wizards (particulary Split wizard) are written in VBA. So it can be an unexpected and unhandled error in one of Access hidden modules.
This may be a explanation, but not a helpful one of course. Thats why I've suggested you to perform manual split.

Good luck.

[ADezii]

As far as I know Access wizards (particulary Split wizard) are written in VBA. So it can be an unexpected and unhandled error in one of Access hidden modules.
This may be a explanation, but not a helpful one of course. Thats why I've suggested you to perform manual split.

Good luck.

It happened to be a very good, and of course correct, explanation. Good save!