I have an MSAccess database that is queried using the standard set of forms, queries, macros and reports. I am going to move the main table to SQL and access the database with ASP pages as these functions are going to be integrated into a website. I do however have a handful of individuals that will continue to update manually (much like an excel spreadsheet) the main table. I don't want to load SQL on their desktops and would much rather let them update the SQL table from the MSAccess application. Is that possible? What settings need to be made on the SQL table or MSAccess database?
Thank you,
Chad
Thank you,
Chad