MS Access表进行故障排除

本文介绍了MS Access表进行故障排除的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 您好我使用MS访问来管理少量数据，但我对基本的表结构感到烦恼。 i最近用表替换了表中的所有数据新数据，但现在我正在添加新记录。 的事情是，当你进入和退出时，表通常会默认回到它们的原始设置和布局，但是出于瑕疵，新的记录是出现在桌子的顶部，而不是在底部。 我可以对表格进行排序（TableID =升序）但是只要我刷新表格，新记录就会转到顶部并远离其他更近期的记录。真烦人。 任何人都可以提供帮助。我不想使用查询，我有很多这些。我希望我的基本表格默认回原始订单。 欢呼 alison 解决方案 让我们看看他们在Access论坛中要说些什么，我们应该...... 你好我使用MS访问管理少量数据，但我对我的基本表结构感到恼火。 i最近用新数据替换了表中的所有数据，但现在我正在添加新的记录。 的事情是，当你进入和退出时，表通常默认回到它们的原始设置和布局，但是出于瑕疵，新的记录出现在表格的顶部，而不是在底部。 我可以对表格进行排序（TableID =升序）但是只要我刷新表格，新记录就会转到顶部并远离其他更近期的记录。真烦人。 任何人都可以提供帮助。我不想使用查询，我有很多这些。我希望我的基本表格默认回原始订单。 欢呼 alison 之前没见过，你是怎么加入记录的？这真的不重要，因为表只是一个存放数据的桶。然后，您使用查询或记录集来收集和整理数据和表单或报告，以便将其呈现给您的用户。 对不起，刚刚意识到我在说教...你是如何添加记录的？ ？这可能是关键。 Jim 您好我使用MS访问权限管理一小部分数据，但我对我的基本表结构感到恼火。 i最近用新数据替换了表中的所有数据，但现在我正在添加新记录。 的事情是，当你进入和退出时，表通常默认回到它们的原始设置和布局，但是出于瑕疵，新的记录出现在表格的顶部，而不是底部。 我可以对表格进行排序（TableID =升序）但是只要我刷新表格，新记录就会转到顶部并远离其他更近期的记录。真烦人。 任何人都可以提供帮助。我不想使用查询，我有很多这些。我希望我的基本表格默认回原始订单。 欢呼 alison 你桌子的主键是什么？ 另外看看这个教程，它可能会有所帮助吗？ 数据库规范化和表结构 Hi there i use MS access to manage a small amount of data but i''m getting annoyed by my basic table structure.i recently replaced all the data in the table with new data, but now i am adding new records.thing is, tables normally default back to their original settings and layout when you enter and exit, but for sme reason, new records are appearing at the TOP of the table, instead of at the bottom.i can re sort the table (TableID = ascending) but as soon as i refresh the table, the new records go to the top and away from other more recent records. really annoying.can anyone help. i DO NOT want to use a query, i have plenty of those. i want my basic table to default back to the original order.cheersalison 解决方案 Let''s see what they have to say in the Access Forum, shall we...Hi there i use MS access to manage a small amount of data but i''m getting annoyed by my basic table structure.i recently replaced all the data in the table with new data, but now i am adding new records.thing is, tables normally default back to their original settings and layout when you enter and exit, but for sme reason, new records are appearing at the TOP of the table, instead of at the bottom.i can re sort the table (TableID = ascending) but as soon as i refresh the table, the new records go to the top and away from other more recent records. really annoying.can anyone help. i DO NOT want to use a query, i have plenty of those. i want my basic table to default back to the original order.cheersalisonHaven''t seen that before, how are you adding records? It really shouldn''t matter though because a table is just a bucket to hold data. Then you use queries or recordsets to gather and organise the data and forms or reports to present it to your users.Sorry, just realised I was pontificating... How are you adding records? That may hold the key.JimHi there i use MS access to manage a small amount of data but i''m getting annoyed by my basic table structure.i recently replaced all the data in the table with new data, but now i am adding new records.thing is, tables normally default back to their original settings and layout when you enter and exit, but for sme reason, new records are appearing at the TOP of the table, instead of at the bottom.i can re sort the table (TableID = ascending) but as soon as i refresh the table, the new records go to the top and away from other more recent records. really annoying.can anyone help. i DO NOT want to use a query, i have plenty of those. i want my basic table to default back to the original order.cheersalisonWhat is the primary key of your table?Also have a look at this tutorial, it may help? Database Normalisation and Table Structures 这篇关于MS Access表进行故障排除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！