Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / August 2004

Tip: Looking for answers? Try searching our database.

Error Changing field text size limit

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Julie Nicole - 24 Aug 2004 06:00 GMT
Hi,

I entered a name into the form and ran out of spaces.
I went back to the table to increase the field text limit from 50 to 70
It tells me I have to first delete the relationships.
I did this so nothing shows up and it still says I hav to delete the
relationsips.  I have tried saving the relationship window being empty and
still get the error.  I think this is stupid.  I created the table and have
done extensive data entry and have to delete the relationships just to
change the field size?????  What will happen to the relationships that have
been created for other forms etc?  and how do I change the field size?

thanks
Julie
Alexandr Artamonov - 24 Aug 2004 10:50 GMT
Julie
I came across the same problem recently. As it turned out the relationships
window wasn't showing all tables related to the one that I wanted to change.
When I pressed "show all relationships" button I saw it. Then I really
deleted all relationships with that table and changed the field size. Maybe
it's your case.

Regards
Alexandr Artamonov

> Hi,
>
[quoted text clipped - 10 lines]
> thanks
> Julie
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.