Hi,
I am working on a table that has millions of records located on SQL Server unfortunately the table is dropped and remade everyday so they don't index this table.
It takes a while to query this table because it is not index. It contains appointment information from all departments of course we only care about our department.
So when we run a query from our Access DB (Using Passthrough) it still takes couple of minutes or so to pull our 23,000 odd Appointments.
Running a Make Table query on that Passthrough query is easy, but still takes time.
Is there anyway we can ask SQL Server to make a new table on our Backend Access DB??
I have a feeling it will be able to make that table almost instantly...
Something like
I am working on a table that has millions of records located on SQL Server unfortunately the table is dropped and remade everyday so they don't index this table.
It takes a while to query this table because it is not index. It contains appointment information from all departments of course we only care about our department.
So when we run a query from our Access DB (Using Passthrough) it still takes couple of minutes or so to pull our 23,000 odd Appointments.
Running a Make Table query on that Passthrough query is easy, but still takes time.
Is there anyway we can ask SQL Server to make a new table on our Backend Access DB??
I have a feeling it will be able to make that table almost instantly...
Something like
Code:
SELECT * INTO [Local Past Appointments] IN '\\New-Storage\NewDB\Backend\Data\Backend -DO NOT DELETE-.mdb' FROM dbo.OPA AS A WHERE (([ApptDate] <= '2014-14-8') AND ([Appt_Res] Not Like '%AntiLiner%') AND (([Appt_Slot_Type] Like '%Liner%' OR ([Appt_Type] Like '%Liner%')))) ORDER BY A.ApptDate DESC;
Comment