Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Can I use Advance Jet SQL commands in odbc Hi! I have an application using ODBC (MFC classes) to access a Jet database. Now while browsing MSDN I found an article: "Advance Microsoft Jet SQL for Access 2000" that explain the new transaction commands:"BEGIN TRANSACTION", "COMMIT", "ROLLBACK" which allow up to 5 nested transactions, VIEWS, PROCEDURES (SQL-92), etc... For some problems we have, nested transaction would fit the bill per... 2 27.01.2006 06:54:21 How to prevent multiple connections when using linked tables to SQL server Hello, I have a VB app that tries to read/write data from an access 2002 DB that has linked tables to a SQL server. My problem is that my read after the begintrans creates a new connection (SPID) in SQL server therefore causes an update on an already locked record. How can I make sure that all my reads and writes are done in the same connection? Thanks ertan Zanagar l_objDBCo... 8 28.01.2006 10:12:34 building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 27.01.2006 01:23:39 EOF or BOF Error in access (back end is on SQL server) Used a database without anyproblems. But when Database Backend was migrated to SQL 2000, then everytime I try to append records or insert records ot a table, I get this error. ANy idea how ot get a permenant solution. All help appreciated (See Below) sorry for the lengthy code: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++ Private Sub cmdCreate_Cl... 2 25.01.2006 21:33:03 Writing binary ('blob') data to Access with ODBC Hi all - I'm having some trouble writing long binary data ('blob') to Access using ODBC. SQLBindParameter is reporting an "Invalid precision value" between preparing the Insert and Executing it. Hopefully someone can help? My code works with ODBC -> MySQL. I'm using a binary test field of length 262143 bytes. The field in question is defined as 'longbinary' in the CREATE TABLE t... 3 25.01.2006 16:11:28 How to disable use of Access databases on IIS 4.0 Hello, We host multiple sites on an NT 4.0/IIS 4.0 server. However, standards dictate that Access databases are not allowed. Can anyone advise on a method to disallow/disable the use of Access databases on a web server or from websites? All the access database files are local on the server. We have tried unregistering msjet35.dll and msjet40.dll w/o success. We have set NTFS perm... 6 23.01.2006 17:53:03 Access lookups taking forever.... We have 10 users using access XP 2002, all are connecting to an access database with about 300,000 records (150meg DB). and currently it is taking about 6-8 minutes per lookup on the database which resides on a windows 2003 server with 2 gigs of Ram. Is this normal or is there something I can do to speed the lookups? My systems are running windows XP SP2 with at least 512 megs ram with m... 4 22.01.2006 18:40:36 AccessXP SQL2000 File dsn connection Have sql 2000 backend on 2003 server, using AccessXP as front-end. Have the AccessXP and file dsn in same folder on a Novell network share. SQL server is set to mixed mode. Have a file dsn: [ODBC] DRIVER=SQL Server UID=DBUpdater Address=198.99.9.99 DATABASE=telehealth PWD=password SERVER=servername Description=telehealthSQL I am a network administrator. While developing and using ... 2 22.01.2006 17:26:43 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 16:13:29 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 16:13:24 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 15:35:11 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 15:35:03 Cannot Link to ODBC Database Because Dialogue Disappears I'm having the same problem experienced by someone in July 2005, which he stated as follows: In Access 2003, I am trying to link a table to an ODBC data source. I click: "New" "Link Table" In the Files of Type dropdown, I select "ODBC Databases()." At that point, the dialogue simply disappears and leaves me at the previous window. A response was as follows: Have ... 3 19.01.2006 16:47:04 Windev *.fic I have a client who uses the French La Poste service for parcels, this uses a program written using Windev with *.fic tables. I have written a sales/stock control program which requires entry of customer names and addresses. It would be far more efficient if addresses were only entered once. Does anyone know of an ODBC or other means of accessing these *.fic tables. I haven't post... 10 18.01.2006 11:31:43 Free mp3's <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>And much more that that!</P> <P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P> <P>This site offers free and legal mp3's, software, movies, games.<BR>They also have a l... 1 18.01.2006 05:03:33 Free access to several paysites! Free movies - games - software - mp3 - and more! <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>I found this great site that offers loads of content for free! I got a bunch of mp3's from it, but they offer movies, games and software too!</P> <P>Go check it out! Quickly!</P> <P><A href="http://w... 1 17.01.2006 22:41:13 Visualise locked records per ODBC linkes tables Hi, I am the first time in this group, my englisg is not perfect ... I work with an Access MDB included tables via ODBC from a SQL Server 2000. When 2 or more users try to edit the same record, there is no information, that another user ia already editing this record (only on recordsaving there is an error message). Working only with a MDB, Access shows visual, that another user has loc... 1 13.01.2006 09:54:02 Unable to Configure ODBC Drivers I am using Works 2000. For the last 6 months I have been unable to access my Calendar for important birthdays etc. I uninstalled the program, leaving the calendar file alone. Upon reinstalling, I get five error messages. "Unable to configure ODBC Driver..Microsoft Access Driver (*.mdb)" -could not load setup or translator library The other four drivers that couldn't be configured are, ... 1 13.01.2006 01:14:02 MS Access ODBC across domains We've recently had a reshuffle of departments. The SQL databases that access connected to are now on a separate domain from the access users. Looking for ideas on how to configure the ODBC's to connect to SQL. The security folks don't want to use SQL users b/c the passwords are sent in clear text which is a security risk. Since this is the easiest option, I'd be happy to hear how they a... 1 12.01.2006 20:07:42 Best way to duplicate row of table Hello group, I'm trying to create a copy of a record in an SQL Server table that has an Identity key and string index based on a field, [ID]. I's using DAO and the code curretly looks something like this: strSQL = "SELECT * FROM tblX WHERE tblX.ID = '" & myID & "'" Set RSource = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges, dbOptimistic) Set RDest = RSource.Clone ... 2 11.01.2006 23:34:27 Access ODBC HELP! So I'm under the gun here at work and I can't seem to understand the cause of my problem. Here it is: I'm creating a SQL Server database using a web front end. In other words, users submit information via an Active Server Page and it is stored in an SQL DB. Internally, we are using Microsoft Access to query this information, add notes, and run reports. My issue is that it seems as thou... 2 11.01.2006 09:18:05 SQL server fields won't update from Access! Hi folks, a quick one and any suggestions would be welcome we have a form with a subform both using Access queries looking at SQL server linked tables. The query is definitely updatable (as the tables have unique indexes) and the query that is the recordsource of the form can definitely be updated when opened and put into datasheet view The subform has a checkbox (bound to the server... 1 10.01.2006 17:29:01 Error Code Zero I have a Java program that uses the JDBC:ODBC bridge to the MS Access 2000 ODBC driver. The program has worked successfully for months. The only aspect that has changed is that the database now has about 100,000 records. Suddenly, the program is getting the following error continually: SQL: SELECT * FROM SetiLog2 WHERE Computer = 'Harry' AND Name = '16mr05aa.15136.17264.40912.1.167'; ... 1 10.01.2006 13:37:38 ODBC Connection fails on XPpro but works on WIN2K and WinXP home I have a front-end MSAccess database on my local PC, and a back-end mysql database on a remote linux server which holds the data. I have installed and configured the ODBC driver on computers running Windows 2000 and Windows XP home edition (using ODBC driver 3.51.11.2-win) and I can get the database to work, i.e. double click on the access database and it launches, connecting to the ba... 2 09.01.2006 14:51:12 Record Locks In SQL Hi I have an access application with backend in SQL Server. It works fine on the test environment however on the production server on one Table after adding a record the record is somehow locked and any attempt to edit it by anyone results in the "Record has been change by another user since you started editing...." This occurs even when the original user attempts to edit this field.... 2 06.01.2006 10:51:43 9 Pages: 1  2  3  4  5  6  7  8  9