Solved

Using Access2000 for an Access97 Database

Posted on 2001-07-23
11
368 Views
Last Modified: 2008-02-20
The users have either Access97 or Access2000.

The app is in Access97.  

Can I prevent the "Convert/Open" window from being displayed to those who are using Access2000?

I realize this will only be true the 1st time they open it, but even that's a no-no.

And also, the "You can't make changes to the database objects in the database.." has got to go.
0
Comment
Question by:goldstar
  • 4
  • 3
  • 2
  • +2
11 Comments
 
LVL 12

Expert Comment

by:DRRYAN3
Comment Utility
You cannot prevent this.  A2000 uses unicode (double byte) based data, while A97 does not.  You will have to standardize on one or the other versions, or maintain two front ends (one in A2000 and one in A97) with a backend database in A97.
0
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
I would keep developing in A97 and make sure that the conversion to A2000 is errorfree by compiling the A97 version into an A2000 version and test that to be sure.
Thus the users choice to convert Yes or No is of no influence on your application.

Nic;o)

0
 
LVL 8

Expert Comment

by:DennisBorg
Comment Utility
>You cannot prevent this.  A2000 uses unicode (double
>byte) based data, while A97 does not.

The reason the user is asked whether they want to Open or Convert the database has nothing to do with Unicode.

ACC97 asked the same question when you opened an ACC95 or earlier version.

The reason Access asks the user if they want to Open or Convert the database is because the version of MDB file indicates that it was created with an earlier version of Access than is currently being used.

-Dennis Borg
0
 

Author Comment

by:goldstar
Comment Utility
OK, DennisBorg, I like that answer.  Now please tell me I can prevent the "Convert/Open" window from being displayed to those who are using Access2000.   please????????

0
 
LVL 12

Expert Comment

by:Paurths
Comment Utility
goldstar, if one who is using A2K opens the db, do u want it to be converted automatically?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 54

Expert Comment

by:nico5038
Comment Utility
I don't think so as it's an internal check of access.
I think I have to agree with DRRYAN3 in this. Your VBA code won't be able to intercept this. The only way would be to use a VB program that intercepts system calls, however this should already be running before activating the .mdb.
My comment is ment to show the way you can prevent problems by anticipating on both choices that can be made by the user. Basically using A97 for development is choosing for the "lower" version as it will be upgradable. An A2000 database just can't be used by A97 users, so there is effectively little to choose.... ;-(

Nic;o)
0
 
LVL 8

Accepted Solution

by:
DennisBorg earned 50 total points
Comment Utility
GoldStar:

>OK, DennisBorg, I like that answer.  Now please tell me I
>can prevent the "Convert/Open" window from being
>displayed to those who are using Access2000.   please????????

I can't say that I know the answer to that; I would have given it if I knew.

However, you might try using the /RO parameter on the command-line of the shortcut you use to launch Access. This might prevent the users from being asked if they want to Open or Convert the database. This command-line parameter tells Access to open the database in ReadOnly mode, meaning the user would not be permitted to modify and save changes to form design, table design, report design, etc.; but they would still be able to change data in the tables AS LONG AS they are linked in from another Database.

But even if this supresses the Open/Convert dialog box, I think it will bring up a Message Box informing the user of the ReadOnly status. This message box only has an OK button.


In my experience, once the user has chosen "Open", that user is no longer asked whether s/he wants to open or convert the database.


At the moment, that is all I have to share. I'm sorry I was unable to be of more assistance.


-Dennis Borg
0
 
LVL 8

Expert Comment

by:DennisBorg
Comment Utility
Nic;o)

>I don't think so as it's an internal check of access.

What is this comment in reference to?


-Dennis Borg
0
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
Hi Dennis,

I was referring to:
>OK, DennisBorg, I like that answer.  Now please tell me I can prevent the "Convert/Open" window from
being displayed to those who are using Access2000.   please????????

As I "missed" Paurths comment.

Nic;o)
0
 
LVL 8

Expert Comment

by:DennisBorg
Comment Utility
Nic;o)

>I was referring to: ... ... ... ... ... ... ... ... ...

Oh, OK. I probably didn't see that because of mushy-brain syndrome. Things have been very hectic here lately.

-Dennis Borg
0
 

Author Comment

by:goldstar
Comment Utility
Well, thanks for the dialog.

Paurths, no I don't want Access2000 users to convert it.

I guess I'll just have to continue to maintain 2 versions.

Still next time........



0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now