I'm going to be away from the office in July on some training, but need to give access to my manager to one of the tables in SQL Server. Originally I was thinking of using MS Access for this. I've used Access for simple database editing for bajillions of years, but the more I think about it, the less I like the idea of opening up the table to an untrained user. Then I thought of Microsoft's InfoPath. That should make it possible for her to do the simple edits that will be required, while I'm away at training. At least, that's my understanding of InfoPath. The only problem is I know very little about InfoPath. Where can I get some quick tutorial information on InfoPath?
-
-
Why not Lightswitch? I wouldn't use InfoPath.
-
@ZippyV: I tried setting up Lightswitch, but got lots of failures. And as often happens with me, other priorities take over and so I can't return back to it.
-
Back up your data and let him go at it with what is known?
SSMS, Access, ...
EDIT: Why not export the data to an .mdb file for him to edit with Access, then you've kept it seperate and save production data?
-
@JohnAskew: makes sense, thanks.
Add your 2¢