Splitting database

Resolved · High Priority · Version 2007

Thu 13 Nov 2008, 16:11 Delegate Sarah said...

Sarah has attended:
Access Introduction course

Splitting database

Hi,

I am trying to split one of our databases but it tells me after a while that "Subscript is out of reach" - does anyone know what that means?? I've never come across this error when splitting other databases....

Thanks

Fri 21 Nov 2008, 13:20 Trainer Laura said...

RE: Splitting database

Hi Sarah

Thank you for the question regarding splitting a database. That is an error that I have heard of but never experinced first hand.

Have you tried doing a compact and repair of the database before you begin?

The database does not sound 100% and although it might be working fine I would guess there is some form of corruption starting. Create a blank database and then import all the objects from the first database and see if that works.

Let me know how you get on.

Laura GB

Fri 21 Nov 2008, 14:44 Delegate Sarah said...

RE: Splitting database

Great - thank you! it works fine now as another file. thanks!

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips