read only database when opened with an app

[jpimlott]

We have an application that copies a mde file local and then runs it under msaccess 2003.
It runs fine as a local administrator when using the application.
When a regular user logs onto the system then it opens with a read only message. It does not create the ldb file.
The mde works fine if launched directly as regular user or as an admin.
This same application works fine on other PCs with anyone logged on.
The application is developed locally but we have lost the source code.
John

[June7]

"We have an application that copies a mde file local and then runs it under msaccess 2003."

What application?

[jpimlott]

It is an appilcation that was written in house and we dont have the source code for it or documentation on exactly how it works.

It copies a MDE file down from a network resource then starts access 2003. This works fine on existing PCs with any user level logged in.

On the new pc (windows 7) only local admins can run it.

[June7]

You don't know if the application was VB, VB.net, C, C+, C++, C#, C.net, or something else and can't find source code? What is the file extension of the application? Windows 7 won't run a lot of older programs. I believe often has to do with 32bit vs 64bit compatibility. Abandon it and write a new one.

I use a simple VBScript to copy, open, run Access project. Create script with Notepad, save file, rename so the extension is vbs instead txt. This makes the file an executable.

Const OverwriteExisting = TRUE
Set objFSO = CreateObject("Scripting.FileSystemObject")
'following will copy Access file
objFSO.CopyFile "\\your file path\your file name.accdb", "c:\", OverwriteExisting
'following will now open the Access file
Set oShell = CreateObject("WScript.Shell")
oShell.Run """C:\Program Files\Microsoft Office\Office12\msaccess.exe"" ""c:\your file name.accdb"""