Re: [MS_AccessPros] Access 2010 Field length

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.

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)




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
> remove fields or change their properties or data types you must do so in
> the source database." My problem is newer books have ISBN numbers that
> are longer than the original database allowed for at 13 and new ones are
> 17 in length.
>
> Apparently it didn't convert the file but created a table for it. Also I
> don't know how to make it sort two or more fields at once. IE I want it
> sorted by author, date, title. I knew how to do that in dbase and Alpha4
> but not Access or how to make it the default view. I thought Freeze was
> my answer but if you sort another column it unfreezes the first.. I
> haven't found any online resources that teach access well or have
> answered my questions..
>
> Scott
>
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>



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

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/