Cant save access 2007 file in 2002/2003 format, why?

[Nordivan]

I have a database made in Access 2007 but it should run in access 2002/2003
but when i try to save in the 2002/2003 format it says.
"You tried to access a database that is already
opened by the user 'admin' on 'PSW'. Try again when databaen is
available."
This has always worked whitout problem before. Is there anyway to fix this.
I have googled and found some things on other forums but i havent found a
solution that should work for me.

 

[Scott McDaniel]

I have a database made in Access 2007 but it should run in access 2002/2003
but when i try to save in the 2002/2003 format it says.
"You tried to access a database that is already
opened by the user 'admin' on 'PSW'. Try again when databaen is
available."

Make sure that (a) you're not opening this exclusively and (b) you have saved all changes before you try to convert
this. You can make sure you're opening this exclusively by using File - Open, then find the database, then click the
small arrow next to the Open button (in the File Open dialog box), and make sure to NOT open this exclusively. Also
you'll need to insure that you don't have the db set to open Exclusive - click the Office Button - Access Options -
Current Database, and review your settings there.

This has always worked whitout problem before. Is there anyway to fix this.
I have googled and found some things on other forums but i havent found a
solution that should work for me.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Nordivan]

The Access settings is set to Shared and not Excluive. How do i set this on
the database?
I dont have file - open in Access 2007. I just have a office button were you
find new, open and so on.

 

[Nordivan]

Hi, it dosent work anyway.
Regards
Pontus

In earlier versions of Access when you try to convert a db that's already
opened by other users, you get an error message:

"When you convert a database, or the first time you open an earlier version
database, another user can't have the database open."

I don't think Access 2007 is different than earlier versions, where you need
exclusive access to the db to convert it. Kick the user on the PSW pc out of
the db, open the db exclusively with a shortcut, then convert the db.

"path to msaccess.exe" "path to db.mdb" /excl

Chris

 

[Gina Whipp]

Nordivan,

Have you installed SP1 for Office 2007? I see it fixed a host of issues
with Access 2007.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Nordivan]

Hi, i already have SP1 dor Office 2007 nstalled.
Regards
Pontus

 

[Gina Whipp]

Nordivan,

Are you the only one in the database?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Nordivan]

Yes im the only one right now cause im just running it locally at my computer
while updating the database.

 

[Nordivan]

It works fine to open the file exclusivly but when i shall save it in an
earlier version it says "You cant use the c:\Artsys\Artsys.accdb the file is
already in use"

 

[Nordivan]

I have tried download a access fille that should loggoff all from the
database but that didnt work how do i do that?

 

[Gina Whipp]

Nordivan,

Okay, now I am really not getting it because it should work. Are you trying
to save using the same name as the one you have open? Are you saving to a
Trusted Location?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Nordivan]

Thanks everyone for your help because now it works.
Regards
Pontus