Re: [MS_AccessPros] Access 2010 Field length

Scott-

Yes, similar to the MySQL commercial edition. MySQL community edition installs with innoDB as the default, and that creates one folder per database.

Sounds like you're off and running now...

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 6, 2014, at 2:26 AM, Scott Scheibe <dsscheibe@gmail.com> wrote:

> 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
>
>
>
>



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

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/