Error of Splitting Database

[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

 

[Gina Whipp]

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

 

[Valerie Wong]

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

 

[Gina Whipp]

Valerie,

Pardon delay, enjoying holiday...

What version of Access and how are you splitting the database? Another
thought, are you importing/exporting and Excel, text or .csv files?

--
Gina Whipp

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

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

 

[Valerie Wong]

Hi Gina,

I use Access 2003 and I do import data from excel.

 

[Gina Whipp]

Valerie,

I lost this post for a bit there... Did this get resolved? If not I need
you to list the References (Any code module - Tools - References) and list
the field names.

--
Gina Whipp

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

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