Separate view form dashboard

[htt373]

Hello there,
I need your help in creating a separate dashboard for accessing MS Access tables and forms. The dashboard will be opened in a seperate icon and if any data entered in this dashboard will update the data on the tables. In another words, if the user needs to update the tables, he will use this dashboard without opening the MS Access file. So, does access have the functionality to make a separate dashboard for viewing tables and updating the tables in a separate dashboard ?

Hints :
- The database won't be on sharepoint, it is only for one user.
- The data will be imported from an excel sheet to the tables.
- Only the forms will be displayed in the separate dashboard.
- I am using MS Access 2007.

Regards... Bedro

 

[ghudson]

Hint: Create another Access database and link the new database to the tables in the other [backend] database for the one user to update the tables.

Hint: The new database will need a form for the user to access the linked table.

 

[htt373]

Thanks Ghudson

What about creating new form that would be opened without access view and design mode ?

 

[ghudson]

How can you open an Access form without opening Access.mdb file?

Access 2007 has an option to send a form via Outlook 2007 to a user to update an Access table. I have not had a chance to play with it but maybe that is what you are after.

 

[boblarson]

You can use other programs to interface with Access (VB6, VB.NET, VC#, VC++, Java, ASP.NET, etc.) but if you want to use an Access form (as GHudson has said) you have to open Access to do it. There is no other way.

But you can have a separate frontend which is linked to the database and then you can provide only the form you want and lock all the behind the scenes viewing of linked tables, etc.

 

[htt373]

Thanks Ghudson, but I think that one of my friend's did it and he told me that there is another tool that would link your tables and forms designed using access and makes you view the access forms without opening the access.mdb

Boblarson that's great idea to code using these programming languages.

Thanks in advanced all of you guys, and i'll let you know about my friend's idea...