Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡­¡­ ÒôÀÖºÐ4.8Ôª£»ÒôÏ첨1.8Ôª£»²»µ¹ÎÌ3.8Ôª£»ÔÓÎïͲ5.8Ôª¡­¡­ ¸ü¶àÐÅÏ¢Çë¼ûÍøÕ¾:www.jl-sm.com ... 1 5/31/2007 3:28:50 AM Problem getting ID Hi, I have jus having my backend move to SQL Server 2005 and I am having trouble add new record when connecting throu ODBC. The code below does not return the ID anymore Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim MyID as Long DoCmd.Hourglass True Set dbs = CurrentDb Set rst = dbs.OpenRecordset("sysUnits", dbOpenDynaset) With rst .AddNew ![Unit_Name_e] = Me.U... 2 5/30/2007 7:16:40 PM ODBC Update Read-Only when Opening CurrentDb Table? Hello, I have two different functions created in Access which I'm calling via a macro to test. One works and the other one complains that the database is read-only when issuing AddNew. What am I doing wrong? This one Works and the table is updated correctly. ************************************************************ Option Compare Database Public Function AddIP(tablename As St... 4 5/28/2007 7:10:42 AM Cannot edit linked SQL 2005 tables We created a new database in SQL Server 2005 and used the ODBC "linked" tables to our application. On some tables (not all), we cannot add or edit records. Any idea where I can look? Also, when I print table info from analyzer it shows Updateable=false. Not sure why. Thanks. David ... 9 5/24/2007 9:27:42 AM How Link tables to back-end on a web server? Does anyone know how to link my front end to a back end sitting on a web server? There is a userid and password required for the web server and the back end is also protected by an Access password. Can this even be done? Thanks.... 4 5/24/2007 8:08:33 AM Using ADO in an mdb application I have a large and complex Access 2000 application where the front end and back end mdb files are split. Both mdb's currently reside on a Citrix server, and the performance is very good. However, I need to move the backend mdb data to SQL Server, and I'm concerned about what this will do to performance. Because of the complexity I do not want to rewrite the front end as an adp applica... 46 5/24/2007 4:12:26 AM Problem with query using linked tables and vba function I have the following problem: I have a select query which uses two tables linked to SQL Server via ODBC. When I run it for the first time, I get the SQL Server login prompt (which is normal, since I didn't persist the login information when I linked the tables). The problem comes when I browse the results. Access randomly shows the login prompt again. One of the fields within the query is c... 2 5/23/2007 11:37:49 PM can a table be opened in access by todays date Hi Can anyone point me in the right direction here, I would like to open a table in access 2003 by date. I have an asp web page which needs to read data from a table with each days today's date (which ever day that is) then a new table is created with today's date. Example: I have a table called 17-may-2007 my ASP page reads this table for 24hours then tomorrow (12:00 midnight 18th) I wi... 2 5/22/2007 2:40:35 PM 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... 11 5/18/2007 11:47:19 AM Add Record in ODBCDirect mode? If I open a database in ODBCDirect mode and try to add a record to a record set, it doesn't add. The following seems to work with no errors, but nothing gets added when there is something to add.. Set ws = CreateWorkspace("test", "admin", "", dbUseODBC) Set db = ws.OpenDatabase("", dbDriverNoPrompt, , "ODBC;DSN=WebLogInFirebird;Driver=Firebird/InterBase(r) driver;Dbname=L:\testdb\... 4 5/17/2007 6:52:20 PM Use Access for front end to Oracle New to this... I want to use Access to access Oracle - just to try out SQL statements, etc. before I embed them in Excel. I have an ODBC connection that works fine. I can use it inside Excel. How do I point Access to it? All I can find is the File/Get External Data/Import, and /Link Tables. However both options seem to require a SQL Server be in the mix somehow. Is this possible t... 3 5/15/2007 11:00:30 AM Trapping ODBC Errors in Access 2000 HI All, I've got a database that connects to a Progress database using a DataDirect driver. At times I want users to be able to write back to Progress and if a record is locked I get the standard "can't acquire record lock" dialog. Does anyone know if I can trap the error, gracefully halt what's going on, and deliver the user a message they'll understand? I've looked at a few Micros... 4 5/11/2007 10:11:06 PM Re: U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w wiadomo¶ci news:... > > > -- > msnews.microsoft.com > U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w > wiadomo¶ci news:... >> >> >> -- >> msnews.microsoft.com >> U¿ytkownik "Jan Kowalski" <osoba@microsoft.com> napis... 1 5/9/2007 3:44:44 PM Re: U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w wiadomo¶ci news:... > > > -- > msnews.microsoft.com > U¿ytkownik ">" <Jan Kowalski <Tutaj wpisujesz ¶wój nick> napisa³ w > wiadomo¶ci news:... >> >> >> -- >> msnews.microsoft.com >> U¿ytkownik "Jan Kowalski" <osoba@microsoft.com> napis... 1 5/9/2007 3:44:44 PM Hide connection string in SQL pass through Hi, We are using MS access front end to a Oracle back end database. A number of the forms use pass-through queries. We are using a global user name and password to create the pass-throughs so that all users can access the data. However that user name and password is visible in the pass-through. Is there any way to hide login information in the connection string ? Any help will be appreciat... 2 5/8/2007 8:27:06 AM Ϊ´ó¼ÒËÍ֪ʶ²Æ¸»À´ÁË ´ó¼ÒºÃ£®ÄúÏëÈÃ×Ô¼ºº¢×ÓѧºÃ֪ʶÂð£¿ÓиüºÃµÄδÀ´Âð£¿Ï£Íû¾ÍÔÚÓÚÄãµÄÁ˽⣬ÇëµÇ½http://hi.baidu.com/bainaojy5£® ... 1 5/6/2007 9:28:50 AM Access (ADP) Compatibility with SQL Server 2005 I am having problems running an ADP (access data project) in previous versions of Micrsoft access, mostly Access 2003, and I was wondering if there are compatability issues with SQL Server 2005. Do I have to upgrade to Access 2007?... 2 5/3/2007 8:12:06 PM Access 2007 problem with Extended Properties using Accesss 2003 Pr Hi I have had a persistent problem since I have upgraded to Access 2007 which I have been unable to resolve in code or through any level of debugging. However, if I open the same Access Project file now in Access 2003 the application works which indicates to me that Access 2007 has a bug of some sort with Extended Properties. Whenever I choose a drop down value for a new record in ... 8 5/2/2007 6:44:55 PM Cannot Link with ODBC Been using Access for many years. Upgraded to Access 2003. Tried linking with ODBC. Something I've done a hundred times. MENU > File > Get External Data > Link In the dialog box, I select ODBC... Dialog box just closes! Does not let me select an ODBC source. What's wrong? thanks! ... 3 5/2/2007 12:49:01 PM Inserting OLE Objects Dear all, I want to store some data in form of a zip file into an access database. I created a table with with a column of type OLE Object, then I designed a form to insert data to the table. I inserted some files to it, but when I tried to read them using my java client it retrieves an OLE object but I just need the file content (what the program gets form the db was the original file ad... 1 5/1/2007 9:53:48 PM To ADP or Not to ADP - That is the question Okay, here is one I need help with. That is making a decision on which way to go. Current environment: 3 separate application. 2 correctly split, the other will be. All are semi complete. The 3 will be combined into one application and deployed to 20 + users who will be using it heavily. Because of the nature of the application, there will be heavy use of the back end New direction... 9 5/1/2007 1:21:57 AM BCC field... Hi all, The BCC field doesn't seem to be an option. Has it been removed or am I just blind? Cheers, KEN ... 2 4/30/2007 9:47:42 PM mdb table in adp as a form recordsource Okay, I am fumbling my way through my second attempt at an adp (we won't talk about the first). The situation is that there are serveral tables in an mdb that are used accross multiple applications. User Info, Rate Table, Action code Table, etc. The new adp I am converting from a partially complete mdb, but the back end is getting too big for an mdb, but I have been told to use the tabl... 3 4/28/2007 4:55:07 AM Access 2003 and SQL 2005 and replication Hi all, I am fcing a strange thing when using Access with SQL 2005. I guess it might be related to the ODBC driver but before making dual-code (supporting both SQL 2000 and SQL 2005 servers), I was wondering if I am assuming right. We are having an Access front-end and link to the database using the ODBC driver. Tables are attached using code : With p_conConnect '(this is an ADO... 15 4/28/2007 12:49:16 AM No relationship editing of Access Projects (ADP) in Access 2007 The relationships function is grayed out for all ADPs in Access 2007. This is not the case in Access 2003. Is this a known problem, or by design? Thanks very much Paul... 1 4/27/2007 10:26:03 AM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12