Lose Conn. revert to Recent file?

[kbreiss]

I have a user that has been making appointments, but no other users are able to see the appointments he has been making. I checked his icon and his database is sitting on his C drive. So I checked the network folder where the database SHOULD be located and that folder was gone.

Well, now I know they are going to want an explanation....

My question is......if the icon can't find the database because they lost their connection with the network.....it will ask him if they want to browse to find the db. Will it revert him to the recent folder on his C drive containing the database? And if so, if they click "ok" will it add the database to his c drive. I'm thinking maybe this is what happened. Wanted to know if anyone else knew for sure.

Thanks,
Kacy
________
Body Science

 

[WayneRyan]

kacy,

If your user was an a2000 user and he was pointed at an A97
database, Access would ask him if he wanted to convert it.
He could respond yes and put a "copy" on his "c" drive, but
he should not be able to delete the original.

What should happen is that you have a db on a server, user's have
an icon on their desktop that points to it, or you use a
a "launcher" to start access.

By far the best is to use a "launcher". This can be an Icon -
Icons have "command lines".

It could be a readable ".bat" file or VBScript that invokes
Access, with the proper db, and possibly a "workgroup" security
file.

Ideally, the launcher would be something that does the above,
but is an executable, or something that is unreadable by the
user.

Wayne

 

[kbreiss]

Thanks Wayne.
________
Lovely Wendie99