DataBase - Convert Access 2010 to 2003

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 is wrond please?
Phil

ated
Tab
rt

Maybe this link will help, maybe not.
http://office.microsoft.com/en-us/access-help/save-an-access-2010-database-=
in-an-earlier-file-format-HA010341553.aspx.
There is a section on what may prevent it from converting in it.

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

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

cul
sh
FTC
nve
.
nd
ith
n 1
ng
rs
n
t is a

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 is 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.

Hi Patrick

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

cal
bli
1 W
co
....
e a
y w
d i
thi
lde
ou
=92 o
=94 I
me a
has
hing
BE
t
ank

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 are not getting the detail.

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

y cal
Publi
201 W
to co
at....
ble a
sly w
led i
nythi
folde
=93You
=92 o
=94 I
I
s,
n
e
e
r
g me a
b has
othing
he BE
=92t
blank

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.

ncy cal
& Publi
B 201 W
t to co
-dat....
table a
ously w
illed i
anythi
b-folde
=93You
in=92 o
le=94 I
l I
t.
rms,
hen
ble
the
ter
ing me a
Db has
nothing
the BE
n=92t
a blank

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 cannot 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/details.aspx?id=3D1=
0910

m:


Access does not 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 is not a solution by itself.

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

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 would  get the job done if it works.

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

Can't do that, David as I Only have Access 2010 on my machine.
If you look at my next posting, it appears to be a problem under windows 7,
but not Windows XP

Thanks
Phil

But, you obviously have someone with Access 2003 on their machine.  Make the
Access 2003 DB there, carry the file to your machine, export the tables to
the Access 2003 DB, then carry the file back to the user.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

e the
o
iley

It might be too heavy to carry.

The maximum size of an "Access database" is 2GB.  A flash memory device or a
memory card (like the ones used in digicams), to hold more than 2GB can be
carried on your pinky if your sense of balance is good. If you have a
not-so-great sense of balance, maybe you will want to carry the memory
device/card containing the file between your thumb and forefinger.

I would not think the file would be too heavy... but it may be a bit too
large for your e-mail program to allow you to send it as an attachment to an
e-mail.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access