My dependency info in Access seems to have disappeared

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Every time my database tries to update the dependency info it crashes and
'has to close'. I also cannot rename one particular form, which comes up with
the error message 'Visual basic Error' every time I try to rename it
(otherwise it works perfectly). I have tried deselecting and reselecting
'Track Name Auto-Correct' but when it ties to reconfigure it crashes every
time it reaches the reports. Any suggestions what went wrong? (Otherwise the
whole database is running OK)
 
Every time my database tries to update the dependency info it crashes and
'has to close'. I also cannot rename one particular form, which comes up with
the error message 'Visual basic Error' every time I try to rename it
(otherwise it works perfectly). I have tried deselecting and reselecting
'Track Name Auto-Correct' but when it ties to reconfigure it crashes every
time it reaches the reports. Any suggestions what went wrong? (Otherwise the
whole database is running OK)

I'd suggest creating a new, empty database; TURN OFF Track Name
Autocorrect; use File... Get External Data... Import to import
everything from the misbehaving database; compact and repair.

To track down the VB error, type Ctrl-G to open the VBA editor and
select Debug... Compile <database name>. See any errors? Then use the
binoculars to search for the form name, choosing the option to search
the entire project; if you explicitly reference the form name, then
you'll break that code if you rename the form.

John W. Vinson[MVP]
 
Before you lose that file though, I'd like to see it. Do you have a place
you could post it so I can download? I'd like to see if this is a known
bug. Also, please include detailed repro steps for the crash.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top