Hi all,

We have a simple file conissting of a single table populated with 74,880 (ish)
records.

No other macros, modules, tables or forms... simple single table.

YET - Access 2000 runtime and Access 2003 runtime are not able to open the file.

The file works fine in Access 2000 full version..

Any ideas what's causing this ?
I've compacted, repaired, copied the dat to another file.. still not readable.

It opens up in runtime - but does not show the table.. pressing Windows - view
- horizontal shows an outline of the window area where the table should be
but it's blank.

Any ideas ?
(I can supply the file if you like to play with it via e-mail)

Regards

Doz

Doz wrote:
> Hi all,
>
> We have a simple file conissting of a single table populated with
> 74,880 (ish) records.
>
> No other macros, modules, tables or forms... simple single table.
>
> YET - Access 2000 runtime and Access 2003 runtime are not able to
> open the file.
>
> The file works fine in Access 2000 full version..
>
> Any ideas what's causing this ?
> I've compacted, repaired, copied the dat to another file.. still not
> readable.
>
> It opens up in runtime - but does not show the table.. pressing
> Windows - view - horizontal shows an outline of the window area
> where the table should be but it's blank.
>
> Any ideas ?

The runtime NEVER shows the db window. Files to be used in the runtime must
be full-blown developed applications were the developer has created menus
(forms or bars) to allow access to all of the objects. None of the standard
interface is availabel in the runtime environment.

If your file had some code or a macro to open the table autoamtically at
startup then you would see it in the runtime.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Tue, 07 Nov 2006 18:14:00 GMT, Rick Brandt wrote:

> Doz wrote:
>> Hi all,
>>
>> We have a simple file conissting of a single table populated with
>> 74,880 (ish) records.
>>
>> No other macros, modules, tables or forms... simple single table.
>>
>> YET - Access 2000 runtime and Access 2003 runtime are not able to
>> open the file.
>>
>> The file works fine in Access 2000 full version..
>>
>> Any ideas what's causing this ?
>> I've compacted, repaired, copied the dat to another file.. still not
>> readable.
>>
>> It opens up in runtime - but does not show the table.. pressing
>> Windows - view - horizontal shows an outline of the window area
>> where the table should be but it's blank.
>>
>> Any ideas ?
>
> The runtime NEVER shows the db window. Files to be used in the runtime must
> be full-blown developed applications were the developer has created menus
> (forms or bars) to allow access to all of the objects. None of the standard
> interface is availabel in the runtime environment.
>
> If your file had some code or a macro to open the table autoamtically at
> startup then you would see it in the runtime.

Ok thanks for the info.. makes sense really.