Using Access Files

[dylcon]

Hello, I am currently working on a workbook that accepts various information from a user via a userform and adds it to an acces database. My problem is that I do not know how to get to this file with the connections. Currently, I have:

Please Login or Register  to view this content.

I am running this in Module1, but it either gives me an error or makes me run a different Macro. Any ideas what I should do?

[samsla]

MyConn = "C:\Inventory Records.mbd"
perhaps this .mbd needs to be changed to .mdb

Good luck

[patel45]

http://en.kioskea.net/faq/1668-vba-c...e-mdb-to-excel
http://www.exceltip.com/st/Import_da...Excel/428.html