Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   INFORMIX - MS ACCESS Connection Hi, using the following SQL-Commands I copy a informix table-structure and later very fast the table-rows to a MS-access DB: SELECT * INTO tab1 FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; INSERT INTO tab1 SELECT * FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; source: INFOMIX IDS Server 7.0 destination : MS Access 2000 ODBC-Driver : INTER... 2 14.07.2006 12:39:43 Access 2000/SQL Express: DAO or ADO? I'm developing an app with an Access 2000 front end and a SQL Express back end. I'm putting together a list of modifications to make to optimize the front end app. Right now, all of my code uses DAO. Would there be any benefit to re-writing the code to use ADO? I seem to remember coming across something that said DAO goes through Jet to get data from SQL server, whereas ADO doesn't.... 2 13.07.2006 19:49:42 Connecting to Orable DB with Microsoft ODBC Sorry for the cross post but I wasn't sure which group might be able to help. I'm having a problem with connecting to Oracle DB using MS Access. I setup a system DNS but when I try to connect, I get the below error: ODBC call failed. [Microsoft][ODBC driver for Oracle][Oracle]ORA-06401: NETCMN: invalid driver designator (#6401) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectA... 3 13.07.2006 14:52:58 Access 2k & SQL Ex 2005 I have an app built in Access 2k, and I'm looking in to putting the backend in SQL Express. Obviously, I'd like to take advantage of the upsizing wizard, but I can't get A2K to find the SQL Server that I have running. I've also tried creating a ODBC DSN and it won't find the server either. I know that the Server is up & running because I can see it & manipulate things in Management Stu... 9 11.07.2006 20:20:02 Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query work from Access 2k2 to Oracle 10g Express Edition? I'm experimenting using Access 2k2 as front-end to Oracle 10g Express Edition. I've tried a DSN connection, and it works. The problem is that ... 9 10.07.2006 05:32:09 Specified driver could not be loaded due to system error 999 (Microsoft Access Driver (*.mdb)) I got the following error everytime I try to connect to a SQL tables. Specified driver could not be loaded due to system error 999 (Microsoft Access Driver (*.mdb)) Any response is greatly appreciated. Thank you. ... 1 07.07.2006 16:41:34 Liste des noms des tables ? (name of all tables) Salut tout le monde, J'ai un petit problème... Je suis sur un programme qui se connecte via ODBC sur ACCESS. Je veux exécuter une requête qui me passe l'ensemble des noms des tables puis ensuite une qui me passe le nom des colonnes. Sous ACCESS, je peux faire : "SELECT [Name] FROM MSysObjects WHERE [Type] = 1 AND Flags = 0" et ça marche très bien. Par contre, via ODBC, j'obtiens le mes... 4 06.07.2006 06:53:34 Workaround sql query limitation from sql to Access backend on server Please bear with me on this, I am a neophyte in regard to the ODBC programming. We are running Access 2000 on a small LAN ,, we are in the process of developing a website to eventually conduct sales transactions... I developed the database and there is a website developer that is working on that end of the system. The issue that the website developer is running into is that there is an ... 1 05.07.2006 20:22:14 ODBC Error I'm currently trying to troubleshoot an issue on Windows XP where the user is trying to set up a DSN to SQL Server and is getting the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'sysdatabases', database 'master', owner 'dbo'. (#229). Now, the perplexing thing is that he does have access to some of the databases - I would think thos... 2 02.07.2006 03:00:04 ODBC via internet ? Hi everyone :) I have a Win2003 server and SQL Server 2000 running as database back end. On the clients at my work I have Access 2003 as a front end with tables linked via ODBC. I am still developing the frontend and sometimes I want to this at home. Currently I am exporting the SQL server data to an access mdb file and mail this to my home adress. With the The front end I do the same... 4 01.07.2006 07:55:20 making an .ADE file ??? Hi, I have a adp project in MS Access 2003. When I try to create an ADE , it tells me that MS ACCESS was unable to create an ADE database. Why would that be? I really need to create one. Any ideas? thanks, maggie ... 3 28.06.2006 21:25:02 .mdf files - hi, Its me again......with more questions. I was told to create an adp project from an mdb project, which I did and it seemed to work. It says it connects to a sql database ( has an .mdf extension). I made a backup from Access ( ..dat file ) and sent it to my DBA so she could put it on her server. She told me she cannot take it in this format - that it must be in a .BAK format. I cann... 2 28.06.2006 19:58:02 backup /restore mdf/ldf files hi, I have an Access adp project. The database is on my local drive. I am told that I need to back up this database ( a .bak copy ) and distribute this to users so they can use my adp project. I've got these problems: 1. When I open up SQL Server 2000, I dont see my databases. I am not sure how to get it in there so I can back it up! I tried one thing, but I ended up with just syste... 3 28.06.2006 15:49:01 CODESOFT with ACCESS Hello, I'm using ACCESS 200 VBA code to print labels based on a ORACLE data. I wanted to choose automatically a printer and it works with this code : New_printer = OLE_Server.ActiveDocument.printer.SwitchTo(ImprimanteNom, "IP_43.198.132.52", False) but I have to choose also the tray of the printer automatically. someone's got an idea ? Thanks a lot. ... 1 26.06.2006 13:33:31 Access MySQL, ODBC and DSN-less connections: Error 3170 Hi, I'm trying to use MySQL as a remote back-end with an Access front-end shared by multiple users. Both the database and the Access file are located on the same server on a LAN. Users are on this LAN too. After reading several articles on the subject, it appeared that DSN-less connection was the best choice. I copied a piece of code by Doug Steele (http://www.accessmvp.com/djs... 4 26.06.2006 11:29:27 Syntax is for adding records to a recordset? Can anyone tell me what the syntax is for adding records to a recordset? I think the rest of the procedure below works OK, this is the part I'm not finding how to do: While Not rsPrefill.EOF 'Step through the extracted records, rec.Open rsPrefill 'Get the record into a variable??? rsNew.AddNew rec 'Add it to the second recordset??? How to do this!? ... 2 24.06.2006 07:29:02 SQL SERVER EXPRESS Hi I upgraded an access database to a SQL Server 2005 express backend. The database is quite small (7k records max) and has about 8 users. The upgrade was reasonably smooth and most of the time the system runs perfectly. However at random intervals the system slows to an appalling crawl for up to twenty minutes. The server is running sbs2003 and none of the other services are affect... 2 19.06.2006 14:01:01 Linking ADP to an MDB Is it possible to link an Access Project with MS SQL 2000 backend to an MDB file and therby pull data from both sources. Each time I try I am given a message that says I can only do this in SQL Server Version 7 or higher. ... 2 19.06.2006 00:32:45 New upsizing tool New Access to SQL upszing tool is avilable on http://www.microsoft.com/sql/solutions/migration/default.mspx It is currently in beta phase. You are welcome to give it a try and to send your questions\feedback to accssma@microsoft.com Thanks, Gil ... 1 18.06.2006 21:22:12 ODBC Access without smb Hye ! I'm setting up an ODBC source, and I wondered if it is possible to connect to a database that is on another computer of the network without passing through http, ftp or smb ? Thanks for youre replies, and sorry for my english. ... 2 15.06.2006 23:20:28 ODBC driver for Access on Windows Server 2003 Where may I get the ODBC driver for MS Access on Windows Server 2003? I'm setting up the server to server ASP web form that will be writing to a Microsoft Access database. When I attempted to set up the System DSN, SQL Server was the only choice. Thank you. ... 12 15.06.2006 13:50:50 Null Value error with no Null value I have the following MS Access 2000 query: INSERT INTO tbl_CLIENT ( CONSUMER_UUID, CLIENT_ID, CREATE_DATETIME, CREATE_USER, LUPDATE_DATETIME, LUPDATE_USER, FIRST_NAME, LAST_NAME, FULL_NAME, SSN, INFO_RELEASE_AUTHORIZED ) SELECT LCAClient_tblGroupedClients.Consumer_UUID, LCAClient_tblGroupedClients.SamsID AS CLient_ID, IIf([InputDate] Is Null,Format(Now(),"Short Date"),Format([InputDate... 4 06.06.2006 17:59:25 ODBC call failed - invalid argument (#0) I have an update query: UPDATE DISTINCTROW (ClientNotExistWork LEFT JOIN LCAClient_TblGroupedClients ON ClientNotExistWork.LcaId = LCAClient_TblGroupedClients.ID) RIGHT JOIN WellnessClientStartDates ON ClientNotExistWork.ClientId = WellnessClientStartDates.ClientID SET LCAClient_TblGroupedClients.[Well ID] = WellnessClientStartDates!ClientID, LCAClient_TblGroupedClients.[Well StartDat... 3 06.06.2006 12:07:34 Relationships gone after upsizing I just upsized my Access 2003 mdb to use SQL linked server tables. Most things are working fine, with some minor code adjustments. I did notice however that all my relationships are gone. Do I need to re-establish them? Or is not necessary anymore?... 2 29.05.2006 08:26:09 Help with optimization tips for a future white paper Hi all, As part of the SQL Server Migration Assistant for Access(SSMA Access)we would like to publish a technical white paper on technical issues and their resolution when working with Access UI against SQL Server. The scenario is as follow : The user had an Access application working against Jet storage. The data and schema were upsized to SQL Server (with SSMA) and the tables were linke... 3 27.05.2006 16:58:47 9 Pages: 1  2  3  4  5  6  7  8  9