Error of Splitting Database

  • Thread starter Thread starter Valerie Wong
  • Start date Start date
V

Valerie Wong

I keep getting the message "Subscript out of range" when I tried to split the
database. I have followed Allen Browne's procedure to make sure the database
is not corrupted, what else can I do?

Regards,
Valerie
 
Valerie Wong,

Since this error is normally associated with Excel/Access interactions I am
curious... what steps are you taking to split your database?

To attempt to track down the error I would try to Complie your database, to
Compile...

1. Go to the Forms tab
2. On the Menu Bar select the 'Code' button
3. Select Debug then Complie - Fix any errors that pop-up.

Before compiling you might want to make sure at the top of every module it
says...

Option Compare Database
Option Explicit

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Hi Gina,

Many thanks. The access database does not have any link to Excel so I would
doubt that being a reason of error. secondly I have already compiled the
database. Any other possible reasons that could lead to the error?

Many thanks in advance.

Valerie
 
Back
Top