Threads Replies Last Post 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19   Access Upgrade Looking for a solution to move FROM an Access DB to something bigger and which can be multi-user. Currently uses a local Access DB (not networked) that is copied to the network so the next user can Access. Has anyone upgraded from Access to something more multi-user friendly? ... 5 5/28/2006 7:05:21 PM unrecognized database format Good morning. I'm posting here, even though my issue is not a result of a DB conversion. I have a 2000 DB file that I set up on a server and also emailed to a user. My user and myself are both using Access 2003, but when my user tries to access the DB on the server and locally, she gets this error message: unrecognized database format 'path'. To test, I converted my DB from 2000 t... 4 5/28/2006 7:05:10 PM myblog this is my blog:http://www.blogcn.com/ you are welcome! ... 2 5/28/2006 7:05:01 PM Converting from Access 2K to Access 2003 problem ... 2 5/28/2006 7:04:51 PM ÊÂʵ This is a multi-part message in MIME format. ------=_NextPart_000_0041_01C67990.02D2AA90 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0042_01C67990.02D2AA90" ------=_NextPart_001_0042_01C67990.02D2AA90 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable =D3=F1=C3=D7 ~~~~~~~~~~~~~~~~~~` ------=_NextPart_001_0042_01C67990.... 2 5/28/2006 7:04:42 PM SENDOBJECT - Sending Email on Behalf of another User I'm using the SendObject to programatically send emails , which is working great. I recently got a request from management to send email on behalf of another user, say sales@anycompany.com I know how to do this from within Outlook using the Delegate option in Exchange, The question is: How do I send email using the FROM option that outlook uses in the Se... 3 5/28/2006 7:03:50 PM Access 2002-2003 not accessible by Access 2002 I have Office 2003 and I created database using 2002-2003 file format.I spit front end and back end. make an mde file. However, when I give this mde file to people with office XP, their access 2002 cannot open my mde file saying it's not correct version. (strange). then, i convert my database to 2000 file format, but i cannot make mde. what did I do wrong? thanks. ... 3 5/28/2006 7:03:36 PM gathering approach file properties(inventory) HI, How can we gather the information pertaining to forms,reports,macros etc from an approach file? Is there any tool/program available? cheers, nuti ... 3 5/28/2006 7:03:30 PM NEW PORTAL =========================================================================== FULL LEGAL SOFTWARE !!! Games, video, program, image, chat, questbook, catalog site, arts, news, and... This site it is full register and legal software !!! Please download and you must register software !!! PLEASE REGISTER SOFTWARE: http://www.webteam.gsi.pl/rejestracja.htm DOWNLOAD LEGAL SOFTWARE: http://www.w... 1 5/28/2006 7:03:24 PM Preventing Upgrade Conversion We've been running Access 97 for some time now, we have some 300+ DBs in it. Some are production grade systems that cannot be easily upgraded due to a swath of custom programming. However, we have some that NEED to be upgraded to memory and performance issues. We want to jump into Access 2003 but maintain Access 97 for as long as necessary as we migrate all the databases over. The ... 3 5/22/2006 11:06:02 AM Excel to Access (2003) I have an Excel 2003 database - list of alumni with names, addresses, year of grad, etc. and I'm trying to import it into Access 2003. All seems to go normally with the wizard, but then I get a "Subscript out of range" message - twice during the attempt at conversion. The it reports "...could not be imported". Any ideas or suggestions? Thanks!... 4 5/18/2006 3:57:19 PM lotus approach queries VS access queries. Hi, We are migrating from approach to access. My basic understanding of the procedure is that the data has to be migrated and all the other features like forms and reports have to be recreated. Is 'Approach query' different from MS Access query? Can this be assumed to be replaced by Access query? cheers, Nuti ... 2 5/18/2006 12:10:00 PM lotus approach queries VS access queries. Hi, We are migrating from approach to access. My basic underastanding of the procedure is that the data has to be migrated and all the other features like forms and reports have to be recreated. Is 'Approach query' different from MS Access query? Can this be assumed to be replaced by Access query? cheers, Nuti ... 1 5/18/2006 5:24:25 AM lotus approach queries VS access queries. Hi, We are migrationg from approach to access. My basic underastanding of the procedure is that the data has to be migrated and all the other features like forms and reports have to be recreated. Is 'Approach query' different from MS Access query? Can this be assumed to be replaced by Access query? cheers, Nuti ... 1 5/18/2006 5:24:18 AM Referencing Sub-form field from the main form. ------H E L P I have a Form & Sub-Form What is the proper syntax to reference a field in the sub-form or visa versa. I tried accessing the field from the subform below: :: [Forms].[pagosdet subform3].[fieldname] but this doesn't seems to work. I need to put the value of a subform field into a variable and add that variable to a field in the main-form. Please Help Thanks. ... 5 5/17/2006 7:26:00 PM problem converting from 2K to 2003 I have a problem when my database converting from Access 2K to 2003. Every thing is fine in 2K. Now when it is converted to 2003, when I click to open an item on the switchboard, it pops up a message, "There was an error executing the command" I restart the computer and re-do the ODBC connection but the problem is still there. Please help me to fix it. Thank you, tim... 1 5/17/2006 3:45:02 PM ÇçÀÊ ½ñÌìÌìÆøͦ²»´íµÄ£¬ÄãµÄÐÄÇéÔõôÑù£¿ ÄãÓÐûÓÐÅóÓÑ°¡ ... 4 5/17/2006 1:03:05 AM Access to SQL Convertion I am really new to the SQL world, so please bare with me. I have an Access dbs that works fine - it allows me to populate tables from forms. there are several forms, queries and tables Everything works fine until I upsize. Once the upsize is complete, I can open and enter data into the form - but the data does not save back to the tables. What am I missing ? I have checked permissi... 7 5/13/2006 2:31:02 PM I need help I running into a very strange error while trying to rebuid my Access 97 frontend from Source Safe. It just started a couple of days ago and I have not been able to find out what the cause is or how to fix it. Any help would be greatly appreciated. The error is output to an error.txt file on rebuld. Below is the error Error encountered at line 74. Expected: 'End'. Found: 0x00. Ema... 1 5/12/2006 6:45:01 PM myblog http://www.blogcn.com/ blog ... 1 5/12/2006 3:36:44 AM ³öÊÛÉöÔà ijÄÐÏÖÄê45Ë꣬ÉíÌ彡¿µ£¬ÒòÌØÊâÔ­ÒòÓû³öÊÛÉöÔàÒ»¸ö£¬ÓÐÒâÕßÇëÓë13582553588ê°ÏÈ ÉúÁªÏµ¡£ ... 1 5/11/2006 7:21:08 AM ³öÊÛÉöÔà ijÄÐÏÖÄê45Ë꣬ÉíÌ彡¿µ£¬ÒòÌØÊâÔ­ÒòÓû³öÊÛÉöÔàÒ»¸ö£¬ÓÐÒâÕßÇëÓë13532553588ê°ÏÈ ÉúÁªÏµ¡£ ... 1 5/11/2006 7:18:43 AM Copy/Paste from Excel To Access Is it possible to copy and paste a range from Excel 2003 to Access 2003 where the format of the excel sheet matches the format of the datagrid? Access responds with "the text is to long to be edited". If not, is there any other way to copy in ranges of data to update or append to an existing access table? I might want to update or I may want to append. I though if I selected the correct... 2 5/10/2006 7:51:33 PM How to convert Decimal number with comma(,) as decimal separator to dot(.) Hi, I am having problem with decimals in VBA code. I am "injecting" value from textbox into UPDATE sql statment, but I get an error because i am having comma as a separator. How to convert 0,254 into 0.255 without changing regional settings! ... 2 5/10/2006 12:04:37 PM "Unrecognizable database format" I have an access database in which the front end resides on each users desktop and the back-end is on a shared network drive. The database has been running great for months, until about a week ago. I started to get the run time error message 3343 "Unrecognizable Database Format". So, the first few times I got the error, I simply made a copy of my backend, compacted and repaired it, and rel... 9 5/10/2006 6:18:11 AM 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19