Re: Remove all Security.

Hi Douglas, I think you are right. However It will save the file with an
..CSV extenetion. But the problem is still there. The command seems to be
working in it's orginal place. I get the error when I try to run it in a
macro. This macro is a name "Test PPS CSV format". I wont to send in a test
file to see if it will work.?.

Keep in mind that the command seems to work in it's orginal place but not in
the macro.

Regardless of the above: Is there a way to disable all Security options in
a .MDB?


"Douglas J. Steele" wrote:

> I'm not sure you can use TransferSpread*** to a .csv file. See whether it
> works going to a .xls file instead.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Scott Burke" <ScottBurke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:70DB1521-A32B-4B0A-9ABE-B9492240977B@xxxxxxxxxxxxxxxx
> >I have a lot of programs written by other programmers. They don't work
> >here
> > anymore. However they left there mark. The Security settings are all
> > over
> > the Access map!
> >
> > how do I diable all sercurity in a .MDB?
> >
> > If not is there a tool that can disable all sercurity?
> >
> > The most import need right now:
> > I have a table that is Read-only. I know this because the following
> > command
> > tell's me:
> > DoCmd.TransferSpread*** acExport, , "PPS_CANCELS",
> > "T:\CLEARWIN\COACANCELS\PPS\PPS_TEST.CSV", True
> >
> > But I cann't find were it is set to read only.
> > Help please.
> > Scott Burke
> >
>
>
>
.