Threads Replies Last Post 29 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29   Access Crashes on Decimal Fields Does anyone know what the limit on Access's handling of Decimal Fields is ? While developing some dynamic SQL fields (with precision 19 and scale 10) caused Access to crash repeatedly. (I guess there is some poor person @ Microsoft trying to decipher the crash responses I caused.) When I changed the field to to integers, the problem was resolved. I really need to be working to ar... 2 23.05.2006 04:21:04 ADP Form totals causing error Is there a difference between access and ADP forms in the way you total values in the "Form Footer" section? In my sub form footer, I'm trying to use SUM function to total up a control on the sub form. I've done this many times without any trouble in a regular Access file. I'm getting the #Error in the total control in the subform footer. For a test, I used the formula in FORMULA 2 be... 3 21.05.2006 00:05:28 salud hola a todos ... 1 20.05.2006 21:24:29 Form not saving to table I have an access dbs that works fine while in access. I have to upsize the dbs to sql in order for my IT department to place it on networked computers throughout the plant. the problem, is that when I do the upsize, everything appears fine - I get no errors. when I open the form, enter data and then save and exit - none of the information was saved to the sql tables. I use the acce... 7 18.05.2006 17:21:45 Not Common both Tables This SQL selects all the common part numbers between the Main 2005/2006 tables but what criteria do I use to select the PN's that don't matchup (<>) between the two tables? Steve SELECT Main2006.PartNumber, Main2006.AnnualCSIConfirmation, Main2005.PartNumber, Main2005.AnnualCSIConfirmation FROM Main2006 INNER JOIN Main2005 ON Main2006.PartNumber = Main2005.PartNumber WHERE ... 6 18.05.2006 17:17:13 ×¢²á±í ×¢²á±íµ¼Èëµ¼³öÓÐÎÊÌâ? ... 2 17.05.2006 18:10:09 INSERT INTO another access table from ADP based on field Hi, I was hoping someone could help me with inserting a record from an ADP to a MDB, based on the current record displaying on a form. eg. I add a new record in an access form, when I click Save, copies that record to another database. Previously, both databases were MDB, and this is the SQL I used: INSERT INTO [MS Access;DATABASE=T:\Databases\Training Database\training.mdb].trainin... 2 17.05.2006 14:26:50 linked tables can only be created as views in ADP-- why? Why when I create linked tables between 2 SQL server databases does the recipient table show up as a view? Is there any way to force it to be a table? Randall Arnold ... 7 16.05.2006 23:14:53 Adding records using form based on stored procedure? Hi, Pretty simple question but probably not a simple answer. I tried converting my form to use simple "SELECT" stored procedure but find I cannot add records. Should I be able to add my table if the form's source was a stored procedure? Thanks ... 2 16.05.2006 20:49:02 Need Resources on using ADP with SQL SErver 2005! Please help! I need documentation on how to do this......can anyone poj t me in the right direction? Would appreciate it ... 4 16.05.2006 18:10:30 disconnected recordset anyone use disconnected recordsets with adodb? could you point me in the right direction please? tia. mcnewsxp ... 2 16.05.2006 18:08:33 Inventory Control Hello: I would like to know if there is an Inventory application made with Ms Access and SQL MSDE, for sale with source code? I would appreciate your links. Thanks! Armando Vargas. ... 1 16.05.2006 15:26:48 ³öÊÛÉöÔà ijÄÐÏÖÄê45Ë꣬ÉíÌ彡¿µ£¬ÒòÌØÊâÔ­ÒòÓû³öÊÛÉöÔàÒ»¸ö£¬ÓÐÒâÕßÇëÓë13532553588ê°ÏÈ ÉúÁªÏµ¡£ ... 4 16.05.2006 08:27:22 ³öÊÛÉöÔà ijÄÐÏÖÄê45Ë꣬ÉíÌ彡¿µ£¬ÒòÌØÊâÔ­ÒòÓû³öÊÛÉöÔàÒ»¸ö£¬ÓÐÒâÕßÇëÓë13582553588ê°ÏÈ ÉúÁªÏµ¡£ ... 2 16.05.2006 08:21:32 Secure an adp file? I have an adp file which I want to be accessed using forms only for security reasons. I have a front end which closes off underlying Access window, but it is still possible to connect to the underlying adp via a second mdb file. In Access mdb, encryption was possible - what can be done with an adp file to restrict access via a linked file. It looks like Microsoft reduced security options... 4 15.05.2006 17:52:02 Can't Create Linked Server SP in ADP I created a stored procedure to update a table on a linked server from a table in my local server. Both servers are SQL 7, and the linked server is accessed through the Internet. When I tried to create the stored procedure using an Access 2000 ADP file, the save command would continually time out. However, when I went into Enterprise Manager and created the stored procedure there, it sav... 1 15.05.2006 06:40:27 sql server 2005 september ctp Hello, by any chance, did anybody retain sql server 2005 developer september ctp? I have installed it, but now the beta is over and I'm trying to uninstall it with its Visual Studio 2005 (I believe it's also on the CD), it wants the installation source msi which I did not keep. If anybody still has it, please email vadimrapp at sbcglobal.net , would greatly appreciate. I can assure ... 1 13.05.2006 13:20:01 trying to get a function to use data from a form Hi. I'm pretty new to ADP but have been working in Access for many years. I've published a database to an MDF file and can get a funtion to search using the following code. The domain login is xxx'd. SELECT [Unit Name], datadata, [Department Name], [Remedy Name], [SAP Name], [Employee SAP], [SAP Status], [SAP Dept], [SAP Hire], [SAP Term], [IsTerm'd?] FROM ... 6 11.05.2006 04:55:39 Access XP / .ADP and Transferspreadsheet issue with SPs I have a SP that I can right-click on and export without any issue. If I try to do it programatically using TransferSpreadsheet(..., SPName, Filename, ...) It tells me it cannot find the object SPName. Doesn't matter what the name is. I have also tried dbo.SPName, dbo_SPName. Kyle! ... 4 10.05.2006 15:44:06 Add and update problem Access to sql server 2005 I have SQL Server 2005 developer installed on a windows 2003 server. With an MS Access 2003 adp I can connect to the tables of the database, I can see the records, but I can not change or add records. I also installed the same SQL Server on a windows XP profesional computer. There the problem doesn't arise. Suggestions? ... 3 10.05.2006 07:28:02 ´ó¼ÒºÃ ´ó¼ÒºÃ¡£¡£×£ÄãÃÇÌìÌ쿪ÐÄ¡£¡£ ... 5 10.05.2006 07:11:36 aa aaa ... 1 10.05.2006 04:17:03 Updating ADP frontend automatically? I need some assistance Trying to figure out a way, if possible, to somehow update an adp frontend once user opens the old adp. Please help! ... 3 09.05.2006 16:55:40 Timeout Expired but worked 3 months ago Access XP MDAC 2.8 SP1 SQL Server 2000 I have an ADP that I use for reporting that I have used for about a year. I only use it every 3 months, and it has worked up until now. This morning I tried using it, but after trying to open the report, it hourglassed and then showed a "Timeout expired" error. I searched this message and found out how to set the timeout limit, and set it to 3... 4 09.05.2006 16:52:03 Newbie Problem Hi All, I have created my first data access page and this works fine when I run it from Access, but when I right click on the report then run "web page preview" I get the errors:- "You do not have the necessary permissions to use......" then the path of the DB. It then says "data provider could not be initialised". How do I enable permissions on the DB to allow external access / ... 3 09.05.2006 16:46:00 29 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29