Sorry,

I should clarify the works in my dev environment. By that I mean that it runs within the IDE. Not that it runs as an executable.

I can't get it to run as an executable at all without bringing up the database error.

Hope that helps illustrate my problem.


Cheers
John

>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 :-)