Prev: split data in a field into two fields
Next: Additional Information
From: Karen on 22 Mar 2010 08:41
First, Thank you for the response.

When we try to open the converted db nothing happens, absolutely nothing. No error messages of any kind appear. This was created before my time so I will have to check on what OS was in place at the time. I can tell you that it sits on a shared network so it can be accessed by any computer on the network that has the rights to the db.

I did make the folder a trusted site. I had also previously enabled the macros. We have several back up copies, thankfully. I have even redone the compact and repair, backup and convert. I will have to check the Reference Items, not sure what all references are needed. We don't use VB here, we are an ASP.net/C# shop, the guy that created the Access db was the last VB guy.

Again thanks for your help!!



Paul Shapiro wrote:

Hopefully you have a clean backup of your original Access 97 db.
19-Mar-10

Hopefully you have a clean backup of your original Access 97 db. If not,
make a few copies of what you have now, and if you have any older backups
with the forms, reports, code, etc., make some copies of those too.
IMPORTANT: Do all further work on a copy of your db, and keep the best
original version you have somewhere it cannot be touched. I'd copy it to a
thumb drive or something else that can be removed from the computer.

What happens when you try to open the db in Access 2007? Is there an error
message, does it lock up, etc? When you went from Access 97 to 2007 did you
also change computers? If so, what OS was the original computer and what OS
is the new one?

Try holding down the Shift key while you open the db, which disables any
startup forms. If the db opens, you can open the VBA editor and see if there
are any missing references. Within the VBA editor, dropdown the Tools menu
and choose the References item.

You can also check the Access options to see if you have specified the
folder containing your db as a trusted location. You can do this by opening
Access, without opening your db. Within the Access Options dialog, choose
Trust Center in the left pane. Then click the Trust Center Settings button.
In the Trust Center dialog, choose Trusted Locations in the left pane. Make
sure the folder containing your db is listed in the trusted locations in the
right pane.

You may want to consider having a consultant look at your db if this does not
help and no one there knows anything about Access.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorials/aspnet/223c6e57-f81f-44b3-ab05-5995f2b0ab63/sharepoint-video-library.aspx
 | 
Pages: 1
Prev: split data in a field into two fields
Next: Additional Information