Error of Splitting Database

Valerie Wong · External Since: Jul 01, 2009 Posts: 3

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 · External Since: Sep 25, 2003 Posts: 426

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" <ValerieWong DeleteThis @discussions.microsoft.com> wrote in message
news:E3F76EF6-D713-42B7-A808-DAEAAF71F73E@microsoft.com...
>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 · External Since: Jul 01, 2009 Posts: 3

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" wrote:

> 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" <ValerieWong.RemoveThis@discussions.microsoft.com> wrote in message
> news:E3F76EF6-D713-42B7-A808-DAEAAF71F73E@microsoft.com...
> >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 · External Since: Sep 25, 2003 Posts: 426

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" <ValerieWong.TakeThisOut@discussions.microsoft.com> wrote in message
news:A5A64E21-F72D-462F-99F2-94CE6B9384B9@microsoft.com...
> 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" wrote:
>
>> 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" <ValerieWong.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:E3F76EF6-D713-42B7-A808-DAEAAF71F73E@microsoft.com...
>> >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 · External Since: Jul 01, 2009 Posts: 3

Hi Gina,

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

"Gina Whipp" wrote:

> 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" <ValerieWong RemoveThis @discussions.microsoft.com> wrote in message
> news:A5A64E21-F72D-462F-99F2-94CE6B9384B9@microsoft.com...
> > 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" wrote:
> >
> >> 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" <ValerieWong RemoveThis @discussions.microsoft.com> wrote in message
> >> news:E3F76EF6-D713-42B7-A808-DAEAAF71F73E@microsoft.com...
> >> >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 · External Since: Sep 25, 2003 Posts: 426

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

"Valerie Wong" <ValerieWong.DeleteThis@discussions.microsoft.com> wrote in message
news:9898DE0B-B06B-46C6-8F6A-6BAAD23A299B@microsoft.com...
> Hi Gina,
>
> I use Access 2003 and I do import data from excel.
>
> "Gina Whipp" wrote:
>
>> 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" <ValerieWong.DeleteThis@discussions.microsoft.com> wrote in message
>> news:A5A64E21-F72D-462F-99F2-94CE6B9384B9@microsoft.com...
>> > 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" wrote:
>> >
>> >> 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" <ValerieWong.DeleteThis@discussions.microsoft.com> wrote in
>> >> message
>> >> news:E3F76EF6-D713-42B7-A808-DAEAAF71F73E@microsoft.com...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>