Moving from Access to SQL db
Posted on 2008-09-30
I have a program that users do plain data entry into, and the data is stored in an Access database. I am going to redesign the program to store the data in SQL server. After the data has been entered, the next day a user double clicks on a batch file that opens access and runs a macro that prints the data from a report that was created in access. I want the users to able to enter the data into the program the same way (I can handle that) and the other user to click on a batch file or somthing similar to what they have now that will generate documents for them to print. Basicly I need help with creating, and automating the reports from the data in SQL Server. I hope that makes sense. If you can point me in the right direction I would appreciate it.