Search results

Hi all, I'm looking for a way to check whether or not Access is online with Sharepoint. I found a post here by drjohn61 that adds a dummy record and looks to see if the primary key is a positive integer. (A negative integer indicates Access is offline). The online status is indicated in the...

I have a question about the Recordset Update method in Access 2010 VBA using the DAO.Recordset. If I add a new record using the .AddNew method, where is the record inserted? At the end of the query regardless of the sort declared in the .OpenRecordset method? And if i add a new record that...

I have some questions about working with a split database. First off...i'm using Access 2010 and am planning to put the back end on a Network Accessible Storage drive and installing Access 2010 Runtime for my users. I can have as many as 10 users at once, with 3 of them needing access daily...

I'm new to Access VBA, but have dabbled a bit with Excel VBA...i've been reading quite a bit on the forum lately...so thank you everyone for asking the questions and posting solutions!