Split database (1 Viewer)

N

nancy54

Registered User.

Local time

Today, 09:32

Joined

Jun 19, 2018

Messages

49

• Oct 15, 2018

• #1

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

MVP / VIP

Local time

Today, 14:32

Joined

Jan 14, 2017

Messages

18,216

• Oct 15, 2018

• #2

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

 

S

shadow9449

Registered User.

Local time

Today, 09:32

Joined

Mar 5, 2004

Messages

1,037

• Oct 15, 2018

• #3

nancy54 said:

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

Click to expand...

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?

 

N

nancy54

Registered User.

Local time

Today, 09:32

Joined

Jun 19, 2018

Messages

49

• Oct 15, 2018

• #4

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

 

Gasman

Enthusiastic Amateur

Local time

Today, 14:32

Joined

Sep 21, 2011

Messages

14,269

• Oct 15, 2018

• #5

Try manually splitting as mentioned here

Also have a look at the other threads?

 

N

nancy54

Registered User.

Local time

Today, 09:32

Joined

Jun 19, 2018

Messages

49

• Oct 15, 2018

• #6

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

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 14:32

Joined

Feb 19, 2013

Messages

16,607

• Oct 15, 2018

• #7

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