Access 2007 conversionn from Access 2000

M

Mel Marcovitz

HI:

I have a DVD database (from a template) created with Access 2000. I have
just upgraded to Access 2007.

When I try to open this DB I get the following message:
This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For example,
if the OnOpen property of a form is set to =[Field], this error occurs
because Access expects a macro or event name to run when the event is fired.

When I close the error message window, I have to go to the options window
which tells me that it is a security alert to cancel or allow a macro. I
have to allow the macro or I can' t access the DB at all.

I can open most of the forms and tables, but there is 1 sub-form that when
it opens, it opens blank. The form view, the datasheet view and the
flowchart view are empty. The design view is OK.

I believe the information is still there, Besides I do have back up copies.

What can I do to fix this problem?
 
T

Tom Wickerath MDB

if you want to use Access 2007; then you need to use Access DAta Projects

there is a great DVD example in VB.net 2005 Express
 
6

'69 Camaro

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Tom Wickerath MDB said:
if you want to use Access 2007; then you need to use Access DAta Projects

there is a great DVD example in VB.net 2005 Express



Mel Marcovitz said:
HI:

I have a DVD database (from a template) created with Access 2000. I have
just upgraded to Access 2007.

When I try to open this DB I get the following message:
This error occurs when an event has failed to run because Microsoft
Office Access cannot evaluate the location of the logic for the event.
For example, if the OnOpen property of a form is set to =[Field], this
error occurs because Access expects a macro or event name to run when the
event is fired.

When I close the error message window, I have to go to the options window
which tells me that it is a security alert to cancel or allow a macro. I
have to allow the macro or I can' t access the DB at all.

I can open most of the forms and tables, but there is 1 sub-form that
when it opens, it opens blank. The form view, the datasheet view and the
flowchart view are empty. The design view is OK.

I believe the information is still there, Besides I do have back up
copies.

What can I do to fix this problem?
 
M

Mads Louis

Mel Marcovitz said:
HI:

I have a DVD database (from a template) created with Access 2000. I have
just upgraded to Access 2007.

When I try to open this DB I get the following message:
This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For
example, if the OnOpen property of a form is set to =[Field], this error
occurs because Access expects a macro or event name to run when the event
is fired.

When I close the error message window, I have to go to the options window
which tells me that it is a security alert to cancel or allow a macro. I
have to allow the macro or I can' t access the DB at all.

I can open most of the forms and tables, but there is 1 sub-form that when
it opens, it opens blank. The form view, the datasheet view and the
flowchart view are empty. The design view is OK.

I believe the information is still there, Besides I do have back up
copies.

What can I do to fix this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top