Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

.accde file

Posted on 2013-11-13
11
Medium Priority
?
1,088 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

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
 

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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 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