Locked BackEnd?

[Karen]

I have an Access 2003 application that I want to upgrade to Access 2007.

It has a front-end and back-end for the data. It is installed on a desktop
that is still XP. When I copy the application to my Vista machine and try
to convert to .accdb, the front-end says it cannot talk to the back-end with
the error message:

The Microsoft Office Access database engine cannot open or write to the file
'C:\Program Files\InvestigatorNerd\InvestigatorNerd_be.mdb. It is already
opened exlusively by another user, or you need persmission to view and write
its data."

I am flummoxed, it is not locked, it is just that it sits on this Vista
machine.

Any ideas would be very, very welcome

Karen

 

[aaron.kempf]

Do you have write permission to the drive?

I hate Access MDB problems like this; that is why I Just move to SQL
Server 2005; and all these headaches are gone!

-Aaron

 

[Gina Whipp]

Karen,

Have you added the folder(s) where your database and the location of the
back-end to the Trusted Location

*** Snippet from a reply by Allen Browne

To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

 

[Karen]

Hi Gina,

Yep, did that.................., in fact I keep re-checking to see if there
is some field I'm missing but can't find any problems

Karen

Karen,

Have you added the folder(s) where your database and the location of the
back-end to the Trusted Location

*** Snippet from a reply by Allen Browne

To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

 

[Karen]

Hi Aaron,

May have to look at that but...................riles me that it is a problem


Karen

Do you have write permission to the drive?

I hate Access MDB problems like this; that is why I Just move to SQL
Server 2005; and all these headaches are gone!

-Aaron

 

[Gina Whipp]

Karen,

My apologies, I did not READ the message carefully. As far as I know you
cannot connect the front end of an Access 2007 database to a backend Access
2003 database, different formats. MAKE A BACK-UP of the back-end and then
convert the back-end then MAKE A BACK-UP of the front-end and convert the
front-end. (accdb <> .mdb do not play nice together).

NOTE: If you convert to Access 2007 you can no longer open in Access 2003.
If you need to leave the back-end as an .mdb because of other end-users you
can open it in Access 2007 but cannot make design changes without fatal
issues.

 

[Karen]

Gina,

Thanks, that did it

Karen

Karen,

My apologies, I did not READ the message carefully. As far as I know you
cannot connect the front end of an Access 2007 database to a backend Access
2003 database, different formats. MAKE A BACK-UP of the back-end and then
convert the back-end then MAKE A BACK-UP of the front-end and convert the
front-end. (accdb <> .mdb do not play nice together).

NOTE: If you convert to Access 2007 you can no longer open in Access 2003.
If you need to leave the back-end as an .mdb because of other end-users you
can open it in Access 2007 but cannot make design changes without fatal
issues.

 

[Gina Whipp]

Glad I could help!