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]

you should go for access projects when trying to connect too sql-server and not mdb's. then most problems will automatically disappear..

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]

Oh, look who drops in, spells too wrong, picks up won of the too votes for the day with only won post. Must have too accounts...won two post and the other two vote!
-Karl
P.S. we won't talk about my your & you're oversights.

[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]

at least I'm not trying to take sis her first place in this forum. And this is a public forum, so you should watch your manners.

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]

How could I possibly forget that it's a public forum...with all the rift-raft that comes and goes.
-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]

 

[dbomrrsm]

Best read aloud by an elderly mother.

Where sisters dwell and brothers meet. Quell should never come for birds in their little nest agree and it is a shameful sight when children of one family fall out and chide and fight.

[blue]DBomrrsm[/blue]

 

[donutman]

Double ouch! Misplaced periods, too.
-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]

 

[dbomrrsm]

Donutman

How do you know that chrissie1 is the other half of mcconnellj ?

[blue]DBomrrsm[/blue]

 

[donutman]

He and I are friends. We are only playing with one another. Hasn't that been clear in ALL of our posts?
-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]

 

[dbomrrsm]

Clear as mud !

[blue]DBomrrsm[/blue]

 

[donutman]

Guess you must be right, because the really funny (sarcastic) one was 86ed by the admin. Guess that's what's wrong with inside jokes...can easily be misconstrued by the outsiders.
Wow, I'm dumbfounded. The 86ed thread makes sense!
-Karl
P.S. Guess private forums make sense.

[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]

 

[donutman]

Thanks DBomrrsm. Sorry Christiaan. I misconstrued the manners replay as a quote (dig) from the 86ed thread. I obviously talk too much and think too little no matter which forum I'm in!
-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]

don't ever say we are friends again. that's insulting!!!

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]

Now, see, if you had added a cute animated smiley face to the end of that, even I could interpret it correctly, but without one I'm lost.
I guess the word for that is touché and apparently a much deserved one.
-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]

 

[dbomrrsm]

Donutman

The above quote was posted by yourself in a thread where me and r937 were not being too polite to each other.

[blue]DBomrrsm[/blue]

 

[donutman]

I know and the many mistakes in it didn't go unnoticed. OMG, another misunderstanding...I was poking fun at myself not you. Oh, of course you know that. OK, in case everyone doesn't already know...I'm the only idiot in this thread.
-Karl
Note to Admin: Put me out of my misery!

[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]

about the idiot thing, you're correct.

about my previous post

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]

Glad you cleared that up. Because I was wondering why you would say "...friends again" instead of just "...friends." I mean I knew we weren't friends anymore, but some time in the future we might become friends, so it wouldn't be right to say, "don't ever say we are friends again", because if we became friends again, then I wouldn't be allowed to say that we were...friends again. I feel so much better now that we're clear on this.
-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]

If only I understood what you were saying.



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]

Weekends @ Tek-Tips are pretty quiet.
Just trying to confuse DBomrrsm again while I jump from Bridge Baron, flash cards and TT.

-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]