By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,315 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Getting data out of Access 95(!)

P: n/a
Hello all

We have an Access 95 database which holds a lot of our customer data.
We are running the database in Access 2007 and in the main it's fine.
However the time has come to move on and we're trying to extract the
data from the .mdb file. When we open the database in Access 2007 all
we can see is the runtime version - is there anyway of going back to
the design view? If not any suggestions how we can access our data into
eg Excel so we can start again

Any help greatly appreciated
Regards
John

Jan 4 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Click the Office Button in Access 2007, and one of the choices is to convert
the file.

Once you have converted it to a later version, you will be able to make
design changes (but of course you won't be able to still use it in Access
95.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pl********@yahoo.comwrote in message
news:11**********************@11g2000cwr.googlegro ups.com...
>
We have an Access 95 database which holds a lot of our customer data.
We are running the database in Access 2007 and in the main it's fine.
However the time has come to move on and we're trying to extract the
data from the .mdb file. When we open the database in Access 2007 all
we can see is the runtime version - is there anyway of going back to
the design view? If not any suggestions how we can access our data into
eg Excel so we can start again

Any help greatly appreciated
Regards
John
Jan 5 '07 #2

P: n/a
Thanks for the prompt reply Allen. When I click on the Office Button in
Access 2007 the only option I get is to close the database - none of
the "normal" options appear eg Save As

Any other suggestions?

Regards
Helen
Allen Browne wrote:
Click the Office Button in Access 2007, and one of the choices is to convert
the file.

Once you have converted it to a later version, you will be able to make
design changes (but of course you won't be able to still use it in Access
95.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pl********@yahoo.comwrote in message
news:11**********************@11g2000cwr.googlegro ups.com...

We have an Access 95 database which holds a lot of our customer data.
We are running the database in Access 2007 and in the main it's fine.
However the time has come to move on and we're trying to extract the
data from the .mdb file. When we open the database in Access 2007 all
we can see is the runtime version - is there anyway of going back to
the design view? If not any suggestions how we can access our data into
eg Excel so we can start again

Any help greatly appreciated
Regards
John
Jan 5 '07 #3

P: n/a
Thanks for the prompt reply Allen. When I click on the Office Button in
Access 2007 the only option I get is to close the database - none of
the "normal" options appear eg Save As

Any other suggestions?

Regards
John

Allen Browne wrote:
Click the Office Button in Access 2007, and one of the choices is to convert
the file.

Once you have converted it to a later version, you will be able to make
design changes (but of course you won't be able to still use it in Access
95.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pl********@yahoo.comwrote in message
news:11**********************@11g2000cwr.googlegro ups.com...

We have an Access 95 database which holds a lot of our customer data.
We are running the database in Access 2007 and in the main it's fine.
However the time has come to move on and we're trying to extract the
data from the .mdb file. When we open the database in Access 2007 all
we can see is the runtime version - is there anyway of going back to
the design view? If not any suggestions how we can access our data into
eg Excel so we can start again

Any help greatly appreciated
Regards
John
Jan 5 '07 #4

P: n/a
Another alternative is to create a new (blank) database in Access 2007.

Then click the External Data tab of the ribbon, and the Access button in the
Import group.

I imported an Access 95 database into A2007 last night doing exactly that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pl********@yahoo.comwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com...
Thanks for the prompt reply Allen. When I click on the Office Button in
Access 2007 the only option I get is to close the database - none of
the "normal" options appear eg Save As

Any other suggestions?

Regards
John

Allen Browne wrote:
>Click the Office Button in Access 2007, and one of the choices is to
convert
the file.

Once you have converted it to a later version, you will be able to make
design changes (but of course you won't be able to still use it in Access
95.)

<pl********@yahoo.comwrote in message
news:11**********************@11g2000cwr.googlegr oups.com...
>
We have an Access 95 database which holds a lot of our customer data.
We are running the database in Access 2007 and in the main it's fine.
However the time has come to move on and we're trying to extract the
data from the .mdb file. When we open the database in Access 2007 all
we can see is the runtime version - is there anyway of going back to
the design view? If not any suggestions how we can access our data into
eg Excel so we can start again

Any help greatly appreciated
Regards
John
Jan 5 '07 #5

P: n/a
pl********@yahoo.com wrote:
Thanks for the prompt reply Allen. When I click on the Office Button
in Access 2007 the only option I get is to close the database - none
of the "normal" options appear eg Save As

Any other suggestions?
If all you need is the data just link to the tables or import them.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jan 5 '07 #6

P: n/a
Worked like a dream - thanks Allen
Allen Browne wrote:
Another alternative is to create a new (blank) database in Access 2007.

Then click the External Data tab of the ribbon, and the Access button in the
Import group.

I imported an Access 95 database into A2007 last night doing exactly that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pl********@yahoo.comwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com...
Thanks for the prompt reply Allen. When I click on the Office Button in
Access 2007 the only option I get is to close the database - none of
the "normal" options appear eg Save As

Any other suggestions?

Regards
John

Allen Browne wrote:
Click the Office Button in Access 2007, and one of the choices is to
convert
the file.

Once you have converted it to a later version, you will be able to make
design changes (but of course you won't be able to still use it in Access
95.)

<pl********@yahoo.comwrote in message
news:11**********************@11g2000cwr.googlegro ups.com...

We have an Access 95 database which holds a lot of our customer data.
We are running the database in Access 2007 and in the main it's fine.
However the time has come to move on and we're trying to extract the
data from the .mdb file. When we open the database in Access 2007 all
we can see is the runtime version - is there anyway of going back to
the design view? If not any suggestions how we can access our data into
eg Excel so we can start again

Any help greatly appreciated
Regards
John
Jan 5 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.