Project export to Access

[Melissa V.]

I have set up an export map in a project file to export to access. It only
works the first time. If I update the file and re-export, the project
application shuts down. Does anyone know of this issue and how to resolve it?

 

[Rod Gill]

Haven't heard of that issue, but try saving the project to .mpd format. That
is an Access Database format you can open directly in Access (You need to
File,Open and select file type all files to see a .mpd format in Access).

Search Project's program folders for prjdb.htm which will tell you exactly
what data is in what tables.

 

[Melissa V.]

Thanks, I will try that. This problem occurs with the older version of
project too, not just 2003. One thing I did notice is that when this
happens, the access database shows a locking database file along with the
original database file. Once I open the database to clean up the exported
table, the locking db disappears. Could this be a locking issue?