moving acces db to sharepoint

[pat67]

Hi all. Not sure if anyone here can answer but here goes. I want to
upload my db to sharepoint. I do not have permissions yet so I cannot
do it. But my question is how do the forms and reports function in
sharepoint? The help file in access says you can open forms and
reports from sharepoint, but my question would be is this done as read-
only? The reason I want to use sharepoint is so everyone doesn't have
the ability to make changes in the db. If I could limit everyone's
permissions, I could just publish the db on our LAN and have everyone
use it from there. If anyone has done this, please let me know.

Thanks

 

[Jeff Boyce]

If you make an .mde (for Access 2007, 2010, an .accde) of the front-end, the
users can't touch the code. Distribute that to them.

Be sure to hang onto a 'master' of the .mdb/.accdb, or you'll never (NEVER!)
be able to make changes yourself.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[pat67]

If you make an .mde (for Access 2007, 2010, an .accde) of the front-end, the
users can't touch the code.  Distribute that to them.

Be sure to hang onto a 'master' of the .mdb/.accdb, or you'll never (NEVER!)
be able to make changes yourself.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.







- Show quoted text -

I tried that but i get an error saying it exceeds the table limit.

 

[David W. Fenton]

:

I tried that but i get an error saying it exceeds the table limit.

You went to Database Tools -> Make MDE and you got that error
message? Can you give the specific error number and description?

And did you attempt to make the MDE in a fresh instance of Access
where you opened the source MDB bypassing all the startup functions
(so nothing is open)?

 

[pat67]

You went to Database Tools -> Make MDE and you got that error
message? Can you give the specific error number and description?

And did you attempt to make the MDE in a fresh instance of Access
where you opened the source MDB bypassing all the startup functions
(so nothing is open)?

It's accde and when try and make accde I get this message

Microsoft was unable to create the .accde, .mde, or .ade file

And I openened it with no startup functions.

 

[David W. Fenton]

:

It's accde and when try and make accde I get this message

Microsoft was unable to create the .accde, .mde, or .ade file

And I openened it with no startup functions.

Are the linked tables accessible?

Have you decompiled/recompiled the code?