modify table structure

[ty]

How do I change a field in my table from text to memo?
THe table already has records on it.

 

[Allen Browne]

Open the table in design view.
Select the field.
Change the Type to Memo.

There will be no loss of data, since the Memo handles everything the Text
field does and more.

 

[ty]

I tried this, but I get an error message that says "There
isn't enough disk space or memory".

 

[Allen Browne]

Compact the database: Tools | Database Utilities.

If that does not solve the problem, and you do in fact have plenty of spare
disk space (at least treble the size of the mdb file), try this:

1. Create a new (blank) database.

2. Import just the structure of the table:
File | Get External | Import
After opening the File:
- select the table in the dialog;
- click the Options button;
- Choose Structure Only.

3. Open the new table in design view, and change the Text to a Memo field.

4. Attach the table from the old database:
File | Get External | Attach.

5. Create a query into the attached table.
Change it to an Append query (Append on Query menu).
Tell Access the name of the new table to append to.

6. Run the query. This imports everything from the old table into the new
structure.

 

[Eric Butts [MSFT]]

Hi Ty,

Open the table in design view and change it (if not comfortable with the
changes make a copy of the table first).

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "ty" <[email protected]>
| Sender: "ty" <[email protected]>
| Subject: modify table structure
| Date: Mon, 12 Apr 2004 07:07:44 -0700
| Lines: 2
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQgl4bXkw5yZQq8RPWyxs/mFx7MNA==
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:78223
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| How do I change a field in my table from text to memo?
| THe table already has records on it.
|

 

[TC]

If compaction doesn't work, maybe try this before steps 1.-6: close the db,
delete all files from the Windows TEMP directory, then try again.

HTH,
TC