Split database

[nancy54]

Hello,
I am trying to split a database, but I am getting a message 'Subscript out of Range.' The _be copies in the remote location, but the tables remain in tact in the database.

Thanks, Nancy

 

[isladogs]

You may have some number fields that have reached the integer limit - approx 35500 IIRC. Change to long integer

 

[shadow9449]

Hello,
... The _be copies in the remote location, but the tables remain in tact in the database.

Nancy:

What do you mean by "remote location"? Is it on a server connected to the client computer on a LAN or literally a computer that is offsite?

 

[nancy54]

I am saving it to a different drive on the same server.

 

[Gasman]

Try manually splitting as mentioned here

Also have a look at the other threads?

 

[nancy54]

I now realize that the linked tables for the Subdatasheet and dropdown boxes did not get copied to the back end. I guess I have to reestablish these after I do the manual split??
Nancy

 

[CJ_London]

yes, but generally subdatasheets are not a good thing to do if you want a decent performance