K
Karl Burrows
I was approached by a company about assisting with the conversion of an
existing Access 97 database to a SQL back end. I am basically charged with
finding a solution and coordinating the process. The first thing I did was
look at the Access data structure. It was an old database converted from
dBase, but the biggest thing I found was the database is over 30GB! This
only includes the 2 most recent years of data and they archive the rest.
The other issue I found is there is one table with over 750,000 records
(very poor job of table structures). After looking up file limitations in
Access, I am really surprised this database even runs.
First, is this database just an accident waiting to happen? Second, I think
I know how to move the data to a SQL side, but how do you interface it with
Access for the front-end? Just link tables like a regular split database or
is there something else that needs to be done. I am trying to determine the
best direction to go with this for a long term solution. Will 97 run a
database upsize to SQL?
What other things should I be concerned with? Thanks!
existing Access 97 database to a SQL back end. I am basically charged with
finding a solution and coordinating the process. The first thing I did was
look at the Access data structure. It was an old database converted from
dBase, but the biggest thing I found was the database is over 30GB! This
only includes the 2 most recent years of data and they archive the rest.
The other issue I found is there is one table with over 750,000 records
(very poor job of table structures). After looking up file limitations in
Access, I am really surprised this database even runs.
First, is this database just an accident waiting to happen? Second, I think
I know how to move the data to a SQL side, but how do you interface it with
Access for the front-end? Just link tables like a regular split database or
is there something else that needs to be done. I am trying to determine the
best direction to go with this for a long term solution. Will 97 run a
database upsize to SQL?
What other things should I be concerned with? Thanks!