I create a new database and then link to table call mx.dbf
Because all numerical fields in mx are in double format and I want zip code to be integer, I open the design view to change. But Access gives me an error saying "linked table cannot be modified"
Could anybody help me with this? Or show me an alternative solution.
Not sure what a dbf file is but thats probably my ignorance. The thing that I have seen with linked tables is that if u want to make a change to the table structure you have to do it in the origianl source.