Search results for query: *

Hi PHV, M8KWR. The problem has already been solved: I found out that someone else before me had reset the rowsource in VBA on the form open event: so, the rowsource property was overwritten every time the form opened. I had not considered this possibility, sorry for bothering you with this one...

Hi there, I have a combo box with it's rowsource based on a database table. This table has an ID (key-field), a number which is an identifier for the user and a description. I only want the combobox to show the identifier (not the ID) and the description, and I want to sort the combobox on the...

Hi Trevil, I tried changing the order, and indeed I found that table nr. 5 caused the problem, the code crashed and 6, 7, and 8 were neither deleted. When moving the code deleting table 5 to the end, table 6, 7, and 8 could be deleted without any problem. The strange things remains that, indeed...

Hi Trevil I use ODBC linked tables from a MSAccess 2003 front end approaching SQL server tables. I am not using ADO, but plain SQL in combination with the VBA command DoCmd.run(strSql). I can delete the data without any problem manually or using wizard made queries. And indeed: "Hmmm, it...

Hi there, I am running code which deletes all records from a table using SQL. This worked before, but now all of a sudden the code does not work anymore: I get the error message 86: could not delete from specified tables. This is strange, especially because the code empties 8 tables, and only 4...

Hi George, thanks for the tip. I tried,and succeeded in making the connection, but got a strange error message: the connection crashed at a certain line, which was exactly the record containing the field with too much data. However, when double clicking the error line for the details, the...

Hi GMMastros, I am not using the enterprise manager, I am using an SQL statement from within the Access database. This database has a local table containing a temporary value in a memo-field (with more than 4000 characters), and this value is transferred to the SQL server db. The Sql server...

You're absolutely right, but that's the point: I can enter no more than 4000 characters, while I should be able to enter more than 65000. I am under the impression that there is some limitation on the field length in the SQL Server database no matter what data type: whether I use nvarchar or...

Hi there, I have an SQL Server database, which I want to update from an Access database. One field in this Access database is a memo field, having an allmost unlimited capacity. When I try to update the field in the SQL Server database from this field, the maximum capacity in the SQL Server...

Hi PHV, I updated my client with the latest windows update, but after rebooting I still got the message. But thanks anyway, I think I'll find the answer on the microsoft site somewhere, so your link has set me on the right track.

Hi there, I am developing a database in access 2003. When I open the database, I get the following error message: 'Security warning: unsafe expressions are not blocked' Then I have the ability to open the database anyway, and after this I get this other message: This file may not be safe if...

Hi WantToKnowMore, you might want to try this: Function DisableShift() As Boolean On Error GoTo ErrDisableShift Dim db As Database Dim Prop As Property Const CONPROPNOTFOUND = 3270 Set db = CurrentDb() db.Properties("AllowByPassKey") = False MsgBox ("Possibility to start up in design mode...

Hi there, We have an old MSAccess 97 application, the backend of which we want to host on a Windows 2003 Server (Is now on a Windows NT Server). Furthermore, to be able to compact and repair this backend on a regular basis, we want to install the MSAccess97 executable on this server also. Does...

Hi there, We have an old MSAccess 97 application, the backend of which we want to host on a Windows 2003 Server (Is now on a Windows NT Server). Furthermore, to be able to compact and repair this backend on a regular basis, we want to install the MSAccess97 executable on this server also. Does...

Hi Molaker, thanks for the tip, now I'm getting somewhere. I completely overlooked the database object in object dropdown box under permissions, I thought that the 'Open Exclusive' option mentioned in the error message was about the option tools --> options --> advanced in the Access menu, but...

Thanks Roy, Frederico. I used the transferdatabase method exactly like that, and the problem was still that I got a linked table instead of a real copy. Now I found out why: the source database opened with workgroup file information, the destination database did not. I hope to bypass this...

Hi there, I want to copy table from one database to another with lines of code. I used the TransferDatabase method as well as the CopyObject method, but both create a link to the original database table instead of an actual copy. This is not what I want, however: I want the actual table copied...

Hi there, I want to copy table from one database to another with lines of code. I used the TransferDatabase method as well as the CopyObject method, but both create a link to the original database table instead of an actual copy. This is not what I want, however: I want the actual table copied...

Thanks Mike, I'll try your tips and post the hijack. I'm running Win98, IE version 6.0.2800.1106 Just a question: how do I disable system recovery in XP? (I also had some minor problems on a XP-machine). And is it also possible to disable system restore on a win98 machine?

Hi there, I'm seriously infected with a virus or something like that causing several problems: it is changing my startpage to c:\\windows\secure.html. After that, I get several messages that I am infected with spyware, and all kinds of xxx-sites open themselves up. Virtually every process on my...