Split web database macros

[dreday]

Need some help with splitting a web database. So I have a fully functioning web database that exists on Sharepoint but the performance is pretty poor online. I was thinking that splitting the database would be a good way to help speed things up as that usually improves performance on client databases. I used the wizard to split the database which worked successfully but now all the data macros fail in client mode and won't upload to Sharepoint. Any advice on how to get the data macros working again? Any help is greatly appreciated.

Thanks all!

[June7]

Convert to VBA?

[dreday]

Thanks for the reply!

I was under the impression that VBA was not allowed in web databases hosted on Sharepoint, only Macros. Have you had a different experience? If so please let me know how to convert to web enabled VBA.

[June7]

Sorry, no experience with Sharepoint. Now that you mention it, think I have heard that before. I have used macros only couple times (when absolutely had to) so lost track of that bit of trivia.

[dreday]

No worries, I'd never used them either until the Web option was added in 2010.