Recent content by gransbpa

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...