SQL Server
(1)
LisaI
(1)
Database
(1)
E5008e6123d0
(1)
Psuedocode
(1)
Inmemory
(1)
C924e9aa
(1)
DSN
(1)
How to Link to Sql 2008 Table from Access Database
Asked By Lisa Tortorelli
13-Oct-09 04:08 PM
How do I Link to Sql 2008 Table from Access Database? I need to send a file from Access into Sql Table so I can write directly to it.
thanx.
EggHeadCafe - Software Developer Portal of Choice
In-Memory Data Caching for Performance
http://www.eggheadcafe.com/tutorials/aspnet/c924e9aa-9085-41b3-9821-e5008e6123d0/inmemory-data-caching-fo.aspx
LisaI am not aware of a "send a file" function in Access.
Jeff Boyce replied to Lisa Tortorelli
13-Oct-09 06:12 PM
Lisa
I am not aware of a "send a file" function in Access. Are you saying that
you have data in an Access table you want to have in a SQL-Server table?
Which version of Access are you using?
Have you created a DSN (data source name) to manage the connection between
Access and SQLServer?
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
DataBase Connecting to SQL Server I connect my Access database to a SQL Server in two different ways: 1 with ADO such as: Dim theConnectionString theConnectionString = Driver = SQL Server; Server = Server \ TRUTIMEV3;Database = Intelligent;User ID = xxx;Password = xxx; Dim rec
DataBase Sql Server and Un-Bound Forms I am very new to SQL Server. Sql server 2005 and Access 2003. I would like to use a view as a recordsource for a un-bound subform. The database will contain no linked tables. The subform does not have strRecordset As String cn.Open "Provider = SQLOLEDB;data Source = DATACORP-SERVER;Initial Catalog = MySQLServer;User Id = sa;Password = sa" 'Choice returns to coerece the cursor to client-side static cursor. With SQL Server, you can use server-side dynamic, if I remember
DataBase SQL Server Hall?schen, ich habe mit einem SQL Server noch nie was am Hut gehabt. Alles was ich bisher Nun aber ist eine Anforderung, das ein Backend auf einem SQL-Server laufen soll, wobei dar?ber noch nicht fertig diskutiert ist da noch eine alte Vollversion von VB6, dort ist ein SQL-Server dabei (fracht mich aber nicht welche Version, der Karton mit km von hier entfernt). Oder ist es sinnvoller den Microsoft SQL Server 2008 Express zu nehmen? Zumal ich in Zukunft auch
DataBase SQL Server Sort Order for Business Portal Hi all, Our existing SQL Server database for GP uses a Binary sort order. We are trying the install instructions says it can only be installed on SQL Server with sort order 52 (Dictionary Order, Case Insensitive). If we create a new SQL Server instance using sort order 52 for Business Portal, are there
DataBase Upgrade DB version from SQL Server 2000 to SQL Server 2005 Hi, I have a deployment with GP 9.0 SP3 with SQL Server 2000. I want to upgrade de Database engine to SQL Server 2005 in order to use SQL Server Analysis Services, SQL
DataBase SQL Server 2008 R2 Express Database Size Limit Increased to 10GB SQL Server 2008 R2 Express Database Size Limit Increased to 10GB Great news for SQL Server Express users today! We increased the maximum database size in SQL Server 2008 R2 Express from 4GB to
DataBase how can import sql server 2005 database to visio 2007 I want to reverse ingeneer an sql server database 2005 by using visio, I receive this message error: SQL server does not exist or connection dinied. keywords: how, can, import sql, server, 2005, database, to, visio, 2007 description: I want to
DataBase SQL Server SQL to Access 2003 The following query is for SQL Server. How to convert this to Access 2003 SQL? SELECT Organization.Name, Organization.Id AS OrganizationID, Item.Id as AL.ID = Q.T2Id mfG - -> stefan <- - It works. . . . Thanks. keywords: SQL, Server, SQL, to, Access, 2003 description: The following query is for SQL