read only database issue

S

Southern at Heart

The below line exports a table to another database. I get an error when that
database is 'read only'. Can I programmatically change the database
strLocation to not be read only?

DoCmd.TransferDatabase acExport, "Microsoft Access", strLocation, acTable,
strTable, strExportedName

thanks,
SouthernAtHeart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import table into database Access 2007 3
Access 2007 security warning with DoCmd.TransferDatabase 1
ms access table to "dBase IV" with index .cdx 3
Dynamic Naming of Form Button 3
DoCmd.TransferDatabase acExport to SQL server 2005 2
Open new database 1
Can DoCmd.TransferDatabase be used to move table to BE 6
Sub projects added as read only in Master file which are saved on sharepoint 1

Top