subscript out of range

  • Thread starter Thread starter Botello
  • Start date Start date
B

Botello

While using the databse splitter in access 2000, I get
the following error, "subscript out of range", after
cliking OK since this is the only option available I find
that the spliting of the databse never happens and one of
the tables does not get transfered to the back end
database and non of the tables in the application front
end are linked?, please help!!
 
Try creating the split manually. Make a copy of your main database and keep
in a safe place first.
Create a backend mdb with the name of your main database name and add _be,
such as MyDatabase_be.mdb. Then open this database and use File | Get
External Data | Import and import the tables from the frontend database.
Once the table successfully import close and reopen the database to ensure
all is well. If you have problems importing any table, then note the table
name as it may be corrupt and will need to be recreated.

Before opening your main database rename it and add _fe; such as
MyDatabase_fe.mdb. Open the database delete the tables. Then select File |
Get External Data | Link and locate the tables in you newly created backend;
MyDatabase_be.mdb.
 
Back
Top