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

Access 97 to Access 2003 comaptibility issues?

P: 1
Hi -

I tried to search the forums on this issue, but couldn't get good results. I'm sure this has been asked before, so hopefully it won't be too hard to find an answer ...

I have a database created in Access 97 with a lot of VBA code embedded in it. I don't think I will be allowed to convert it to Access 2003, since a lot of users outside of my group still access the database with Access 97.

That said, I want to run the Access 97 database using Access 2003 in my department.

My questions are:

1) Are there any known issues that can cause Access 2003 to get unexpected query results, crash, or corrupt the Access 97 database?
2) If I was able to convince my boss to allow me to change the format of the Access 97 database, would there be any significant benefits?

Thank you!

azjazz
May 14 '07 #1
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,634
Hi -

I tried to search the forums on this issue, but couldn't get good results. I'm sure this has been asked before, so hopefully it won't be too hard to find an answer ...

I have a database created in Access 97 with a lot of VBA code embedded in it. I don't think I will be allowed to convert it to Access 2003, since a lot of users outside of my group still access the database with Access 97.

That said, I want to run the Access 97 database using Access 2003 in my department.

My questions are:

1) Are there any known issues that can cause Access 2003 to get unexpected query results, crash, or corrupt the Access 97 database?
2) If I was able to convince my boss to allow me to change the format of the Access 97 database, would there be any significant benefits?

Thank you!

azjazz
I do not think that the Major Problem would be with possible corruption of the Access 97 Version, but with code conversions and modifications. The syntax is completely different. You also would be able to View Objects and Modify Records, but you would only be able to make Design Changes in the Access 97 Version, not in the 2003 Version. The advantages of coverting to Access 2003 would be numerous.
May 17 '07 #2

puppydogbuddy
Expert 100+
P: 1,923
See this link for a list of conversion issues with respect to Access 97

http://allenbrowne.com/ser-48.html
Jun 2 '07 #3

ADezii
Expert 5K+
P: 8,634
See this link for a list of conversion issues with respect to Access 97

http://allenbrowne.com/ser-48.html
Nice post, puppydogbuddy.
Jun 2 '07 #4

puppydogbuddy
Expert 100+
P: 1,923
Nice post, puppydogbuddy.
Thanks. In my opinion, Allen Browne's web site is one of the most helpful sites for MS Access tips and problems.
Jun 2 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.