|  | Can't create table | | |
| | | Ben |  |
|  Posted: Thu Aug 28, 2008 7:18 pm Post subject: Can't create table |  |
I don't know what the problem is... in one particular database when I try to
create a table either in Design view or by "entering data", I get these
messages:
"Invalid Argument" followed by "Microsoft Access can't open the table in
Datasheet view."
I am able to create tables in other databases, just not this particular one.
I currently have 36 tables. Is there a limit?
Thanks - Ben |
| |
| | | John W. Vinson | |
| | Posted: Thu Aug 28, 2008 11:08 pm Post subject: Re: Can't create table | |
On Thu, 28 Aug 2008 14:18:13 -0700, Ben <Ben@discussions.microsoft.com> wrote:
| Quote: | I don't know what the problem is... in one particular database when I try to
create a table either in Design view or by "entering data", I get these
messages:
"Invalid Argument" followed by "Microsoft Access can't open the table in
Datasheet view."
I am able to create tables in other databases, just not this particular one.
I currently have 36 tables. Is there a limit?
Thanks - Ben
|
Access version? What service packs do you have applied? Have you Compacted the
database?
--
John W. Vinson [MVP] |
| |
| | | Ben | |
| | Posted: Fri Aug 29, 2008 1:44 pm Post subject: Re: Can't create table | |
2002 (10.6771.6839) SP3
Not compacted
I should also add that I was able to create tables but now I cannot. No
updates on my computer.
Thanks
"John W. Vinson" wrote:
| Quote: | On Thu, 28 Aug 2008 14:18:13 -0700, Ben <Ben@discussions.microsoft.com> wrote:
I don't know what the problem is... in one particular database when I try to
create a table either in Design view or by "entering data", I get these
messages:
"Invalid Argument" followed by "Microsoft Access can't open the table in
Datasheet view."
I am able to create tables in other databases, just not this particular one.
I currently have 36 tables. Is there a limit?
Thanks - Ben
Access version? What service packs do you have applied? Have you Compacted the
database?
--
John W. Vinson [MVP]
|
|
| |
| | | John W. Vinson | |
| | Posted: Fri Aug 29, 2008 3:52 pm Post subject: Re: Can't create table | |
On Fri, 29 Aug 2008 08:44:01 -0700, Ben <Ben@discussions.microsoft.com> wrote:
| Quote: | 2002 (10.6771.6839) SP3
Not compacted
I should also add that I was able to create tables but now I cannot. No
updates on my computer.
|
It's very likely that your database is corrupt - possibly bad system tables.
Try compacting; then take a look at the suggestions at
LINK
--
John W. Vinson [MVP] |
| |
| | | Ben | |
| | Posted: Tue Sep 02, 2008 1:53 pm Post subject: Re: Can't create table | |
I wasn't able to compact the database - kept getting an "invalid argument"
error. I created a new MDB and then imported the data from the old MDB.
That did the trick!
Thanks for your help.
Ben
"John W. Vinson" wrote:
| Quote: | On Fri, 29 Aug 2008 08:44:01 -0700, Ben <Ben@discussions.microsoft.com> wrote:
2002 (10.6771.6839) SP3
Not compacted
I should also add that I was able to create tables but now I cannot. No
updates on my computer.
It's very likely that your database is corrupt - possibly bad system tables.
Try compacting; then take a look at the suggestions at
LINK
--
John W. Vinson [MVP]
|
|
| |
|
|
