I have an access db with a form used for entering data. Is there a way a can setup a command button on the form so that when pressed it can execute a sql statement and then enter that information into a SQL server table?
Not sure what you are referring to. There is nothing setup right now.
I am creating an access db that is going to be available for download from my website. The users then can enter data into a form. When they click the submit button on the access form I want that data that they just entered to go into a SQL Server table that I setup.