Getting data out of Access 95(!)

[plasyncoed]

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

[Allen Browne]

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

[plasyncoed]

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

[plasyncoed]

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

[Allen Browne]

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

[Rick Brandt]

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

[plasyncoed]

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