By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Subscript Out Of Range Error

100+
P: 184
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?
Jun 8 '07 #1
Share this Question
Share on Google+
6 Replies


ADezii
Expert 5K+
P: 8,616
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.
Expand|Select|Wrap|Line Numbers
  1. ReDim MyArray(1 To 10) As String
  2. MyArray(11) = "Some String"
Jun 11 '07 #2

FishVal
Expert 2.5K+
P: 2,653
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.
Jun 11 '07 #3

100+
P: 184
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
Jun 11 '07 #4

100+
P: 184
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!
Jun 11 '07 #5

FishVal
Expert 2.5K+
P: 2,653
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.
Jun 11 '07 #6

ADezii
Expert 5K+
P: 8,616
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!
Jun 11 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.