Datasheet in split form is empty (running using Access 2007 Runtim

[Palani]

Hello

I have several forms designed in Access 2007 using split form design model.
I have made datasheet in the split form read only and actual form portion
allowing user to create/edit/delete records in the table.

I need to distribute this to user who will not have full version of ACCESS
2007 installed instead they will be running this app using Access 2007
runtime.

I have used Developer extensions to create packaged solution and user can
install in their system (having run time already installed). When user opens
up the database, they can go form, add new record, save, ..etc. However
datasheet in the form doesn't display any records and record navigation
control shows no record count, ..etc.

I have already ensured that db location is trusted, ..etc. Can you help me
on what I am missing here ?

The user machine tried with Vista and Windows 7.. both didn't work.
Appreciate your help.

 

[Allen Browne]

There were several bugs with the new split forms in A2007. Some were fixed
with the service packs, but some remain unfixed as of SP2.

What I know of the bugs are here:
http://allenbrowne.com/Access2007.html#Bugs

But what's odd is if it works on your full A2007, but not on their runtime
A2007. Are you sure the users have the runtime with the service pack?
Perhaps you could try starting msaccess.exe with the /runtime switch.