DO NOT convert

[rgreene]

We have both Access 2003 and Access 97 users on our network and i have a database that is written in 97. But lately we've been getting unrecognized format when we open it. So my guess is someone out there is opening it in 2003 and converting it. Is there a way to tell the database to ONLY run on 97 and DO NOT convert to a different version?

Thanks,
Rick

 

[neileg]

Make it an MDE?

 

[gemma-the-husky]

also do not share the front end/whole database.

give each user their own front end copy, then they can update it if they want

 

[rgreene]

Husky,

I did split the database if that is what you mean. The data side is what is giving me the unrecognised format message.

 

[gemma-the-husky]

Ah

that means one of your users has opened and converted the backend database, because they couldn't do that from the front end. What do you do, keep converting it back to A97?

Its very hard, because I don't suppose you want to try to put security on the be, do you. Can you limit access to the be folder?, or would that stop users using the DBS?

 

[ColinEssex]

Or write some code to check what version is being used. If its not 97 then close the Db.

You use the

SysCmd(acSysCmdAccessVer)

Acc97 is 9 in the SysCmd


Col

 

[rgreene]

that means one of your users has opened and converted the backend database,

That was my thoughts but I have both 2003 and 97 (each on different machines) and when I tried to opent he "be" in 2003 it said it needed to be repaired so I did that and the it asked if I wanted to convert it so now I'm guessing it is just getting corrupt somehow.

When I split the database the only reason I did it was that I had just learned of the feature and wanted to try it out. I'm wodering if I shouldn't just put it back into 1 db. There really isn't a NEED for the split. What are your thoughts?

Rick

 

[gemma-the-husky]

i think most sources here would recommend splitting any multi user dbs

 

[boblarson]

Amen to that! I would highly recommend it too, as your data is less likely to become corrupt if there is a network disconnection (however how brief), and it's easier to replace a frontend with a copy than it is to replace your data.

Also, your users are less likely going to be having problems with too many users accessing the same file. And if one user opens the database (frontend or single database if not split) exclusively the other users won't be locked out and unable to work since they would be able to open their own front end.

 

[teiben]

SysCmd(acSysCmdAccessVer)

How would you write the exact syntax / code? Since I use a switchboard I suspect it would be placed on the form load event,

If SysCmd(acSysCmdAccessVer) = 9 ' Acc97 is
if something diffferent msgbox "Please use access 97"