Duane,
That
was one sweet tutorial. Smooth as silk. You know it's good when it
works on the first pass.
Thanks again.
Far
-----Original Message-----Yo, Far,
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Duane Hennessy
Sent: Friday, January 13, 2006 5:04 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Re: Connecting Access to SqlServer
I've uploaded a file on how to create a SQL Server ODBC connection and link an Access database to it.
Actually, I'll send it to you because I'm copping technical issues uploading for whatever reason.
Some advice regarding the Text field. Because a Memo field can hold up to 2 GIG of data some users have a tendency to cut and paste vaste swathes of data into these fields, like entire Word Documents etc. What I would recommend instead is a varchar field with maybe 3000 to 8000 characters. If users' need more than that then they should be using a document management system of some kind.
Anyhoo, hope my document helps.
Bueno suerte!
Duane Hennessy
Bandicoot Software
Tropical Queensland, Australia
(ABN: 33 682 969 957)
Your own personal library of code snippets.
http://www.bandicootsoftware.com.au
--- In AccessDevelopers@yahoogroups.com, "The Professional Network" <[EMAIL PROTECTED]> wrote:
>
>
> I am doing my first connection from Access to SqlServer
>
> I would like to set up the Access tables so that they are linked to the
> SqlServer tables. I want to use an Access mdb, not an Access Data Project.
>
> One of the fields in SqlServer is shown as <Long Text>. I want this to go
> to an Access Memo field.
>
> I think I want to link using ODBC. However, my reference books suggest I
> have options with ODBCDirect (the old RDO), DAO/ADO, or OLE DB. This leads
> to two questions:
>
> Which method should I use (and why)?
>
> How would I set up the links using that method?
>
> TIA,
>
> Far Farley
>
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
