I am attempting to place my databse on a server. wish to split it, as access is able to do, and then i have shortcuts placed on the client desktop, to the forms, reports etc...

Two questions:

1) When it's split, I have troubles adding records..etc...seems like it's read only. THEN, when I update the tables, it seems like I can view the records that were already there, but not add new ones.
How can I get this to work?

2) Is there a way to 'compile' my front end, so the user only has the buttons and controls I've made, not the standard windows buttons and menus?


HELP!!!

Thanks!!

On the first note, ensure that the location you have stored your tables have the appropriate network permissions for use. These permissions can be inherited by the tables, hence making them read only or worse.
When it comes to "compiling" the front end, you will require the Developers Edition to achieve a true "executable" format. If you do not have the $$$ to get it, then try making an MDE. You can find this option in the same area as the database splitter utility. Keep in mind that MDEs are nice for deployment (wrapping every thing up into one package) they do not prevent the user from wreaking havoc. They also DO NOT enable all necessary references your database application requires.

jeremie_ingram,

It is NOT possible to create an executable out of an Access database with any product currently in existence nor will one ever come to market. An .mdb is a "data" file and it is simply not possible to turn a data file into an executable. The developer's edition DOES NOT IN ANY WAY change an Access database. It simply provides you with a license to distribute the runtime edition of MsAccess.exe so that your users do not need to have the full retail version of MsAccess.exe installed.

Search the archives for lots of discussion regarding using the runtime version of MsAccess.exe.