本文介绍了Autonumbers无法进行预订备份的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

怎么做,


我有三个表格中的个人详细信息,郊游详情和预订的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.


展开 | 选择 | Wrap | 行号

推荐答案

展开 | 选择 | Wrap | 行号




这篇关于Autonumbers无法进行预订备份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-27 12:23
查看更多