A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Change field length in Access 97 file format(Access 2000)



 
 
Thread Tools Display Modes
  #1  
Old August 10th, 2007, 09:50 AM posted to microsoft.public.access.tablesdbdesign
Prashant
external usenet poster
 
Posts: 29
Default Change field length in Access 97 file format(Access 2000)

I want to change the data type "text" length value 100 by 250 but since I am
having access 2000 with access 97 file format i can not change the length. I
also dont have office 97 setup or CD. So what to do?
  #2  
Old August 10th, 2007, 03:04 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Change field length in Access 97 file format(Access 2000)

Before you do any of this, make a backup copy...

If I'm understanding your situation, you have an .mdb file that is in Access
'97 format that you want to alter, but you only have Access 2000.

If you do not have to keep the original as Access '97, you can use your
Access 2000 to convert the file to Access 2000 format, then make your
change. And if you need the .mdb in Access '97, you can use Tools |
Database ... | Convert ... to save the database "back" into Access '97
format after your change.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"Prashant" wrote in message
...
I want to change the data type "text" length value 100 by 250 but since I

am
having access 2000 with access 97 file format i can not change the length.

I
also dont have office 97 setup or CD. So what to do?


  #3  
Old August 10th, 2007, 03:43 PM posted to microsoft.public.access.tablesdbdesign
Jamie Collins
external usenet poster
 
Posts: 1,705
Default Change field length in Access 97 file format(Access 2000)

On Aug 10, 3:04 pm, "Jeff Boyce" -
DISCARD_HYPHEN_TO_END wrote:
I want to change the data type "text" length value 100 by 250 but since I
am
having access 2000 with access 97 file format i can not change the length.
I
also dont have office 97 setup or CD. So what to do?


Before you do any of this, make a backup copy...

If I'm understanding your situation, you have an .mdb file that is in Access
'97 format that you want to alter, but you only have Access 2000.

If you do not have to keep the original as Access '97, you can use your
Access 2000 to convert the file to Access 2000 format, then make your
change. And if you need the .mdb in Access '97, you can use Tools |
Database ... | Convert ... to save the database "back" into Access '97
format after your change.


The OP could use ALTER TABLE SQL DDL via the Microsoft.Jet.OLEDB.4.0
provider, even on a Jet 3.51 database, something like:

ALTER TABLE MyTable ALTER my_column VARCHAR(40) DEFAULT '{{NONE}}' NOT
NULL

Jamie.

--


  #4  
Old August 17th, 2007, 01:52 AM posted to microsoft.public.access.tablesdbdesign
Prashant
external usenet poster
 
Posts: 29
Default Change field length in Access 97 file format(Access 2000)



"Jeff Boyce" wrote:

Before you do any of this, make a backup copy...

If I'm understanding your situation, you have an .mdb file that is in Access
'97 format that you want to alter, but you only have Access 2000.

If you do not have to keep the original as Access '97, you can use your
Access 2000 to convert the file to Access 2000 format, then make your
change. And if you need the .mdb in Access '97, you can use Tools |
Database ... | Convert ... to save the database "back" into Access '97
format after your change.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"Prashant" wrote in message
...
I want to change the data type "text" length value 100 by 250 but since I

am
having access 2000 with access 97 file format i can not change the length.

I
also dont have office 97 setup or CD. So what to do?




Hello Jeff
I converted it to 2000 file format but it giving me problems of garbage values
And also database size is reducing drastically.
  #5  
Old August 17th, 2007, 02:23 AM posted to microsoft.public.access.tablesdbdesign
Prashant
external usenet poster
 
Posts: 29
Default Change field length in Access 97 file format(Access 2000)



"Jamie Collins" wrote:

On Aug 10, 3:04 pm, "Jeff Boyce" -
DISCARD_HYPHEN_TO_END wrote:
I want to change the data type "text" length value 100 by 250 but since I
am
having access 2000 with access 97 file format i can not change the length.
I
also dont have office 97 setup or CD. So what to do?


Before you do any of this, make a backup copy...

If I'm understanding your situation, you have an .mdb file that is in Access
'97 format that you want to alter, but you only have Access 2000.

If you do not have to keep the original as Access '97, you can use your
Access 2000 to convert the file to Access 2000 format, then make your
change. And if you need the .mdb in Access '97, you can use Tools |
Database ... | Convert ... to save the database "back" into Access '97
format after your change.


The OP could use ALTER TABLE SQL DDL via the Microsoft.Jet.OLEDB.4.0
provider, even on a Jet 3.51 database, something like:

ALTER TABLE MyTable ALTER my_column VARCHAR(40) DEFAULT '{{NONE}}' NOT
NULL

Jamie.

--




Hello Jamie

Thanks for your response
But it isnt working I wrote query like this

ALTER TABLE kp_part ALTER ENGL2 TEXT(250) NOT
NULL

but this one is updating registry value of MaxLocksPreFile value
and no change in table field value
  #6  
Old August 18th, 2007, 01:45 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Change field length in Access 97 file format(Access 2000)

Prashant

That sometimes happens if the original version was not fully compiled. Have
you tried re-compiling your Access 2000 version? Have you opened a code
module in the A2000 version and confirmed that a reference is being set to
Microsoft DAO? Is that DAO reference located above the ADO reference?

We're not there, so we have no idea what "garbage values" means. What are
these, where are they happening?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Prashant" wrote in message
...


"Jeff Boyce" wrote:

Before you do any of this, make a backup copy...

If I'm understanding your situation, you have an .mdb file that is in

Access
'97 format that you want to alter, but you only have Access 2000.

If you do not have to keep the original as Access '97, you can use your
Access 2000 to convert the file to Access 2000 format, then make your
change. And if you need the .mdb in Access '97, you can use Tools |
Database ... | Convert ... to save the database "back" into Access '97
format after your change.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"Prashant" wrote in message
...
I want to change the data type "text" length value 100 by 250 but

since I
am
having access 2000 with access 97 file format i can not change the

length.
I
also dont have office 97 setup or CD. So what to do?




Hello Jeff
I converted it to 2000 file format but it giving me problems of garbage

values
And also database size is reducing drastically.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.