Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   HA HA Ŷ£¡````` ... 1 13.03.2106 01:57:43 Error in queries after migration/conversion These were the queries in MS Access. After conversion they are showing errors. How to solve these? SELECT tblCurrent.AutoNumber, tblCurrent.TaxYear, tblCurrent.TaxType, tblCurrent.FEIN, tblCurrent.CompanyName, -(TotalAmount) AS Amount, tblCurrent.AccountID, tblCurrent.ParticipantInfo, 'Refund' AS FileName, GetDate() & ' Recd ' & [ParticipantInfo] AS Comment, 'No' AS RefundToBeProce... 1 29.09.2006 15:05:02 Exporting table data to an 80 column text file I need to take a table (every row) and export it to a text file in an 80 col. format. No delimiters or quotes ("") for text. All the fields in the table add up to 80 characters. I want to make it as automatic as possible.... 3 29.09.2006 03:48:17 Migrating Access apps to Microsoft.NET... Hello! Hopefully I got the right discussion group here...! In using the SQL Server Migration Assistant for Access instructions, I have completed the split Access 2003 database migration to the SQL Server 2005. Under the 'Preparing Access Databases for Migration' part of these instructions, it says "After you migrate databases to SQL Server 2005, you can continue to use Access by usi... 9 28.09.2006 15:29:01 ÓÐȤµÄ¹ÊÊ ÎÒÊÇÏ°¹ß×Ô¼ººÍ×Ô¼º×öÅóÓÑ,¹µÍ¨,Õù³³,˵·þ,ÓÐʱºòÊǸÐÐÔÓëÀíÐԵĶ·Õù,ÓÐʱºòÊÇÓ¹Ë×Ó볬ÍÑÖ®¼äµÄÕùÖ´,×Ô¼ºÒ»Ö±¶¼ÔÚÈÏʶ×Ô¼º,ÓÐʱºòÕ滳ÒÉ×Ô¼ºÊÇ·ñ¾«Éñ²»Õý³£,µ«ÒòΪÀ§»óһЩ¶«Î÷,²»µÃ²»°ÑÕâÖÖÕ½¶·½øÐе½µ×.³£»áÔÚÃÔãÈôʧ֮¼Ê,¾²ÏÂÐÄÀ´Ú¹ÊÍ×Ô¼ºµÄÐÄÇé,ñöÌýÄÚÐĵÄÓÄÔ¹. Æ«°®¹Â¶ÀµÄÈËÊǸ´ÔÓµÄ,È»¶ø»òÐí»¹ÊÇ×Ô¸ºµÄ,²»×Ô¸ºÓÖÔõôȥ¸ø×Ô¼ºÒ»Ì×ÀíÂÛ×ö±ç½â.ÎÒÊǺÜϲ»¶Äá²ÉµÄ,µ±È»¿´¶«Î÷ÊÇÒªÓÐ×Ô¼ºÃôÈñµÄÄ¿¹âµÄ,²»È»Ð¡ÐÄ×ß»ðÈëħ.»³ÒÉÅúÅ... 7 27.09.2006 09:31:53 Converting Dates from YYMMDD to MMDDYYYY Hi All; I'm looking for a format function that will convert a date in the text format of YYMMDD to text format of MMDDYYYY. Any help would be GREATLY appreciated! Thanks in advance! ... 4 24.09.2006 19:43:01 Fakers and breakers Someone is interfering with the proper running of these newsgroups. They are coming on in various guises. So far all the ones I have seen have been Hotmail accounts They all have similar message headers. I do not think that blocking the email address will work because they hop from identity to identity. I use my real name. I started to use some of these newsgroups recenty to refresh m... 4 24.09.2006 14:46:31 Converting Access 97 to 2000 not efficient ? Hi, Since i've read all the previous post about compacting Database with Jet and Adox... I understood how to convert a Access 97 database (called Bdd97) to Access 2000 database (called Bdd2000). The problem I have is when I try to open my new Access bdd 2000 converted (Bdd2000) in Access 2000, i have the usual message : You've selected a database that have been created in an old Acces... 1 20.09.2006 09:08:29 access97 to access2003 hi i cannot convert my database fron access97 to access2003. It tells me that i dont have proper permission for that, but i gave all the administrative rights to myself and did make my base to be monopolistic help anyone -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200609/1 ... 2 19.09.2006 05:27:09 Problem with queries converting from Access to SQL We have an Access database which keeps getting corrupt. One of the tables have more than 500 000 entries in it. I thought of converting to SQL 2000, but the access DB has Select and Update queries in it, and I can't seem to accomodate it. Any suggestions. Thanks. Paul.... 4 18.09.2006 13:59:45 Migrate Unicode data from MS Access to Oracle I need to migrate Unicode data from MS Access to Oracle. Have tried the following: -Exported the Access tables to csv/txt, but these files were generated in ANSI encoding, and the Unicode data got converted to ASCII characters. -ODBC export directly to the Oracle tables doesn't work either. -However, when the table is exported to excel, Unicode encoding is retained. I'm not looking for... 3 15.09.2006 22:53:20 Rocio esto es una prueba ... 2 10.09.2006 08:49:36 Install Office 2003 Hi, I have Office XP installed and now want to install Office 2003. What is the safest method - uninstall XP and load 2003 or load 2003 over XP? Please note that I use Outlook Express and can not loose email history or contacts. Thank you, Nick ... 4 05.09.2006 08:19:47 ¿Í ÀÌ °Å Âü ÁÁ³×¿ä. ^^ ... 1 05.09.2006 03:46:26 ºìÓ£ÌÒË®¹ûÍøÕýʽ¿ªÍ¨ÁË www.hytsg.com רҵµÄË®¹ûÁãÊÛÅäËÍÍøÕ¾.µ±ÌìËÍ»õ,Ãâ·ÑÅäËÍ.ԸΪÉϺ£¸÷½çÈËÊ¿·þÎñ. ... 1 26.08.2006 11:09:18 Documenting Macros I inherited a database that contains numerous Macros. I need to document all these macros and the documentor within Access format is not the greatest. Prefer table format within Word. Can anyone recommend a third-party tool or VBA code that will allow me to document the Macros in a table format? Thanks, Karen... 2 24.08.2006 21:16:24 d sdfsdfsdfsd ... 1 24.08.2006 11:22:59 How to suppress the conversion warning dialog box This is a multi-part message in MIME format. ------=_NextPart_000_007F_01C6BC5D.F3799610 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Dear all, When I used Access 2003 to convert a Access 97 database to Access 2000 = or above format, it will pop up a dialog box saying "After you have = converted this file to Access 2000 File format, the new f... 6 22.08.2006 13:56:27 Issue changing column data type I have a client that operates off of an access 97 database. I am in the process of migrating them to a more appropriate winforms and sql server solution, but for the time being I am also attempting to support their current system. They have a table that for whatever reason was created with 3 columns that should have been of type "currency" but instead were created as text. I am tryi... 4 22.08.2006 13:46:52 Help Please: Transferspreadsheet brings in odd format I'm using Ac 2003, Win xp pro, Excel 2003. My sheet is formatted as text. Example: data is 3249388005 in Excel but imports as 3.24939e+009 in Access. I've formatted the target table to which the data is appended as Text. As both the Excel cells and the Access field is formatted as text, I don't know how to correct this. It appears this is a scientific notation type data format probl... 5 21.08.2006 19:53:03 Database using Access 2.0 Our church purchased Church Windows software. When we asked if we could import our members from our existing database Greentree CDMS they said we couldn't because CW is an Access 2.0 database and we don't have that software. What would be the benefit of still using Access 2.0 for software development? Thanks, Linda ... 19 19.08.2006 22:38:35 Should I worry that my Access to SQL conversion has gone so well? I've been set the task of converting a 20 user Access 2003 database to SQL server 2000. The original access version is two databases, a front end and a back end. The front end uses about 40 forms. Without using the upsizing wizard, I have simply imported the backend into SQL, made a few changes to data types, and set a few primary keys etc., and then linked the front end to the SQL dat... 6 19.08.2006 09:37:13 Access 2003 - Close vs. Nothing Hi, Upon conversion to Access 2003, some DAO modules have both recordset close and set "recordset name" = nothing statements. Since Access 2003, automatically closes these recordsets upon exiting the program, are these needed in Access 2003? If so, should the Close or Nothing statement be used? Thank you, Nick ... 9 19.08.2006 09:31:45 Love Hotline Lady only 24-Hrs +91 9810577227 ... 1 18.08.2006 02:04:35 Éú»î ÓеÄÈË˵Éú»î¾ÍÏñÒ»±­°×¿ªË®,ƽµ­¶øÎÞζ,¶øÎҵĹ۵ãÈ´¸ÕºÃÓëÖ®Ïà·´,Ö»²»¹ýÎÒµÄÉú»îÖдó¶¼ÊDZ¯ÉË,ûÓжàÉٺܿªÐĵÄÊÂ,Èç¹û²»ÊÇËû,ÎÒÏëÎÒÒ²²»»áÕâÑù. ... 1 16.08.2006 01:58:51 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13