I have created an app with several forms, queries, tables, reports, and macros. I used Access2000. Problem is that several of the users that need to use this are running 97. IT dept suggests redoing the app in 97. But it took over a month to finally get just right. I really don't want to redo everything.
What is lost going from 2000 to 97. Are relationships lost?
I'm think I can extract the data in the tables and retain table structure. But I have no idea if queries will still run, or if forms will still open. Do I just copy the whole database and open in 97 and see whats there? Has anyone had to deal with anything like this.
If anybody has any ideas they think may work, please let me know. Thanks a lot.
What is lost going from 2000 to 97. Are relationships lost?
I'm think I can extract the data in the tables and retain table structure. But I have no idea if queries will still run, or if forms will still open. Do I just copy the whole database and open in 97 and see whats there? Has anyone had to deal with anything like this.
If anybody has any ideas they think may work, please let me know. Thanks a lot.