Remove all Security.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.TransferSpreadsheet 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
 
I'm not sure you can use TransferSpreadsheet to a .csv file. See whether it
works going to a .xls file instead.
 
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?
 
Back
Top