"Subscript Out of Range" shows up when I tried to split my databas

G

Guest

I did split my database, but none of the tables show links to the original
database. ... I've seen "subscript out of range". The back end db is created
but not front end.
What causes this? Thanks for help.
 
G

Guest

Before splitting did you run compact and repair? You might have had some
corruption starting and the split process hit that and couldn't continue.
Hopefully you have a copy to start from again. If you do, run compact and
repair and I would even possibly import everything into a new mdb file so
that you can hopefully start fresh. You should go into the VBA code window
and go to DEBUG > COMPILE to compile the code too, as that might show you
some errors that might be causing problems.

If you don't know how to get to the code window, look here for instructions:

http://www.btabdevelopment.com/main/QuickTutorials/Howtogettothecodewindow/tabid/72/Default.aspx


--
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subscript out of range when importing into access 2010 from excel 0
subscript out of range 1
I get the message subscript out of range when I am importing 1
Subscript out of range when splitting 1
Splitter error after making back end file. 1
Run-Time 9 Subscript ouf of Range Error 4
when splitting tables, wizard says "subscript out of range" 2
ERROR: subscript out of range 6

Top