I am not an MS Access expert, but perhaps you can set up a pass through query instead of trying to do it as a linked table.

The processing power of the CPU needs to be properly scaled to the size and speed of memory and I/O throughput capability of the disks and network. It is possible...

see if this will work for you:

select ImgGroup, [filename]

from Gallery G

JOIN (select ImgGroup, max(GalleryID) as ID from Gallery group by ImgGroup) Link

ON G.GalleryID = Link.ID

The GalleryID is identity in the...

Make sure you have created a database master key in the database. Whether you are using encryption or not that has to be created.

LOL for some reason I missed...

How long do your snapshots take? Apps need to be written in such a way as to be able to handle an occasional timeout no matter what is causing...

never heard of that except when used with UNION

Sir,

What you are asking is considerably beyond the framework of this forum. Your post is not alot different than this one:

"Our company is building a new N-tier order entry system....

if you restore a database you must reinitialize the mirroring. meaning you'll have to backup the database and restore it to the mirror. The replication can be re-initialized without...

select * from table1

where col1 in (select col1 from table2 where col2 = 123)

This is actually a correlated subquery and it works because col1 is valid column in table1....

rename the database.

that will work as well, just requires a little more TSQL than just restoring the service master key and certificate.

I am not understanding what you mean by the "computer account" you are referring to. Do you mean the Windows user account that the SQL Server service is running under?

My suggestion was assuming you can write a C# program to bulk insert the file into the stage table first.

It could determine the column order of the file then...

I would bulk insert this file into a stage table first then do the insert into the production table by specifying the column names in the order you want them...

Your company needs to hire good software engineer(s) who understand not only software but relational database architecture to design a good solution to this.

It would save them some time if...