Re: [MS_AccessPros] Access 2010 Field length

On 1/5/2014 1:38 AM, John Viescas wrote:

Thank you John,

So Access works like a MYSQL file with all the databases in one file
called Database1.accdb? I'm semi familiar with MYSQL, some of my
website, in particular my genealogy database runs on it. It would not
let me access the External Data\import/export menus until I created a
blank database then it allowed me to import the .dbf files from More\
dBase import. Once I did that I changed the field length in question
and it worked and saved it. Before I'd change it but still could not
put more than 13 characters in the field.

I think I have figured out the rest of my question about sorting.


> Scott-
>
> It sounds like you *linked* to the tables in the old file rather than import them as new tables in a .accdb file. If you look at your tables in the Navigation pane, I bet you see a little arrow in the upper left corner of the table icons. That indicates linked, not a real table in your database. You can safely delete all of those - you'll just be destroying the link, not the table itself. Then run through what you did in External Data again, but ask for an import, not a link.
>
>
>
> On Jan 5, 2014, at 5:16 AM, Scott Scheibe <dsscheibe@gmail.com> wrote:
>
>> I am trying converting my old .dbf files from Alpha4 to accdb with
>> access 2010 (new computer, old dell xp died) I'm having some problems,
>> I can open them, it saves an .accdb file but I can't change the field
>> lenght in one I need too and now it is telling me "Table 'SF_Books' is a
>> linked table whose design can't be modified. If you want to add or
>>


--
Scott
dsscheibe@gmail.com
http://scottsworld.info



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

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/