Thanks for the speedy reply Hilmar,

I should have mentioned those things. *sigh*

Yes, the database and tables are in the same directory and as far as the OS is concerned are read/write. That includes user permissions as well.

The database has been excluded from the project.

The thing I'm slightly bemused about is the error bringing up my development location for the tables and not the location where I have placed them on the machine.


Cheers
John

>Some things to watch out for:
>

The tables and the database should ideally all be in the same directory.
>

The tables should be writable. Sometimes, when you copy files over a CD, files become read-only.
>

Tables and database may be listed in the project, but they must be marked as "excluded", which means, they will not be included in the final executable.
>
>>Hi there,
>>
>>Now that I'm at the point of distributing my application for enduser testing, I figured that an executable would be the best way to achieve that.
>>
>>While it runs fine in my dev environment, as soon as I compile to a .exe and distribute with the database and tables, I get an error
>>
>>'the database for xxx could not be opened. Would you like to locate the owning database or delete the link...'
>>
>>I tried locating the database, but that just returned a read only error, and the location of the file is my development directory.
>>
>>Bizarre.
>>
>>Well... to me :-)