Alter tables in ms-access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using existing ms-access database wherein there are about 40 tables.In
one of table i have set the field size of data field to 15.This table is
related to many tables.Now the problem is i want to change the field size to
25 keeping all relationships intact.can anyone suggest me method to go about
it?
 
I am using existing ms-access database wherein there are about 40
tables.In one of table i have set the field size of data field to
15.This table is related to many tables.Now the problem is i want to
change the field size to 25 keeping all relationships intact.can
anyone suggest me method to go about it?
Click to expand...

Back up the database;

Back it up again;

Delete all the affected relationships;

Change all the field sizes;

Recreate all the the relationships (PK and all the FKs that
reference it, and any other FKs that reference them if they
are part of a FK too);

Back it up again;

Test according to the test programme;

If it's passed the tests, then deliver to the users.

There is generally no short cut for such a major design re-do. It's a bit
like changing the number of engines on an aeroplane...

All the best


Tim F
 
Back
Top