ACCESS FEED: Re: [MS_AccessPros] Cannot change field size in web database

Selasa, 29 Januari 2013

Re: [MS_AccessPros] Cannot change field size in web database

So are Primary Keys not necessary with web tables?

With Warm Regards,

Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
alorenzini@crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."

________________________________
From: John Viescas JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, January 29, 2013 1:04 AM
Subject: RE: [MS_AccessPros] Cannot change field size in web database

Art-

I'm not seeing a problem doing that for Text fields. If I make the size
shorter, I get a warning about possible truncation. If I make the size
larger - to anything <= 255, it accepts it.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: mailto:MS_Access_Professionals%40yahoogroups.com
[mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of Art
Sent: Monday, January 28, 2013 10:59 PM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: [MS_AccessPros] Cannot change field size in web database

I am created a web database (2010) and when I go to change the size of a
text field it says "The setting of the FieldSize property must be 0 to 255"
No matter what size I put in there. It is currently 50 but I need to expand
it to 150.

Any ideas?

Thanks,

Art Lorenzini
Sioux Falls, SD

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]