SharePoint data entry into Access db

[Magster]

Hi all,

I have an Access 2007 database, FE on desktop, BE on a local server. I'd like to have a simple data entry form (with a few look-up lists from the database) in Sharepoint that would allow a user (who doesn't use the actual database) to insert a record- something like a help desk ticket into the database. And maybe have the ability to run some of my reports too.

Would Sharepoint be the best tool? Or is there a better solution.

I'll refrain from providing more info until asked.

Thank you!

 

[Big Pat]

Hi,

I'm pretty new at sharepoint but I have linked LISTS in sharepoint to TABLES in Access and it works fine. Records entered by the sharepoint user show up in Access (and I think vice versa if you have Access 2007)

I'm afraid I don't know of a way to get sharepoint to run the Access reports though. Might be possible, but way too adventurous for me. Sorry.

 

[Magster]

Thanks Big Pat for responding,

And, yes I do have Access 2007 ...

One other thing that I forgot to mention is that the users that will use data entry in SharePoint are remote in other offices throughout the state, so I know I have to find a different way for them to enter data because Access even split into FE/BE is way too slow.

I think I try the wizard in Access and see what that does.

 

[ghudson]

I also use Lists in SharePoint for users to add/edit data. Then I link an Access table to the SharePoint lists. Just think of a SharePoint List as a spreadsheet. Only downside is you cannot use an data validation on the SharePoint side when the users are keying their data. I then use queries in Access to identify problems with the data. Since all users do not have Access 2007, this works for now but I am hoping that hosting an Access 2007 database on SharePoint will work smoothly when that day comes for me.

 

[SOS]

2007 with SharePoint still isn't that great. 2010 with SharePoint is going to be much better but they still have work to do to make it really robust for users of Access/SharePoint together.