SQL Server with Access Frontend 2

[mcconnellj]

I'm attempting to make SQL Server transparent from a particular user's perspective. The user is very comfortable with MS Access. I have not done much using Access as a frontend to SQL Server, except linked tables through an ODBC connection.

What are the basic steps/commands to allow update/make table/delete queries to work on SQL Server tables and passing parameter values from Access to SQL Server?

Thanks everyone; you "guys" are great.

 

[chrissie1]

Perhaps you could join the history forum by djimandja. It's a private forum. So you could give us some first hand experience about the first world war. or the middle ages. ;-). If only I could remember all those smilley symbols.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[donutman]

But I'm not middle-aged anymore.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[chrissie1]

That depends on how old you want to become. Let's say you are a child the first 20 years of your life and old the last 20 and middle-aged somewhere in between. And you want to be 80 one day then you are middlde-aged. Technically speaking. But I agree with you, you look a lot older then 80.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[donutman]

http://setiathome2.ssl.berkeley.edu/fcgi-bin/fcgi?cmd=view_feedback&id=34921

http://www.tipmaster.com/includes/smileys.cfm?w=350&h=450

-Karl


[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[chrissie1]

I just wished I hadn't clicked on your picture. That wasn't a pretty sight.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[donutman]

What do you want...the donuts take a toll. Besides, not everyone looks like Brad Pitt, but when I had shoulder length hair people said I looked like Liam Neeson. The truth is that I look like the guy who played in Accidental Tourist, Bill Pullman.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]