I am trying to convert an Access 2010 BE Db (Tables only, no fancy calculated
fields or data macros) into Access 2003 format. I use the Save & Publish
option aqnd get an error "Could not use 'C:\Phil Data\Access\MDB 201 WFTCTab
2010.AccDb'; file already in use" error. That is the file I want to convert
and save as WFTCTab2003.Mdb. Any idea what's wrond please?
Phil

On Aug 13, 6:11*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Maybe this link will help, maybe not.
http://office.microsoft.com/en-us/ac...010341553.aspx.
There's a section on what may prevent it from converting in it.

Can you export a single table and import it into 2003?

On 14/08/2011 03:19:00, Patrick Finucane wrote:
Hi Patrick
Tried that - created a new DB, Database9.AccDb, imported a single table and
then tried the Save & Publish Exactly the same error message, obviously with
Database9 instead of WFYCTab.

Then tried creating a new DB, a default table is presented, so I filled in 1
field, saved the table and got exactly the same results. Can it be anything
to do with trusted folders? After re-setting my Access folder & Sub-folders
to trusted, re-booting the computer I now get a different message “You
attempted to open a database that is already opened by user ‘Admin’ on
machine ‘PHIL-DESKTOP’. Try again when the database is available” It is a
similar sort of error message. Any further thoughts?
Thanks
Phil

On Aug 14, 4:13*am, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Hi Phil:

With no personal experience with what you are experiencing about all I
can do is ask some questions. Maybe something will come out of it.

Is this a one time deal or something you want to automate?

Is it only tables you are converting? As there queries, code, forms,
in the db as well? Regardless if they are being used.

Are you running multiple databases in multiple versions of Access when
you get the error? IOW, is this the only app running?

Are you running from code of from the debug window?

If it's a one time deal I'd write the vba code to export it out, table
by table, to excel or something and then open A2003 import it into the
db just to get the job done. Play with the "save and publish" after
hours as a problem solving exercise.

On 14/08/2011 20:12:20, Patrick Finucane wrote:

This is a 1 off as a colleague has Access 2003 and I hope will be giving me a
hand sort out some problems. The normal BE Db has tables only, The FE Db has
everything forms, quereies, reports macros VBA, but as far as I know, nothing
incompatible with Access 2003. Anyway my original posting referred to the BE
only. As I said, I even created a brand new Db with 1 table and couldn’t
export that. I have only Access 2010, so your suggestion of creating a blank
A2003 Db and importing tables via Excel is not on.

Thanks again

Phil

On Aug 14, 4:16*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
I created Table1 in Junk.accdb. I created the fields AnAutoNumber
(primary key), AText, ADate, ACurrency, AnInteger, and ABoolean and
simply took the defaults and entered 1 record. Then I "saved &
published" the accdb to Junk1.mdb (2003) and up popped Junk1.mdb.
It'd be nice if you got a more detailed error message that'd tell you
what tables or fields are inhibiting your conversion.

Maybe write some code to see if there are any field types in your
tables that are not in the list I used. All you need is one field to
stop the conversion and right now you aren't getting the detail.

One other thing. Look thru the "Options" and see if there is any
setting that could possibly create a problem.

On Aug 15, 1:12*am, Patrick Finucane <patrickfinucan... (AT) gmail (DOT) com>
wrote:
Hi,
I recently had a problem with trying to open an Access 2010 database
in Access 2007, where it would only open as read-only. I got round it
by saving the file as an mdb rather than an accdb. I think you can
just change the filename in Windows Explorer as well.
Hope this helps.

On Aug 15, 6:10*am, franc sutherland <franc.sutherl... (AT) googlemail (DOT) com>
wrote:
As I understand this thread, you have an Access 2010 application but
one user who only has Access 2003 available, so you are trying to
convert your database to a Access 2003 version for that one user and
are running into problems. Why can't you just let that one user run
your application using the free Access 2010 Runtime program? You can
download it here: http://www.microsoft.com/download/en....aspx?id=10910

franc sutherland <franc.sutherland (AT) googlemail (DOT) com> wrote in
news:c1fe89c6-a2e3-47f2-9501-6dff57cbf170 (AT) gz5g2000vbb (DOT) googlegroups.co
m:

Access doesn't really care about the file extension (you can use
anything, not just the standard MDB/MDE/ACCDB/ACCDE extensions), but
changing the file extension does nothing to change the format of the
file, so that's not a solution by itself.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in
news:j270ad$jba$1 (AT) speranza (DOT) aioe.org:

Have you tried creating an A2003 MDB, then exporting the tables form
A2010 to the A2003 MDB? You'd have to do it one by one, but at last
you'd get the job done if it works.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/