Solved

.accde file

Posted on 2013-11-13
11
1,000 Views
Last Modified: 2013-12-03
I just upgraded my 2003 database to Access 2010. I was using a .mde file on a Novell-Delivered Application window for users to access the database. I updated to .accde and pushed that out.

Now I am having extreme issues. People can get in, but then it freezes. They try to go back in and get 'The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from the modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project....." Or that the file is unstable.

I can copy over the original .accde file to the share point and it's works for awhile but once again after you get a few users in it, it locks up and does this again.

I can put the .accde on the user's desktops and it works fine but our IT department is not really liking that as an option, they want it to work from the Novell-delivered Application window.

Any ideas as to why this is failing where the .mde file was fine?

Help would be appreciated.

Thanks
Deanna
0
Comment
Question by:dminx13
  • 6
  • 5
11 Comments
 
LVL 21
ID: 39646193
Any ideas as to why this is failing where the .mde file was fine?

Access 2003 is more forgiving for haring an mde but there were still issues.

Access 2007 and later do not like to share a front end .accde which o helps eliminate issues. Each user will need  their own copy of the front end .accde. No way around it  with Access 2007 or later.

In your case, to keep the IT people happy, I place an app launcher .accde on the server. The launcher will copy the front end to the local workstation and then launch it.

Are you creating a trusted location for the .accde on each workstation?

Boyd Trimmell, Microsoft Access MVP
0
 

Author Comment

by:dminx13
ID: 39646220
No, it is just an an application delivered windown. one .accde file for about 40 users........

So that won't work? They have to have it on their workstation?
0
 
LVL 21
ID: 39646376
They have to have it on their workstation?
That would be the Best Practices solution.

The key part to properly sharing an Access application is that each user must have there own copy of the front end.

For best performance you want the front end on the local hard drive with linked tables to the shared back end (tables).  It is possible to have each user's copy of the front end on a network share as long as each user has their own copy.

My gut instinct tells me that the Nov ell-delivered Application window is not compatible with Access 2010. That could explain the constant database corruption

Boyd Trimmell, Microsoft Access MVP
aka HiTechCoach
0
 

Author Comment

by:dminx13
ID: 39646493
OK. So our IT guy backed into the 2003 version and found that the .mde file was getting copied locally. He create a command to copy the new one but now we are geting something really wierd.
This is the command:
copy \\fr01apthr001\HRData\HRIS\Client\HRClient.accde "C:\Program Files\HR Client\" /Y

This is what happens when the .accde opens:
Microsoft Access has detected that this database is in an inconsistent state, and will attempt to revcover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open the new database. The names of objects that were not successfully recovered will be logged in the "Recovery Errors"table.

It then opens and create a backup on the C drive where it was supposed to be overwriting the existing one.

What the heck and how to fix??? When you open the .accde that was copied to the C drive it works fine......
0
 
LVL 21
ID: 39646561
That is strange.

It may be a permissions issue on the local folder and/or file. The user must have read AND write permissions for the folder. with the .accde.

Have you checked the folder permissions?
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

Author Comment

by:dminx13
ID: 39648386
I doubt it because it creates the backup on the local drive. AND it is overwriting the existing.

So you click the icon the access database comes up throwing that error and then clicking OK creates a backup.accde file. Or backup(2).accde.... So it has read/write access. I've checked the timestamp and it is updating it.
0
 

Author Comment

by:dminx13
ID: 39648390
We took the copy out and the icon on the NAL is working pointed at the C drive. So it has to have something to do with the copy and then open?
0
 
LVL 21
ID: 39648636
How are you opening the database after the copy?
0
 

Author Comment

by:dminx13
ID: 39662854
We have an icon on the Novell Delivered Application window. You click it, it copied the .accde file to the local workstation, then opens it in Access.

Still no love. At this point IT just has it open the .accde file in Access 2010. The copy part has been taken out.
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 39664699
Is is possible to post the actual commands from the script (the contents of the bat, cmd, vbs, etc.)  used to do the copy and open the database?

I would also recommend not using this:

copy \\fr01apthr001\HRData\HRIS\Client\HRClient.accde "C:\Program Files\HR Client\" /Y

C:\Program Files can cause issues.

I would copy the file to the user's windows profile . I like to use %appdata%

Something like:

copy \\fr01apthr001\HRData\HRIS\Client\HRClient.accde "%appdata%\HR Client\" /Y

The folder %appdata%\HR Client\ will probably have to be created some way before this can execute.

Can you use a VBS script?

What about a .bat file like this?

Rem Check for local file - create directory and copy file if not present.
if not exist C:\MyDB\MyDatabase.mdb mkdir C:\MyDB

if exist "C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" if not exist C:\MyDB\MyDatabase.mdb copy "\\Server\Shared\MyDatabase.mdb" "C:\MyDB\MyDatabase.mdb" /y

if exist "C:\Program Files\Microsoft Office 2000\MSACCESS.EXE" if not exist C:\MyDB\MyDatabase2000.mdb copy "\\Server\Shared\MyDatabase.mdb" "C:\MyDB\MyDatabase2000.mdb" /y


Rem updates local copy with server file if needed

if exist "C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" xcopy "\\Server\Shared\MyDatabase.mdb" "C:\MyDB\MyDatabase.mdb" /d /y

if exist "C:\Program Files\Microsoft Office 2000\MSACCESS.EXE" xcopy "\\Server\Shared\ MyDatabase2000.mdb" "C:\MyDB\ MyDatabase2000.mdb" /d /y


Rem Launch application
if exist "C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" start /max "MSAccess" "C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" "C:\MyDB\MyDatabase.mdb" /wrkgrp  "\\Server\Shared\ MyDatabase.mdw"

if exist "C:\Program Files\MS Office 2000\MSACCESS.EXE" start /max "MSAccess" "C:\Program Files\MS Office 2000\\MSACCESS.EXE" "C:\MyDB\MyDatabase2000.mdb" /wrkgrp  "\\Server\Shared\ MyDatabase.mdw"

Pause

Open in new window

0
 

Author Comment

by:dminx13
ID: 39669146
Thank you, I'll see what our IT department says.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now