I’m starting to plan placing my DB backend to a SQL sever like Microsoft SQL Express. A system I’m so not familiar with at all my DB is going to have growing pains here which I learning after the Access DB is build is done and being populate. Instead of stepped on mines with a program I never used, I sure can use some guidance
Our Access DB will house hundreds of applications. We have several types of widgets that our clients apply for and there’s several types of applications depending of the type of widget our clients are applying for. Each record in the database is a summary of an application with key information about the application. When a new app comes in, we can query their old records that will help us match the right widget to our clients. When the summary data is entered into a record, the application is scanned into .pdf format and attached to record. This way when someone query’s a name, all their older records are there for viewing.
When I move the beckend of my Access file to the SQL server, will the attached .pdf files be affected? If so how? Any other potential pitfalls I may run into?
Also, I'm open to recommended resources like books or Youtube videos you would recommend for a dummy like me on SQL Express or SQL in general. Thanx in advance!