Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Lapptop local solution Hi everyone :) At our office I have Access 2003 as front end and SQL Server 2000 as back end via ODBC. The front end has a lot of functionality and one of them is to maintain/view adresses from customers. What I want is the create a very basic front end for Access that has the only task to view these adresses. This little front end is going to be used on the laptops of several salesm... 3 29.09.2006 12:20:15 Querry time on upsized SQL Server Database Hi All, Just wanted to share a problem I had to solve recently. Access 2000 database that had the backend upsized to SQL Server 2000. A query that was looking for a specified time in a date time field with the parameter [TranTime] = #06/06/2006# This query found the time correctly in access but would return nothing after conversion to SQL Server. The solution: change the par... 1 29.09.2006 04:25:50 Record locking SQL BE Access FE I have an Access database front end which is linked to a Sql Server back end which contains all the tables. In the Advanced Options, I set the Default Record Locking to Edited Record. On the Form I set the Record Locks property to Edited Record. However, multiple users can still open up the form with the same record on it and edit it simultaneously. How can I stop multiple users from... 2 27.09.2006 15:15:49 Perfomance problem Hi everyone ! I am using Access 2003 as front end and SQL Server 2000 as back end via ODBC. Currently I am using a main table with 3000 records and 2 linked tables (one with 2000 records and one with only 10). I created a query for the main table where I sort the data on two different fields and I use this query as the record source for a form. The fields from the linked tables I look ... 13 26.09.2006 07:47:32 connect to SQL-server..? Hi all, I would like to connect to a SQL-server and promt the user with password and username. Can I use something like?: Dim oConn As Object Set oConn=?? oConn.Properties("Prompt") = adPromptAlways oConn.Open "Driver={SQL Server};" & _ "Server=MyServer;" & _ "DataBase=MyDb" End Sub .... what do I have to do? /Kent J. ... 8 25.09.2006 09:01:38 Flushing the JET - OLEDB In one of my apps i use an access database via OLEDB and that goes well at many customers sites but not on one. There the problem is that sometmes added rows disapear after closing the programm and restarting. The jet file is on the network, the app too and there is only one user. And ofcourse the problem cannot be reproduced. I have told them to update the Jet and MDAC drivers and the N... 8 22.09.2006 11:44:30 MS Access : cannot join on Memo,OLE,od Hyperlink object I have a MS Access Db,which I migrated to Oracle.I created linking with oracle tables in my Access db.Both MS Access and Oracle db have unicode characters. I need to test whether the data is same in both databases. I'm using Access db and linked tables of Oracle.I perform join on the tables to get records. When I run the query on Access db to compare,I get the following error "cannot j... 1 22.09.2006 08:29:38 Occasional Locking problem on sql tables linked from access with o I use a form linked to an sql view of a master detail relationship. The form is snapshot and uses access form filter to locate records. When the records are retrieved we go to another form with a master detail design where we can update the record. That is where we get an ODBC error indicating that the record is locked. I used your advice on timestamp and non null boolean fields... 1 21.09.2006 21:31:02 Poor Performance with ODBC link to SQL Hi, I have an Access 2003 .mdb/.mde that queries linked tables from a SQL db in order to provide Access reports to the user. It also combines with the SQL queries, data from a few very small tables within the Access db. On most systems/servers/networks, this app works well. But there are two systems/networks (one running Server 2003 and another running Windows 2000) where the que... 8 19.09.2006 00:10:31 Access 2003 and SQL Server 2005 using ADO and ODBC I have read about many issues with ADP and SQL Server 2005, has anyone experienced any issues with developing the front end of an application in Access 2003 and connecting to the SQL Server (2005) for tables and queries using ADO and ODBC? ... 2 18.09.2006 22:16:19 " problem I export an access table using Oracle ODBC driver to Oracle schema, it add character " to table name and all its column names like this "ff_to_oracle" ( ID VARCHAR2(20), "empid" VARCHAR2(20), "empname" VARCHAR2(50), "empdept" VARCHAR2(20), "create_date" DATE ) and when I want to query the imported table in Oracle I have to say: select * from... 3 17.09.2006 00:48:31 Trouble linking to ODCB through MS Access Hello I'm a newbie with what I hope is a simple problem: I trying to get data into Access through ODCB (ultimately to connect to MySQL) but when I select "ODCB Databases" as the file type (after choosing "Link Tables..." or "Import.." under "Get External Data") the dialogue box simply quits. The only clue I can find is that in all that I've read on the internet, the file type is quoted as... 4 14.09.2006 17:26:30 Pass-Thru Query or Stored Procs I'm working with someone trying to revamp their reporting system. They are currently using SQL Server 2000 as the backend and Access for doing their reporting. The problem is that they are building these huge complicated pass-thru queries, and often stringing several queries together to get the dataset they need for their report. The analysts know Access pretty well and are comfortabl... 6 12.09.2006 16:12:18 Access with ODBC from VB 2005 Hi everyne I`m trying to run aan acces query with parameters from VB 2005. If I do it with OleDB components I have no problems, but I need to do that with ODBC, but I get this error: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. The code is the following: Dim CnnODBC As Odbc.OdbcConn... 3 07.09.2006 11:49:01 Update system DSN via VBA I have a .mdb that uses a system DSN for a connection to an Informix database. Currently, the DSN on all client PC's were created with the same username/password and the tables were all linked using that username/password. The newest Informix ODBC driver no longer stores the username/password in the system tables, it references the DSN for that information. I would like to be able to ... 4 05.09.2006 21:23:06 Dynamic filter with Access/SQL Server I have a UDF in SQL Server 2000 that I access with a pass-through query in an Access 2002 mdb. The UDF includes grouping that I figured would be optimized if saved it on the server. I want to let the user apply filters on the original records, i.e. before the grouping. Is there any way to do this and still get the optimization? One thought I had was to generate a temp table or view with ... 3 05.09.2006 15:55:26 DSN-Less Past Thru Query I know how to make my ODBC linked tables (mdb to SQL 2000) DSNLess. How do I make my Pass Thru Query DSNLess?... 2 04.09.2006 09:44:14 VB3.0 Oracle 9i ODBC Connectivity When connecting Vb 3.0 application with oracle 9.1 database through oracle 7.1 client we are getting the following error ERR #3146 ODBC-- call failed. [Microsoft][ODBC DLL] Driver'SQLSetConnectoption failed[Oracle][Driver not capable][Oracle][ODBC ORacle Driver][Oracle OCI][ORA-12154: TNS:Could not resolve Service name.(#12154) front end : VB 3.0 back end : Oracle 9.2 ( server) on SOL... 2 31.08.2006 11:52:40 How Do I Connect to a Secured MS Access Database via ODBC / DSNLESS connection?? Hi All I am new to connecting MS Access and SQL databases so hope you all dont mind me posting an access related question:-) I use the following dsnLess connection string to connect to a access 2000 mdb that is not secured. (I use Clarion as a Front End)..this connects me to the mdb no problem. I have a Global varaible AccessDBsource in the owner field of the table in my Table De... 3 30.08.2006 11:48:44 Making objects hidden In my .mdb, I use linked tables primarily and many queries, forms, and reports. I like to have them all set as hidden as just another 'security' measure from prying eyes as well as helping me quickly locate the items I am currently still working on (these aren't hidden yet). Is there a VBA routine I could write to recurse the entire collection of items and set them to hidden (primarily... 2 29.08.2006 21:26:35 ODBC Returning Multiple Records when there is only one Basically, when I link using odbc to a table in SQL, occasionally ODBC will return multiple unique records when there really is only one. It's starting to become a real issue as I have to group by to remove the extra records (that don't really exist), but that comes at a significant efficiency drop. Here's the example, I have a table of customers. The employee, using a access form field, ... 5 24.08.2006 22:27:32 Linked Table has strange phenomenon In an SQL server 2000 I have a table with 99 fields, 3 of which are of datatype Bit. In an Access 2003 database (mdb) I make a link to this table. In the linked table everything is normal, I can edit the fields successfully. Now in SQL-Server I add another field of type Bit. Then I delete the link in Access and link the table once again. Now I can't edit the fields in the linked table anymore... 4 24.08.2006 22:24:24 Problems with Access 2003 and SQL Server 2005 Hi, everyone. I trying to connect a SQL Server 2005 to an Access 2003 frontend. Now in the past I have not had any trouble, but today seems to be a different day. Every time I go to try and open a dao.database object I get the error "Run-Time error '3000'': Reserved error(-1038); there is no message for this error." I am not really sure what the issue is here. Below is the line of... 1 23.08.2006 23:47:45 Problems with Access 2003 and SQL Server 2005 Hi, everyone. I trying to connect a SQL Server 2005 to an Access 2003 frontend. Now in the past I have not had any trouble, but today seems to be a different day. Every time I go to try and open a dao.database object I get the error "Run-Time error '3000'': Reserved error(-1038); there is no message for this error." I am not really sure what the issue is here. Below is the line of... 1 23.08.2006 23:45:16 Problems with Access 2003 and SQL Server 2005 Hi, everyone. I trying to connect a SQL Server 2005 to an Access 2003 frontend. Now in the past I have not had any trouble, but today seems to be a different day. Every time I go to try and open a dao.database object I get the error "Run-Time error '3000'': Reserved error(-1038); there is no message for this error." I am not really sure what the issue is here. Below is the line of... 1 23.08.2006 23:44:38 9 Pages: 1  2  3  4  5  6  7  8  9