How to split a database

Question

Hello,

I tried to split my database with the splitter wizard and got this error message: "Subscript out of range"

The Back-End database is created but the tables are not linked.

What could possibly be the problem and how can I solve it?

Answer 1

Hello,

I have been able to debug the code errors.

The new problem I noticed is this error message:

"Can not open any more databases"

I search for it and I got this result:

"You have reached the limit on the number of databases that can be opened at one time. Close one or more databases and try the operation again."

I am confused about this message and don't know what to do about it.

Meanwhile I know I don't have any other database open.

Answer 2

You need to quote error messages VERBATIM, and include the code where it happens, and indicate the line where the error happens.

One way to do that is when the error occurs, hit Ctrl+Break to break into the debugger. You may be in an error handler. Execute a Resume statement to get to the line causing the error.

Answer 3

VBA code should work the same on linked tables as local tables. Without knowing the code and the errors its impossible to advise.

Answer 4

Thanks,

I have successfully split the database into two new ones (ie. the back end with only the tables and the front end with other database objects) and linked the tables accordingly.

However, I noticed that most of my codes that previously worked well prior to this action have started producing errors.

What could be the problem and what can I do about it?

I await your quick response please.

Answer 5

Does the application compile before you split it?

Alt+F11 to open VBA editor > Debug > Compile

Of course it's not hard to select External Data > Access > Link and link the tables yourself.