VBA for helping with data and sharepoint issue

[carahorse]

So I have a reservations system. I am using MS Access, and I assumed (wrongly) that we would be able to set our tables as sharepoint lists and be able to work offline if the internet service went out. Definate Problem i still need MS Access to allow our volunteers and employees to login ect.

Sooo, I am thinking that if I can make one set of tables for working offline, and another set for just sending the data to sharepoint so that I, or volunteers can view the info from anywhere.

So maybe a VBA code could copy and send data to the SP linked tables.

yes I know this defeats the purpose of a database two have two sets of tables. And the native "work offline" button in MS access is not working form me as needed.

I am thinking I could get my forms to all send data via VBA event to the sharepoint links tables but I am not sure how to reference the sharepoint linked table

would it be something like
unlinkedreservationstableform_afterupdate

me.Full_Name= Full_Name[sharepointreservations]table!.value
end sub?

Just learning vba

and what do I do for updates to the reservations? how to link the tables?

Thanks a bunch, sometimes our internet is down, and sometimes I have to answer phones and take reservations when I travel