<Access Sage, SQL n00b>
I've read all the posts I could find relating to this Q, but still a little unsure.
I can tell it's not the nicest thing that I could be doing, but I'm not too worried, it's not really a "Mission Critical Application"
What a need to do is make a copy of a "base" database so that a user can use it to do sensitivity tests, using SP's that I can call from the client side.
I know that it can be done, but what sort of things do I need to worry about. User's shouldn't be a problem, as I doubt there will ever be more than 1 (2 if I'm "lucky") user(s). If worst comes to worst, I could boot 'em out.
Things I'm worried about
- Users logins (just the 1)
- Server "crapping" its self
- Database doing as above
- Anything else that comes to mind
P.S. I can do it, just need to know what can go wrong