Access 2007-Table Analyzer/Data Import Error

I've got two questions he

1. I've been trying to do a couple of different things, and getting the same
error message with all of them. I've tried to run the Table Analyzer, tried
to import data, and tried to copy a table, and all of those tasks have failed
- the error message I've gotten is "Reserved error (-1524); there is no
message for this error." I was able to copy tables and import data prior to
the latest TR, so my question is, is this a bug in the new TR? Or is there
something arcane I should be doing to accomplish any/all of these tasks?

2. I'm sure I've read it somewhere, but my reference books are all packed
due to an office move - is there another way to split my table than going
through Table Analyzer?

hi,

1. Analyze tables has a bug on Access 2007 Beta 2 and won't work.

2. In Access 2007 you split a database using the Access Database split
command. This is available in the ribbon "Move Data". Click Database Tools
and select the Access database button to split your database. You don't need
to analyze tables for splitting.

Regards,

-------------------------------------------
http://www.Designing-Systems.com
Email.
-------------------------------------------------

"catspaw00tng" wrote:

I've got two questions he

1. I've been trying to do a couple of different things, and getting the same
error message with all of them. I've tried to run the Table Analyzer, tried
to import data, and tried to copy a table, and all of those tasks have failed
- the error message I've gotten is "Reserved error (-1524); there is no
message for this error." I was able to copy tables and import data prior to
the latest TR, so my question is, is this a bug in the new TR? Or is there
something arcane I should be doing to accomplish any/all of these tasks?

2. I'm sure I've read it somewhere, but my reference books are all packed
due to an office move - is there another way to split my table than going
through Table Analyzer?

Thank you! This helped immensely. I knew the answer was there somewhere.

-C

"Designing-Systems.com" wrote:

hi,

1. Analyze tables has a bug on Access 2007 Beta 2 and won't work.

2. In Access 2007 you split a database using the Access Database split
command. This is available in the ribbon "Move Data". Click Database Tools
and select the Access database button to split your database. You don't need
to analyze tables for splitting.

Regards,

-------------------------------------------
http://www.Designing-Systems.com
Email.
-------------------------------------------------

"catspaw00tng" wrote:

I've got two questions he

1. I've been trying to do a couple of different things, and getting the same
error message with all of them. I've tried to run the Table Analyzer, tried
to import data, and tried to copy a table, and all of those tasks have failed
- the error message I've gotten is "Reserved error (-1524); there is no
message for this error." I was able to copy tables and import data prior to
the latest TR, so my question is, is this a bug in the new TR? Or is there
something arcane I should be doing to accomplish any/all of these tasks?

2. I'm sure I've read it somewhere, but my reference books are all packed
due to an office move - is there another way to split my table than going
through Table Analyzer?