What happens during a conversion?

C

Craig

Greetings. I have a SQL Server 2000 database that uses Access 97 for
the Front and Back Office GUI. I need to use Access XP for the Front
and Back Office GUI, but I'm afraid that something "bad" is going to
happen during this conversion that will cause this VERY important
database to become destroyed. Will a conversion damage the SQL data?
Will a conversion only change "things" associated with Access? What
exactly goes on during a conversion? What kind of prep work do I need
to accomplish before attempting the conversion? If I'm posting in the
inappropriate place, please let me know where I should post. Thank
you in advance for your help, and have a wonderful day!
 
T

Tony Toews

Greetings. I have a SQL Server 2000 database that uses Access 97 for
the Front and Back Office GUI. I need to use Access XP for the Front
and Back Office GUI, but I'm afraid that something "bad" is going to
happen during this conversion that will cause this VERY important
database to become destroyed. Will a conversion damage the SQL data?

No, because the data is over in SQL Server.
Will a conversion only change "things" associated with Access?
Correct.

What exactly goes on during a conversion?

Not sure how to answer this question.
What kind of prep work do I need
to accomplish before attempting the conversion?

To see what I've encountered visit Access 2.0 and Access 97 to Access
2000/2002 conversion problems
http://www.granite.ab.ca/access/conversionproblems.htm

Presumably you have a test SQL Server database setup. Just do the
conversion and test it thoroughly against the test database. Run
every screen, report and command button.

While there may be a few minor problems it really isn't that
difficult.
If I'm posting in the
inappropriate place, please let me know where I should post.

Excellent place to post.
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
R

Roger Carlson

Tony covered most of it. I would just add three things:

1) An Access "conversion" does not really convert anything. What it really
does is create a NEW mdb file in the new version, add the appropriate
references, and copy all of the objects from the old to the new. This
leaves the orginal database intact. You must give this new database a
different name than the old. However, it never hurts to make a back-up copy
of your original first!

2) Microsoft has a Conversion Whitepaper that you can find here:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q319400

3) If the A97 database was converted from Access 2.0 originally, you may
have some additional things to do. You might want to look at my website
here:
http://www.rogersaccesslibrary.com/knowledge.html
for an article called: ConvertingAccessDatabases2to97.zip
 
C

Craig

Tony,

Thank you for the QUICK response! I'm glad I found the right place
for my posting and I appreciate your thoughts. For now, I plan on
reading through that conversion document you pointed out for me. The
database that will undergo the conversion is about 60mb in size, and
it totals about 17 macros and about 20 total modules. From what I've
read so far, it looks like the only hiccups in the conversion process
will come as result of one of those macros or modules not cooperating.
I will give it a whirl and post results. Thank you again for your
suggestions and direction, and have an awesome day!
 
C

Craig

Roger,

Thank you for the added suggestions! I definitely won't shy-away from
more advice! From what I'm gathering, this really isn't going to be
that big of a deal, even with the involvement of SQL and the size of
the database. As long as I make a copy or three I can go back to how
it was, so there's really no excuse for not trying it. If anyone has
a reason not to, throw it in the arena and we'll see what happens.
Thank you again, Roger, for the additional thoughts!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top