问题描述
怎么做,
我有三个表格中的个人详细信息,郊游详情和预订的2000访问预订数据库:
tblBookings - [预订ID] -Autonumber, [郊游ID] - 编号, [儿童ID] - 编号, [支付金额] - 货币, [存款支付] - 是/否, [运输] - 是/否
tblPersonaldetails - [儿童ID] -Autonumber等
tblOutingDetails - [Outing ID] -Autonumber等
我正在尝试恢复备份,但是由于自动编号数据类型,[子ID]和[Outing ID]与导入表中的不同,因此无法将预订导入数据库。
我使用此代码首先从备份中导入名称为[Table Name] Append的表,删除当前表中的所有数据,将附加表中的数据插入主表中,然后删除附加表。 br />
How do,
I have a access 2000 booking database with Personal Details, Outing Details and the Bookings in three tables:
tblBookings -- [Booking ID]-Autonumber, [Outing ID]-Number, [Child ID]-Number, [Amount Paid]-Currency, [Deposit Paid]-Yes/No, [Transport]-Yes/No
tblPersonaldetails -- [Child ID]-Autonumber, etc
tblOutingDetails -- [Outing ID]-Autonumber, etc
I am trying to restore backups made, but cannot import the bookings into the database as the [Child ID] and [Outing ID] are different than those in the imported tables due to the autonumber data type.
I use this code to firstly import the tables from the backup with the name "[Table Name]Append", delete all the data in the current tables, insert the data from the append tables into the main tables and then delete the append tables.
推荐答案
这篇关于Autonumbers无法进行预订备份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!