July 28, 2014 at 11:39 am
For your connections to SQL Server, are you using passthrough queries to procedures, or are you using local views which call through the ODBC links to each table in the SQL Server? This is one of the most common pain points when upgrading from Jet to SQL Server as the storage engine.
Side Note: You REALLY want passthrough queries, even if you are just sending the T-SQL down.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 28, 2014 at 1:14 pm
Thanks Craig
We spent the day putting the client back to full Access, exactly where they were at midnight Saturday. So now I need to spend the rest of time trying to get to grips with a much better way to use SQL Server as a backend to my Access front end.
To answer your question - No! The Access FE was unchanged from when it had an Access Back End. No pass through queries, no views, no stored procedures, or anything apart from standard Access techniques, or so I thought.
I fear a big learning curve coming up but by putting the client back to where they were I have bought us a load of time!!
Cheers
Dave
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply