database or object is read only error

[Leon]

hi
I've written a macro in access to export data in a .ndf format to a
directory on the local drive. This works fine on my computer, but ,when I
install this application on another computer, i get the database or object is
read only error.
-The data base is not read only as it allows new records to be inserted
into the tables.
- The directory where the download writes is also not read-only.

 

[Allen Browne]

What program handles NDF files?
Is this program on the computer that cannot generate the file?

Over the last 10 years, Microsoft has been crippling Office so that it
cannot handle Unregistered file types. In some cases, the import/export
fails with this not-very-helpful nonsense about "read-only", which is
actually an inaccurate message about not being allowed to create the file
type.

If that is the issue, you may be able to create a registered type (e.g.
txt), and then rename it to what you need.

 

[Leon]

hi allen
I think i found out whats going on. MS access does not support .NDF formats.
I had to insert this extension in the Disabled extensions file in RegEdit.

see below from a previous query:
Locate the Disabled Extensions value under the following subkey in the
registry:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text
On the Edit menu, click Modify, append the new(ndf) extension to the
existing list, and then click OK.

NOTE: Elements of the Value data list are separated by commas.

I remember doing this for my machine, but failed to do it on the other
machines that i'm installing the applications on.

Cheers