Question Database Splitter - Subscript out of range

[George.T.Walters]

Posted this to the wrong Forum the first time. Sorry

I have mostly done very rudimentary uses of Access to date for my own isolated use. I have a database that my client would like to share across multiple users. We are having difficulty with table locking just having whomever open the shared file.

I have tried to use the "Database Splitter", but with no success. It creates a ". . .be.mdb" file, but before it is finished displays the "Subscript out of range" message.

I followed the instructions and copied the database file to my laptop to split it, but that gave the error.

I tried to split the database from the "shared drive" on the network. Same error.

What else can I do? What might be causing this error?

Thanks,
George

 

[Mr. B]

If the Database Splitter has already created the back-end file and then you attempted to run it again, it is quite possible to see an error due to the fact that the tables would no longer exist in what has now become the front-end file. The tables would now be located in the new back-end file (the one with the _be in the file name.

If you open the file you used to run the Splitter, you should see an arrow at the left side of the name of each of your tables indicating that they are now "linked tables".

It may be that you accomplished what you were attempting to do the first time you tried it.

Other than seeing the small arrow to the left of the table name, if you double click the table it would open and appear exactly as if it were a table in the file you currently have open, when, in fact, the table actually exists in the new back-end file.

Other than the "Subscript out of range" message, are you getting any other error messages?

 

[George.T.Walters]

Mr. B,

Thanks for replying. I did not explain myself well.

I received the error on the first attempt. Between each additional attempt, I deleted the "BE" file that was created and the "mdb" file I was in when the Database Splitter was ran. I restored from the "copy" that I made as in the instructions.

Based upon your comments, I tried again and went in to look at the "mdb" file tables and none of them have arrows in front of them. This last time I did go into the "BE" file and it does have the tables (and data) that the orginal "mdb" file has. It appears the tables are created in the "split" database, but this error is not allowing the process to complete and replace the tables in the "application" (mdb) file with links to the "split" (BE) database. (Probably not using the right words here, but I hope you know what I mean.)

Any other ideas?

Thanks again for your response.
George

 

[Mr. B]

George,

If you now have a back-end file with the tables in it, take a copy of what would become the front-end file and just delete all of the local tables from it. The use the Linked Table Manager to locate the back-end file and link the tables in that file to your front-end file. That is the same thing that the Database Splitter is doing. You can just do it manually with the Linked Table Manger.

 

[George.T.Walters]

Mr. B,

Thanks so much. The manual linking of the tables worked great.

It is all working well.

Thanks again,
George