• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1015
  • Last Modified:

access error 3799 when backup or compact and repair

I now get an error "could not find field "Description" when I try to backup or do a Compact & Repair on my Access database.  This database is linked to a "backend" Access file and has a lot of code.  Help on the error says "(error 3799) A column that does not exist is being referenced"  Funny thing is that when I open previous backups and try to back those up or compact and repair, I also get the same error.
0
acdecal
Asked:
acdecal
  • 5
  • 5
1 Solution
 
tbsgadiCommented:
Hi acdecal,

Can you try adding a field "Description" to the relevant Table?


Gary
0
 
acdecalAuthor Commented:
I do not know which table it is referring to and I have over 30 tables and hundreds of commands.
0
 
tbsgadiCommented:
Can you open the code & run Debug>Compile?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
acdecalAuthor Commented:
Yes that compiles with no errors
0
 
tbsgadiCommented:
In your Front End?
0
 
acdecalAuthor Commented:
yes
0
 
tbsgadiCommented:
Try doing Decompile & compact
http://www.granite.ab.ca/access/decompile.htm
0
 
acdecalAuthor Commented:
It appears the problem is: I was out of disk space.   Once I cleared up some room the backup worked as well as a compact and repair.  I did try your decompile sugestion and that is when I realized the problem.  Also the decompile shrunk my file slightly.  I will award you the points for the effort and the good suggestion.
0
 
acdecalAuthor Commented:
see my comment
0
 
tbsgadiCommented:
Glad to help!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now