472,960 Members | 2,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,960 software developers and data experts.

Periodic prompt to Convert database

We designed a custom application using Office Developer Tools '97 which
included a Run-time version of Access--- so it would not matter if our
customer even had any version of Access on their computer. The
application ran without problems on our customer's computer for 2-3
years. Then our customer bought a new computer and we had to reinstall
the application. Everything was ok for approximately 6 months until our
customer was "cleaning up" their system and began deleting files, and
the next time they went to open the application they got this message:

"You have selected a database created in a previous version of
Microsoft Office Access. You can convert or open the database. Either
action may take several minutes.

Then it gives two boxes Convert Data or Open Data.

Convert Data:
Convert the file to the default file format specified on the Advanced
tab of the Options dialog box under the Tools menu.
If you convert to Access 2000 you won't be able to open the file in
Access 97 or earlier; If you convert to Access 2002-2003 you won't be
able to open the file in Access 2000 or earlier.

OpenDatabase:
Open in Access, but maintain the original file format so that you can
still use the file in previous versions of Access. If you open in
Access you can view objects and modify records, but you can not make
design changes only in the previous version"

We reinstalled the appliation from the original CD and copied their
current MDB into the directory. The program has again run successfully
for over 2 months. Now the customer has the same error message and has
not been "cleaning up" their system.

Any ideas on why this periodically occurs?

Thank you!

May 24 '06 #1
5 2515
Hi.
Any ideas on why this periodically occurs?
Yes. The customer has also installed Access 2003 on the workstation, but
has failed to configure the workstation for multiple versions of Access.
Whenever the "Convert or Open" dialog window appears, then the customer is
attempting to open the Access 97 file, but the previous use of Access was
with Access 2003, not the Access 97 Runtime.

The customer can configure the workstation so that both versions of Access
can co-exist in harmony, or the customer can create Windows shortcuts to
open specific versions of Access to run specific Access files. The syntax
for the shortcut is:

C:\SomeDir\Access97Runtime.exe C:\AnotherDir\MyDB.mdb

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<me******@yahoo.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com... We designed a custom application using Office Developer Tools '97 which
included a Run-time version of Access--- so it would not matter if our
customer even had any version of Access on their computer. The
application ran without problems on our customer's computer for 2-3
years. Then our customer bought a new computer and we had to reinstall
the application. Everything was ok for approximately 6 months until our
customer was "cleaning up" their system and began deleting files, and
the next time they went to open the application they got this message:

"You have selected a database created in a previous version of
Microsoft Office Access. You can convert or open the database. Either
action may take several minutes.

Then it gives two boxes Convert Data or Open Data.

Convert Data:
Convert the file to the default file format specified on the Advanced
tab of the Options dialog box under the Tools menu.
If you convert to Access 2000 you won't be able to open the file in
Access 97 or earlier; If you convert to Access 2002-2003 you won't be
able to open the file in Access 2000 or earlier.

OpenDatabase:
Open in Access, but maintain the original file format so that you can
still use the file in previous versions of Access. If you open in
Access you can view objects and modify records, but you can not make
design changes only in the previous version"

We reinstalled the appliation from the original CD and copied their
current MDB into the directory. The program has again run successfully
for over 2 months. Now the customer has the same error message and has
not been "cleaning up" their system.

Any ideas on why this periodically occurs?

Thank you!

May 24 '06 #2
Wow, a 69 Camaro...sweet!

Thank you for the reply. How can a "workstation be configured so that
both versions of Access can co-exist in harmony" ? Is this a setting
within one of the versions of Access?

Thank you again!

May 25 '06 #3
Hi.
How can a "workstation be configured so that
both versions of Access can co-exist in harmony" ? Is this a setting
within one of the versions of Access?
The "configuration" is mostly how the multiple versions of Microsoft Office
are installed. Microsoft recommends not installing multiple versions of
Office on the same computer, so it will never be "some setting" that can be
changed to get the multiple versions to work together without stepping on
each other.

Basically, the versions need to be installed in the order of manufacturer's
release, i.e., Office 97 was released by Microsoft before Office 2003, so
Office 97 should be installed first, then Office 2003. Your customer lucked
out here.

The versions must be installed in separate directories, without allowing the
installer to remove the earlier versions. Your customer may have lucked out
here, too, but your description doesn't prove or disprove whether the Access
97 Runtime version is still installed.

The versions must not be allowed to re-register themselves whenever one
version of an Office application is opened after the other version was
opened. This can manifest itself with either a significant delay when
opening the application or by displaying the message, "Please wait while
Microsoft Office <version> installs ...." Access 97 is particularly bad
about this. This is a very annoying problem when User-level security has
been implemented, because when switching back and forth between versions of
Access, the user will will be joined to the default workgroup, regardless of
whether or not the user was joined to a secure workgroup the last time that
version of Access was opened.

If the versions aren't re-registering themselves, then the last version
installed will, by default, open a file whenever it's double-clicked, so if
this isn't the desired behavior (and it isn't in your customer's case),
further configuration needs to be done to get the earlier version to open
the file. Or a third-party utility for detecting the file version prior to
opening the file can be installed, or the right-click pop-up menu can be
configured to allow user selection from the multiple versions of Office
applications to open the file.

Most computer users don't want to pay an IT expert to do any of this
configuring, but they aren't savvy enough to configure it successfully
themselves, so the Windows shortcut method I suggested earlier is a viable
alternative that works regardless of whether or not they've configured the
workstation to work with both versions of Access.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<me******@yahoo.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com... Wow, a 69 Camaro...sweet!

Thank you for the reply. How can a "workstation be configured so that
both versions of Access can co-exist in harmony" ? Is this a setting
within one of the versions of Access?

Thank you again!

May 25 '06 #4
Thank you very much for such a detailed reply. I really appreciate it!

May 25 '06 #5
You're welcome! Glad to help.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<me******@yahoo.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
Thank you very much for such a detailed reply. I really appreciate it!

May 25 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Hans Forbrich | last post by:
The following is a Request for Discussion, following up on some recent posts about distributing a periodic news group 'Charter and FAQ' post. While not formally following RFC/RFD rules, the intent...
0
by: Hans Forbrich | last post by:
Section 1. Ballot: ------------------- 1.YES NO: I agree that there should be a periodic post describing the newsgroup charter and providing a FAQ on newsgroup usage. 2.MONTHLY BI-WEEKLY...
0
by: Hans Forbrich | last post by:
Section 1. Ballot: ------------------- 1.YES NO: I agree that there should be a periodic post describing the newsgroup charter and providing a FAQ on newsgroup usage. 2.MONTHLY BI-WEEKLY...
0
by: Michael Welsh | last post by:
MySQL v 3.23.56 for pc-linux-gnu on i686 How do I know what database I am 'using' ? I launch mysql from the command line. Type 'show databases', then pick a database to use by typing 'use...
8
by: Stephen Rice | last post by:
Hi, I have a periodic problem which I am having a real time trying to sort. Background: An MDI VB app with a DB on SQL 2000. I have wrapped all the DB access into an object which spawns a...
1
by: nishantxl | last post by:
Hi there, I am looking to design a project using C++ The main objective of the project is to display details of periodic table elements such as periodic element name, properties(such as atomic...
11
by: gopal | last post by:
Hi, I am trying to call the OSQL utility from my C# console application and i am having problems i have the following code In Main method ProcessStartInfo psi = new...
4
by: ARC | last post by:
Hello all, I didn't use to have this problem in Access 97, but in 2007 (and maybe other versions of access after 97), if you have a form that has a subform, and you click the close button, you...
9
by: javedsai | last post by:
Hi, I need to build a functionality which can take backup of my database periodically, i.e. admin must able to set the timer in how many days he wants to run database backup. For example, If admin...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.