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! 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!
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!
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!
Thank you very much for such a detailed reply. I really appreciate it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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=()=>{
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |