file too big

3 Mar 2007 6:27 PM

Stacy B

I have a file that is over 280,000 records. I got it into a table, but I
cannot edit the table. Any suggestions without losing Data?

3 Mar 2007 6:32 PM

Rick Rothstein (MVP - VB)

>I have a file that is over 280,000 records. I got it
> into a table, but I cannot edit the table. Any
> suggestions without losing Data?

Is this a VB6 (compiled version) question? Or a VBA (Office product)
question?

Rick

3 Mar 2007 7:19 PM

Stacy B

I am asking about an ACCESS 2000 database, that when I put it into a table is
fine until I go to change data types on the table, then it says there is not
enough memory or disk space.

Show quoteHide quote

"Rick Rothstein (MVP - VB)" wrote:

> >I have a file that is over 280,000 records. I got it
> > into a table, but I cannot edit the table. Any
> > suggestions without losing Data?
>
> Is this a VB6 (compiled version) question? Or a VBA (Office product)
> question?
>
> Rick
>
>
>

3 Mar 2007 7:52 PM

Rick Rothstein (MVP - VB)

>> >I have a file that is over 280,000 records. I got it
>> > into a table, but I cannot edit the table. Any
>> > suggestions without losing Data?
>>
>> Is this a VB6 (compiled version) question? Or a VBA
>> (Office product) question?
>
> I am asking about an ACCESS 2000 database, that
> when I put it into a table is fine until I go to change data
> types on the table, then it says there is not enough
> memory or disk space.

This newsgroup is devoted to the compiled version of VB... your question
appears to deal with the embedded VBA macro language incorporated in Access.
While sharing lots of common, base functionality, there are large
differences between these two languages. You would be better off asking your
question in a newsgroup devoted to Access or VBA programming (maybe
microsoft.public.access or microsoft.public.access.macro, although there are
other possibilities as well).

Rick

3 Mar 2007 8:11 PM

Henning

Show quote Hide quote

"Stacy B" <Sta***@discussions.microsoft.com> skrev i meddelandet
news:1C65915C-D034-48FB-8A23-CC30CA50305B@microsoft.com...
> I am asking about an ACCESS 2000 database, that when I put it into a table
is
> fine until I go to change data types on the table, then it says there is
not
> enough memory or disk space.
>
> "Rick Rothstein (MVP - VB)" wrote:
>
> > >I have a file that is over 280,000 records. I got it
> > > into a table, but I cannot edit the table. Any
> > > suggestions without losing Data?
> >
> > Is this a VB6 (compiled version) question? Or a VBA (Office product)
> > question?
> >
> > Rick
> >
> >
> >

FWIW there is a 2G filesize limit in access.

/Henning