JohnG (12/4/2008)

---

Note that even in America, extended ASCII is very common. Just think of all of peoples names that have accents in them. Or the word resumé. ...

I'd still try the import wizard... it has surprised me quite a few times. Worst case scenario, you're still stuck at the same place.

Let me get in on that!

Thanks Jack, awesome information and we seem to be thinking somewhat alike (I was going with making to permissions app myself and integrating it with the c# app that we...

Let me jsut throw something else out there... those permissions needs to be able to be set by the directors of the shop (without the intervention of the it group...

We are opened to anything at this point. I have never read and even less implemented anything of the sort.

You have anything I can read up on the subject?

Open access with the ms shortcut (not double-clicking on the db file)

Then open a database and browse to that db, in the options open it as single user or exclusive...

Another bit of info, as far as I remember, if the ldb file is in use, it cannot be deleted (easily anyways) without closing the access applications using it.

Only if sql does a clean shutdown... and that all other connected apps to the mdb file are closed. Then if the lock is still on then you have...

I'll let the gurus in the matter answer that one... my knowledge of bcp stops at spelling it ;).

Is this a valid option : create an ssis package that does...

a simpler option would be this : WITH EXECUTE AS dbo... this solves most of the problems especially with dynamic sql (or you'd have to give the rights to the...

Another point is "how dumb does the dba think you are"?

I mean if you are trusted with maintaining the system, the data and full access to the core of the...

If it's worth beating to death on the forums, it means that th ecommunity needs to hear it... people wanting to hear what you have to say or needing to...

Or maybe I'm too quick at my work and I have to keep busy!

That or I don't have a life outside of SSC :w00t:.

Steve Jones - Editor (12/1/2008)

---

I'd bet it's...