Access 2003: Can't export to a *.dat file

I have a split database using Access 2003.  I've written code to export query results to a *.dat file.  See below:
 
DoCmd.TransferText acExportDelim, "Tabquick Labels", stDocName, "\\pd0ns-wdc002\projdoc$\nsgs.dat"  

When this runs I get a MS Access error "Cannot Update.  Database or Object is read only"

I've verified that  I have full rights to the database and all the objects inculding MSysIMEXColumns and MSysIMEXSpecs.

If I try to export this as any other format, i.e. *.txt, it works fine.

What do I need to do to export to a *.dat file?

Some history on this database:  This was a AC97 database with the tables and other objects all in one mdb.  This piece of code does work under these conditions so I'm not sure if it's because the database is split or if it is because it has been converted to 2003.

Thanks
N.
ncrewAsked:
Who is Participating?
 
Steve BinkConnect With a Mentor Commented:
Here's the relevent link from Microsoft.  This is for Office 2000, but it likely applies to 2003 as well:

http://support.microsoft.com/default.aspx?scid=kb;en-us;304206
0
 
Steve BinkCommented:
Export to a text file, then rename it after the fact to .dat.  Is there a reason you need to use .dat over .txt?
0
 
NestorioCommented:
I think .dat is a special type of file. Try exporting to a .txt extension file and then renaming it to .dat.
0
 
ncrewAuthor Commented:
Routinet,

You're the greatest!  Because I have 2003 I had to go a little deeper into the registry than the paper listed, but I found it and this works great!

Thanks!
N.
0
 
Steve BinkCommented:
Anytime.  :)  Good luck with the rest of your project!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.