Using Access as Backend and Excel as Frontend

[dpsciarrino]

I am making an inventory system for a consultant who buys products and sells them at vendor shows. I have a simple table in Access that holds the quantity of each item the consultant has. I would like to be able to use Excel as a front-end interface for manipulating this data (through userforms). How might I be able to accomplish this? Keep in mind I'm fairly new to Access.

Since this covers 2 topics I am cross-posting in the Access forum:

http://www.mrexcel.com/forum/microsoft-access/739832-using-access-backend-excel-frontend.html

 

[shg]

Duplicate post.

 

[dpsciarrino]

Pretty sure I'm following forum rules. #24:

http://www.mrexcel.com/forum/excel-questions/127080-guidelines-posting-updated-22-nov-2006-a.html

 

[shg]

How about #23?

 

[dpsciarrino]

Apologies, how do I delete my other post?