Access 2007 Macro help

Inheirited a MS Access 2007 thingy.

There is a macro that is in the db that isn't functioning.  There are only 2 steps to this macro.  Single stepping through leads to the second step being the issue.
The error is:

cannot open database ''.  It may not be a database that your application recognizes, or the file may be corupt.

This second step is attempting to import a text file into an existing table (fyi... the first step deletes all existing records, successfully, from the same table).

Any idea on what the issue may be or how I can view the "saved" import for errors?

This was working at one time and now it isn't and I have been called in to help.
Sheldon LivingstonConsultantAsked:
Who is Participating?
 
burrcmConnect With a Mentor Commented:
Hard to say without a look. Clean out data, compact, zip and post a copy of the db here along with a sample of the text file to import. Sounds like a missing import specification, but should be easy enough to sort out with a sample.

Chris B
0
 
Sheldon LivingstonConsultantAuthor Commented:
Can I view the code to determine this?
0
 
Jeffrey CoachmanMIS LiasonCommented:
<Can I view the code to determine this?>
There is no "Code to see this"

Simply post a sample of the DB as burrcm requested
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Jeffrey CoachmanMIS LiasonCommented:
Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
0
 
burrcmCommented:
I doubt that you intended to accept my comment as a solution, as nothing has been resolved yet. Please post the requested samples so we may assist. I will request that this be reopened.

Mods - Please "unaccept" and reopen, as this is not resolved.

thanks

Chris B
0
 
Sheldon LivingstonConsultantAuthor Commented:
Actually just needed to "compact and repair"  :-/
0
 
Jeffrey CoachmanMIS LiasonCommented:
Then please accept  burrcm's first post as the solution...

;-)

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.