You would need the x64 driver for Access - which isn't available with Access 97.  I am not even sure how you are using Access 97 on a Windows 10...

If you put that data into a recordset object in SSIS - you can then use that object in a foreach loop to insert into the table.  You still have...

If your query is attempting to query the data that is being deleted - that query will be blocked until the delete has completed and of course it will have...

My concern isn't the advice to switch - it is that some believe that is the accepted method without understanding the risks.

As long as you have an unbroken log chain...

Just to be clear, the reason I suggested going to the SIMPLE Recovery Model in my example was to, in fact, break the Log File chain in an attempt...

When you use DBCC LOGINFO - how many VLF's are showing and what is the size of each VLF?  What do you have defined as the autogrowth setting for the...

Couldn't say for sure - but I have seen issues where it doesn't seem to work when you have the time zones switched.  And it definitely appears to not work...

Do you have RCSI enabled on that database?  Or is the query using snapshot isolation?

Can you provide examples of the data you have - and the expected value after converting?  My guess is that you have string data that you are converting to a...

Sorry - but no idea on why the SSIS package is no longer logging.  There could be many reasons - but I would start with the config file to see...

You cannot relocate the mdf/ldf files to a shared folder - nor would you want to do that.  The database files need to exist on non-shared storage for an availability...

Ok, I got you.

I got it to work using the "Join Only" option, but I'm still wondering why I can't use a shared folder?  If I were to create...

Well - you obviously have access to both instances.  Is that access from the same workstation - or do you need to access the other instance through a different method?

Assuming...

Is the stored procedure in the same database - and is the manual execution in the same database?

You didn't share all of the relevant code.  I don't see how you...

I agree 100% but sometimes you are coding for databases you didn't create.  I use SQL Prompt but I believe the built-in Intellisense will also change the color of...