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

Sorry as a DBA it goes against nature not to have a Primary KEY!!! :) Things are not right in the universe.

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 7:39 AM
Subject: RE: [MS_AccessPros] Cannot change field size in web database

Art-

You can't define a PKey on a web table. But note that you automatically get an AutoNumber field named ID whenever you create a new table. That can act as the PKey for the table.

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 Lorenzini
Sent: Tuesday, January 29, 2013 3:20 PM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: 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
mailto:alorenzini%40crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."

________________________________
From: John Viescas mailto:JohnV%40msn.com>
To: mailto:MS_Access_Professionals%40yahoogroups.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]

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

Yahoo! Groups Links

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