Need to update an ancient Access97 "program".

[Hilton]

I have a "program" here written entirely in MS Access, and I need to figure out how to update it. For background, the program controls a database of people and items for the shop owners and police, runs in Access 97, and ran on Windows 98. And has for the last 12 years.

They desperately need to get away from Acc97 and Win98 for obvious reasons, but nobody has been able to make this program work on another operating system. Now it's my turn! I've tried a couple things, nothing working yet. The only obvious thing I haven't directly tried is installing Office 97 on a modern Windows system, or installing Win98 in a virtual box.

Anyway, the scripting in this program controls everything. It directly and automatically interacts with two printers (one modern standard USB, one serial receipt printer) and a scanner (for ID).

Now the interesting part. In Access 97, the program hides all the standard controls and displays only its own toolbar, and the customer DB. using various buttons (ie. find customer, add customer, and some other stuff) will open up forms which show their own toolbars. For example, clicking find customer will give you a simple search box, then a results list, then a form displaying customer information which replaces the toolbar with its own with some other options, find item, add item, update record, etc.

I have unconfirmed information that this program also works fine in Office 2000, but in Office 2007 the toolbars will not show up (the Ribbon stays visible), rendering it unusable.



How can I fix this?

[Datagopherdan]

I would recommend trying to do it in stages. Import the objects to a blank 2007 database if converting it directly from say the 2000 version to 2007 isn't working. You can try running the procedures and setting breakpoints in the code, so you can where the problems are. You can then correct the problems such as updating the references, which should take care of the majority of it or you can just go to the module and references and see where you have broken references and update those with the 2007 ones.

I have a "program" here written entirely in MS Access, and I need to figure out how to update it. For background, the program controls a database of people and items for the shop owners and police, runs in Access 97, and ran on Windows 98. And has for the last 12 years.

They desperately need to get away from Acc97 and Win98 for obvious reasons, but nobody has been able to make this program work on another operating system. Now it's my turn! I've tried a couple things, nothing working yet. The only obvious thing I haven't directly tried is installing Office 97 on a modern Windows system, or installing Win98 in a virtual box.

Anyway, the scripting in this program controls everything. It directly and automatically interacts with two printers (one modern standard USB, one serial receipt printer) and a scanner (for ID).

Now the interesting part. In Access 97, the program hides all the standard controls and displays only its own toolbar, and the customer DB. using various buttons (ie. find customer, add customer, and some other stuff) will open up forms which show their own toolbars. For example, clicking find customer will give you a simple search box, then a results list, then a form displaying customer information which replaces the toolbar with its own with some other options, find item, add item, update record, etc.

I have unconfirmed information that this program also works fine in Office 2000, but in Office 2007 the toolbars will not show up (the Ribbon stays visible), rendering it unusable.

How can I fix this?