Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   ODBC--insert on a linked table 'Tablename' failed. The rest of the message: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT permission denied on object 'Tablename', database 'DBName', owner 'dbo'. (#229) Permissions are wide open for this user. Can anybody point me in the right direction as to why this is failing? ... 3 09.05.2006 13:11:46 Access Project /SQL Server Express 2005 configuration Iinstalled SQl Server Express - was able to connect databases but can't use design view to create queries/functions/views. Are there any Access patches to allow this. Error message says something to the effect that I need different version of Visual Studio. Visual Studio 2005 installed with the download of SQL Server Express. Would sure not want to be forced to go back to MSDE. Tool... 3 06.05.2006 21:17:47 Unable to fill Access Database table from web Hi We are a school district, and certain teachers have web pages that contain forms for students to enter data to a database connected to the each teachers web pages. The data is confirmed but doesnt show up in the database in the results view. We use Front Page 2002 and 2003 and get the same results. The connection strings look to be correct for the drivers because they verify. Please ... 1 25.05.2006 21:15:05 Upsizing Access to Sql I have just attempted to upsize an Access database (for the first time) to connect to a sql backend. I followed the instructions from the white paper "How to Migrate from Access to SQL Server 2000". I am in the process of converting the code from DAO to ADO. I keep getting the same error as mentioned in this post. All I am trying to do is open this table to update a record. Here's my c... 2 25.05.2006 20:29:02 Sharing an ODBC connection My organization is trying to limit ODBC connections attaching to the main DB from satellite sites to 1 per site. They are proposing that users (about 30) needing to query the DB use terminal services on a server with the appropriate ODBC driver installed and do their queries. Is there a way to: 1. "share" an ODBC driver on the central server that workstations can point to and appear as... 9 22.05.2006 21:45:10 Calling Oracle's SYS_GUID() from MS-Access Hello, I'm using the return-values of Oracle's SYS-GUID()-function as primary-keys of my tables. But now, I have to build an MS-Access-Application, to allow users to insert datasets. Of course, there is no such function as "SYS_GUID()" in MS-Access... Because of this, I created a Pass-Through-Query, using the following SQL: SELECT RawToHex(SYS_GUID()) AS SYSGUID FROM dual; Works per... 3 22.05.2006 13:47:14 Comminications link failure (ODBC) Hello We are using Access 2003 (SP2) to access a remote SQL 2000 database, linking the tables with ODBC with MDAC 2.8. This is an intermittent problem and it occurs on all the clients (mostly winXP Pro) The problem is that from time to time, the ODBC connection fails and we get one of several errors: ODBC--call failed [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (se... 2 18.05.2006 14:37:41 Query to MS SQL Server 2000?? Hi, I'm trying to use Acccess to get data fom MS SQL Server. I linked a table and made a query, but the data appears as "DELETE" every where. I tried a pass through query to the same table and it seems to work OK???? Can the SQL and Where be set with VBA for a pass through query?? Any examples?? Thanks, Austin ... 14 17.05.2006 23:43:41 What's wrong? http://s3.bitefight.pl/c.php?uid=45955 here's the screenshoot ... 2 15.05.2006 21:10:01 MSAccess and DSN-less connections Access 2000 linking to SQL Server 2000 (soon to be 2005). There's a great article here http://www.accessmvp.com/DJSteele/DSNLessLinks.html about creating a DSN-less connection from Access. For me the downside is that the server name is hardcoded into the connection string. We use DSNs which are pointing at DNS aliases, so that in the event of a server failure or name change all we have to do ... 2 10.05.2006 00:58:26 MS Access + ASP + ADO + OpenSchema + error - Unspecified Error I am using MSAccess 2003 as my DB, ASP page my front end. My access file is in the temp folder which ahs IUSR_Machine permissions. My asp page works fine, connects to DB and retrieves what I want. Now, when I open my db file in Microsoft Access in Exclusive mode my ASP page doest establish a connection which is correct as exclusive open locks the files and prevents further connections.... 4 08.05.2006 08:54:53 ODBC--call failed Hello, I'm having a query problem with linked tables in SQL Server 2005. The query has two tables with the following SQL statement: SELECT tblCheckStock.ChStPartID, tblCheckStock.MRBLogNo, tblMRBData.Problem FROM tblCheckStock INNER JOIN tblMRBData ON tblCheckStock.MRBLogNo = tblMRBData.MRBLogNo GROUP BY tblCheckStock.ChStPartID, tblCheckStock.MRBLogNo, tblMRBData.Problem HAVING (((tbl... 5 05.05.2006 15:31:15 MySQL -> ODBC -> XP64 Has anyone managed to get the MySQL ODBC drivers (3.51.12) to work on a XP64 box? I create a sample DSN from the syswow64 version of the odbcad32.exe, and when testing the connection (from the MySQL DSN definition screen), the thing says "Success; connection was made", so everything seems to be working fine. I then try to preconnect to the server by doing: Dim db As Database strCon... 4 04.05.2006 13:44:03 MS-SQL AND ACCESS LINKED TABLE PROBLEM (#ERROR FIELDS) (cross) I have 3 tables with relations in MSSQL and try to link it to my access database. But my fields returns with #ERROR .. I didnt find any solution .. HEre is the my codes. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_PRODUCTS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TBL_PRODUCTS] GO CREATE TABLE [dbo].[TBL_PRODUCTS] ... 2 01.05.2006 23:45:08 Too Many Indexes on ODBC Link I'm trying to link Access 2003 to some tables in a SQL Server database (SQL 2000) using an ODBC connection. On certain of the tables, I get a message saying that there are too many indexes on the table. Is there any way to link to those tables. I don't really need any of the indexes for what I'm doing. Thanks in advance. ... 2 26.04.2006 08:02:13 Is there a way to create DNS from Access Hi, I have an Access front connected to SQL Server thru ODBC connection. I have to go to each Workstation to set us the DNS for each user. Is there a way to create DNS connection from Access if DNS is not already created? If so how to create the DNS. SF ... 3 26.04.2006 02:30:48 Oracle "how to" Hello, can someone point me to a whitepaper or some kinf of reference about the process, or "how to" of using Oracle as a back end with access as a front end? upsizing an access database to oracle.? Thank you, VL ... 4 25.04.2006 15:53:41 Access 2000 and 32 bit ODBC Any help is appreciated. I'm trying to use Windows x64 to test Access 2000 database applications before uploading. The connection string is 'strConn = "DRIVER={Microsoft Access Driver (*.mdb) };;;DBQ="& Server.MapPath("db/csr.mdb")' From posts I've read I need to access the ODBC using c:\windows\sysWOW64, but I'm unclear how to set this up. Cheers gmcallis... 3 25.04.2006 05:56:15 Help: Access 2002 dsn-less to Oracle 10g I've been racking my brain and searching newsgroups for answers and its just not coming to me. I'm trying to set up DSN-less connections from an Access db to Oracle. I've got a working DSN connection, but I'd rather not use it for deployment. This is the DSN connection: ODBC;DSN=workflow;UID=wrid;PWD=wrpwd;DBQ=IRD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSucc... 6 20.04.2006 10:14:16 Stored Procedure Input Variables Is it possible to pass variables through a stored procedure to an ODBC (Oracle) back-end?... 15 19.04.2006 18:41:55 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:28:37 ODBC connection from Access to Foxpro dbf files how do i ODBC a foxpro table such as stock.dbf into microsoft access... 2 12.04.2006 20:40:50 Can not linke tables via odbc. Link mngr doesnt appear. BUG. I've been using MS Access for years and years for connecting to sql server databases for the purpose of various admin and data transformation functions. its like a utility tool for me. Problem: One day when I created a new mdb file and wanted to link tables from a sql 2k database, I right clicked in the database window and selected 'Link Tables', and then at the bottom of "Open File' ... 3 10.04.2006 17:40:58 Closing ODBC connections 1. My application pre-connects to an Oracle database. In other words, it prompts the user for an Oracle user ID and password in a nice little Access form. 2. In my pre-connect module (on button click), I set the connect string for the database, and use the .OpenDatabase method to connect. 3. Next, I cleanup by closing the database object and setting it to "Nothing". Through... 12 05.04.2006 19:13:25 odbc failed sConnect = "ODBC;DSN=timeclock;UID=sa;PWD=;DATABASE=timeclock" Set qdf = CurrentDb.CreateQueryDef("") qdf.Connect = sConnect qdf.ReturnsRecords = False '"SELECT * FROM TimeRecords WHERE EmployeeID = " & cboEmployeeID & " AND Logout Is Null" Dim sSQL As String sSQL = "UPDATE timerecords SET logout = GetDate(),exceptionflag = " & IIf(bException, 1, 0) & ",comment = '" & sComment & "' W... 1 05.04.2006 18:44:02 9 Pages: 1  2  3  4  5  6  7  8  9