Will my application work with Sharepoint?

[diego.gsantos]

Hello everyone.

I would like to know if my application will work with sharepoint, if I have some code in my forms...

I want to use only the tables in the sharepoint server, and use a local client to run forms...

VBA will still work If I do this?

I can't test, because we still don't have the sharepoint server installed.

+1 Question?

If I deploy a version of my application in accdr it will work without having MS Access installed in the computer?

Thanks o/

 

[Pat Hartman]

1. A client/server Access database (as opposed to a web database) can link to SharePoint lists as if they were tables. It can also employ VBA and print reports. Don't expect this to be speedy. SharePoint lists loose their usefulness once you get past a few thousand rows.

2. To run an Access application, the user MUST have Access installed. He doesn't need the full retail version though. He can use the free runtime engine which can be downloaded from the MS site. If you are going to have your users use the Access runtime, you will need to download the correct version. I'm not sure if A2007 is still available but A2010 is. I wouldn't go to A2013 unless you are absolutely certain that MS didn't deprecate something your app uses. Generally it is best to use the runtime for your development version but you can usually go "up" and you cannot go "down". So the A2003 runtime (which wasn't free by the way) will NOT run an A2007 app.

3. Renaming the database as .accdr is no protection since the user could simply name it back to .accdb with no ill effect. the .accdr extension is useful because it tells Access to pretend to be the runtime engine so even if the use is running a full version of Access, a file with the .accdr extension cannot be opened in design view. It would need to be renamed first.

 

[diego.gsantos]

Thank you for your clarification Pat Hartman!