tags:

views:

31

answers:

0
+1  Q: 

MS access mdb file has a "repair" status first time it is opened from Access 2007

Hi,

I have created an .mdb file programatically from another .mdb file using VBScript. It creates a table in the second .mdb file and populates data. Everything works fine and data is populated correctly. This is done using JET 4.0 driver.

The issue is that when I try to open the .mdb file using Access 2007, it tries to repair the file first. I do not know why that is happening. If I try to open it in Access 2003, it opens without the repair. I need to fix this. Has anyone run into this before or any ideas as to why it is happening?

related questions

Executing a script file from a Windows Installer Custom Action
Microsoft Event Calendar into webpage via vbscript
CScript/WScript Prevent an error from being blocking
If it is decided that our system needs an overhaul, what is the best way to go about it?
Excel - Macro to conditionally copy rows to another worksheet
How do I format the message used to perform an HTTP post from VBScript / ASP to a WCF service and get a response?
How can I kill a process, using VBScript, started by a particular user.
Can I Mix VBScript and JScript in a Single HTA?
Expose an event handler to VBScript users of my COM object
VBScript conditional short-circuiting workaround
parametrization in VBScript/ASP Classic and ADO
WScript.Shell and blocking execution?
What's a good IDE to edit WScript (.vbs files) that provides intellisense?
Why continue writing legacy systems?
Can Windows' built-in ZIP compression be scripted?
VBScript/ASP Classic
VBScript/IIS - How do I automatically set ASP.NET version for a particular website
ASP/VBScript - Int() vs CInt()
Why doesn't 'shell' work in VBscript in VS6?
Select Query on 2 tables, on different database servers
Programmatically list WMI classes and their properties
How to run remote shell scripts from ASP pages?
What is the IDE for classic ASP and VBScript?
What is the best way to iterate through an array in Classic Asp VBScript?
How do I build a collection in classic ASP?