Convert Access 97 to Access 2007 help

TJL2007 · External Since: Aug 22, 2009 Posts: 4

I have to convert a application created in 97 to 2007 that I built 8 years
ago. Is there a guide on how to do this and what I should look out for? I am
thinking that I will store the data tables on a safe server and all the other
objects on the admin desktop.
How difficult will this conversion be and how much time would one expect to
do this?
Looking for help

Douglas J. Steele · External Since: Jan 12, 2009 Posts: 165

Access 2007 is fine working directly with the Access 2003 MDB format, so the
advice Allen Browne has at http://www.allenbrowne.com/ser-48.html is
relevant. You might also check what he has at
http://www.allenbrowne.com/Access2007.html

Without wanting to seem facetious, if you're lucky, it'll take two or three
minutes to allow Access to run the conversion. If you're not lucky, it could
take longer.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"TJL2007" <TJL2007.DeleteThis@discussions.microsoft.com> wrote in message
news:1B11FFFD-A427-4C8D-9205-FEBCD2B95411@microsoft.com...
>I have to convert a application created in 97 to 2007 that I built 8 years
> ago. Is there a guide on how to do this and what I should look out for? I
> am
> thinking that I will store the data tables on a safe server and all the
> other
> objects on the admin desktop.
> How difficult will this conversion be and how much time would one expect
> to
> do this?
> Looking for help
>

TJL2007 · External Since: Aug 22, 2009 Posts: 4

I will want to store the data tables in a safe folder and the app on the
admin desktop. I am not sure how to do this. Big deal?

"Douglas J. Steele" wrote:

> Access 2007 is fine working directly with the Access 2003 MDB format, so the
> advice Allen Browne has at http://www.allenbrowne.com/ser-48.html is
> relevant. You might also check what he has at
> http://www.allenbrowne.com/Access2007.html
>
> Without wanting to seem facetious, if you're lucky, it'll take two or three
> minutes to allow Access to run the conversion. If you're not lucky, it could
> take longer.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "TJL2007" <TJL2007.TakeThisOut@discussions.microsoft.com> wrote in message
> news:1B11FFFD-A427-4C8D-9205-FEBCD2B95411@microsoft.com...
> >I have to convert a application created in 97 to 2007 that I built 8 years
> > ago. Is there a guide on how to do this and what I should look out for? I
> > am
> > thinking that I will store the data tables on a safe server and all the
> > other
> > objects on the admin desktop.
> > How difficult will this conversion be and how much time would one expect
> > to
> > do this?
> > Looking for help
> >
>
>
>

Douglas J. Steele · External Since: Jan 12, 2009 Posts: 165

Not sure what you mean by "a safe folder". Since the admin desktop is simply
a location somewhere on the hard drive, putting an MDB (or MDE or ACCDB or
ACCDE) file there shouldn't be a big deal.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"TJL2007" <TJL2007.RemoveThis@discussions.microsoft.com> wrote in message
news:1C9C002F-6C23-4084-9FE0-F726D97A6B11@microsoft.com...
>I will want to store the data tables in a safe folder and the app on the
> admin desktop. I am not sure how to do this. Big deal?
>
> "Douglas J. Steele" wrote:
>
>> Access 2007 is fine working directly with the Access 2003 MDB format, so
>> the
>> advice Allen Browne has at http://www.allenbrowne.com/ser-48.html is
>> relevant. You might also check what he has at
>> http://www.allenbrowne.com/Access2007.html
>>
>> Without wanting to seem facetious, if you're lucky, it'll take two or
>> three
>> minutes to allow Access to run the conversion. If you're not lucky, it
>> could
>> take longer.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "TJL2007" <TJL2007.RemoveThis@discussions.microsoft.com> wrote in message
>> news:1B11FFFD-A427-4C8D-9205-FEBCD2B95411@microsoft.com...
>> >I have to convert a application created in 97 to 2007 that I built 8
>> >years
>> > ago. Is there a guide on how to do this and what I should look out for?
>> > I
>> > am
>> > thinking that I will store the data tables on a safe server and all the
>> > other
>> > objects on the admin desktop.
>> > How difficult will this conversion be and how much time would one
>> > expect
>> > to
>> > do this?
>> > Looking for help
>> >
>>
>>
>>

TJL2007 · External Since: Aug 22, 2009 Posts: 4

From what I have read, 2007 security has changed and one method of applying
security would be to separate the queries, reports, forms and macros from the
data tables. MS suggest separating and placing the data tables on a server in
a secure folder. So essentially the question is does one move the data
tables out of the app to a server after converting from Access 97 to access
2007?
Thanks for your input.
TJL2007

"Douglas J. Steele" wrote:

> Not sure what you mean by "a safe folder". Since the admin desktop is simply
> a location somewhere on the hard drive, putting an MDB (or MDE or ACCDB or
> ACCDE) file there shouldn't be a big deal.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "TJL2007" <TJL2007 RemoveThis @discussions.microsoft.com> wrote in message
> news:1C9C002F-6C23-4084-9FE0-F726D97A6B11@microsoft.com...
> >I will want to store the data tables in a safe folder and the app on the
> > admin desktop. I am not sure how to do this. Big deal?
> >
> > "Douglas J. Steele" wrote:
> >
> >> Access 2007 is fine working directly with the Access 2003 MDB format, so
> >> the
> >> advice Allen Browne has at http://www.allenbrowne.com/ser-48.html is
> >> relevant. You might also check what he has at
> >> http://www.allenbrowne.com/Access2007.html
> >>
> >> Without wanting to seem facetious, if you're lucky, it'll take two or
> >> three
> >> minutes to allow Access to run the conversion. If you're not lucky, it
> >> could
> >> take longer.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "TJL2007" <TJL2007 RemoveThis @discussions.microsoft.com> wrote in message
> >> news:1B11FFFD-A427-4C8D-9205-FEBCD2B95411@microsoft.com...
> >> >I have to convert a application created in 97 to 2007 that I built 8
> >> >years
> >> > ago. Is there a guide on how to do this and what I should look out for?
> >> > I
> >> > am
> >> > thinking that I will store the data tables on a safe server and all the
> >> > other
> >> > objects on the admin desktop.
> >> > How difficult will this conversion be and how much time would one
> >> > expect
> >> > to
> >> > do this?
> >> > Looking for help
> >> >
> >>
> >>
> >>
>
>
>