AndyCabbages
Registered User.
- Local time
- Today, 02:09
- Joined
- Feb 15, 2010
- Messages
- 74
I am using Microsoft Access 2000 and when I try and import a table from an older version of the database I get the fllowing error:
'the decimal field's precision is too small to accept the numeric you attempted to add'
I have been working on a database for a friend over the last few weeks and have made changes to forms and quieries, but the tables and the data in them has remainded the same. During the time I have been working on the database my friend has been using it as normal and inserting data in to his original version while I work on the updated version.
Because of the amount of data he has added during the time I've been working on the database it is not practical to go through and type it all in again so we tried the following:
1. Delete all the tables in the updated version
2. Import all the tables from his original version he has been using
3. Result should be an updated database with no data loss?
All of the tables import fine except for one, which causes the above error and I have no idea why.
Also, is this the best method for handing over the updated database? Or is there an easier way it can be done with no loss of data he has input over the last few weeks?
'the decimal field's precision is too small to accept the numeric you attempted to add'
I have been working on a database for a friend over the last few weeks and have made changes to forms and quieries, but the tables and the data in them has remainded the same. During the time I have been working on the database my friend has been using it as normal and inserting data in to his original version while I work on the updated version.
Because of the amount of data he has added during the time I've been working on the database it is not practical to go through and type it all in again so we tried the following:
1. Delete all the tables in the updated version
2. Import all the tables from his original version he has been using
3. Result should be an updated database with no data loss?
All of the tables import fine except for one, which causes the above error and I have no idea why.
Also, is this the best method for handing over the updated database? Or is there an easier way it can be done with no loss of data he has input over the last few weeks?