My database is written in Access 97 (I know get out of the stone age) but we have a mix of office 97 and office 2003 users. Anyway I'm afraid that one of the few people that have access 2000 or higher will open my database and convert it. I found (through here) code to check the version but it is attached to a form opening which is way to late. Is there a way to have access check the version as soon as you click to open the database and if it isn't 97 close the database?
Keep Access 2000 & higher out of my 97 database
- Thread starter rgreene
- Start date
boblarson
Smeghead
- Local time
- Yesterday, 20:29
- Joined
- Jan 12, 2001
- Messages
- 32,025
I think if you create an MDE from it and have people use that one, they can't convert an MDE file. I'm not totally sure about that, but I think so. It should be easy to test as you could just create one and then see what happens when someone with another version tries. It won't do anything to your master mdb file.
boblarson,
Thanks for the reply, I did make it an mde and that didn't let me conver it but I would prefer to not get that far. I'd like so when I click on Library.mdb(mde) it checks and if it isn't access 97 maybe a messabe box pops up and says "Can't use with this version of access" or something like that. Not even get to the screen that gives them the option to convert
Rick
Thanks for the reply, I did make it an mde and that didn't let me conver it but I would prefer to not get that far. I'd like so when I click on Library.mdb(mde) it checks and if it isn't access 97 maybe a messabe box pops up and says "Can't use with this version of access" or something like that. Not even get to the screen that gives them the option to convert
Rick
boblarson
Smeghead
- Local time
- Yesterday, 20:29
- Joined
- Jan 12, 2001
- Messages
- 32,025
I don't think there's anything that exists like that. However, I've been known to be wrong before (at least once 
). However I do remember seeing a post recently about a product that would open the access database in the correct version, but I think it was opening it from that product.
). However I do remember seeing a post recently about a product that would open the access database in the correct version, but I think it was opening it from that product.
- Local time
- Today, 03:29
- Joined
- Sep 12, 2006
- Messages
- 16,056
another reason to split fe/be
your users can do whatever they want to their own copy on their own machine. if they can't see your copy they can't deal with it.
i also put code in the startup form of the master network copy to close the app straight away if it runs - it just tests whether the drive letter is greater than say drive H.
your users can do whatever they want to their own copy on their own machine. if they can't see your copy they can't deal with it.
i also put code in the startup form of the master network copy to close the app straight away if it runs - it just tests whether the drive letter is greater than say drive H.
Similar threads
