0

I have an Excel addin which reads/writes from/to a MS access db that is installed on the user's local machine. So each user that installs the addin also needs their own stand alone Access db as well.

I'd like to do this with a SQL server db instead. How can I do that without needing to install SQL server instance on every computer. Is that possible?

I jsut want to add the mdf file on the local/client machine as well as any drivers and then via vba read/write from/to that mdf file

Community
  • 1
  • 1
ptownbro
  • 1,240
  • 3
  • 26
  • 44
  • LocalDB does this: https://msdn.microsoft.com/en-us/library/hh510202.aspx – Nick.Mc Feb 03 '16 at 04:47
  • Hm. I suspected but couldn't quitr figure out how to use (or get to) localdb after I installed express. So wasn't sure. I'll check it out in more detail. Thanks – ptownbro Feb 04 '16 at 15:52

0 Answers0