Search results

Hi, I have a front end Access and when I insert duplicate values becomes the error below. At which event can I catch the error? Violation of PRIMARY KEY constraint ‘123’. Cannot insert duplicate key in object’ 678’ Thank you

You can try this Option Compare Database Public k As String Private Sub Form_AfterInsert() k = Me.fieldname End Sub Private Sub Form_BeforeInsert(Cancel As Integer) Me.fieldname = k End Sub

thanks man for your reply. The package i run imports text file to Sql Server. As i said, when i execute it on local server it is executed really fast, but when i do the same from a remote computer there is a delay.. Looking for info on net i found the above...

When I exectute from cmd prompt (dtexec) an SSIS package on a local server, it takes about a few seconds to complete. When I execute the same package from a remote machine it takes about one minute. Any clues why is this happening; Thank you

Hi, I’ am trying to execute a SSIS package from MS Access. I have made the package, I have add reference to Microsoft DTSPackage Object Library and finally write the on button click procedure listed below Dim oPKG As New DTS.Package oPKG.LoadFromSQLServer "HLCTUB001", , , _...

Yes it is possible… The command line is: Me.buttonname.Enabled = false You can type it on an open event properties on a form. So when your form opens you can check if the date is your run date. If date=rundate then Me.buttonname.Enabled = true ‘runable else Me.buttonname.Enabled = false endif

Hi, I am opening a query in Access which has two linked sql tables but it takes to long to open. Can I choose a method (ADO) opening that query? If not, is there a way to speed up the process? thanks

Hi, I 've converted the code to ADO method. It was working fine in DAO but know I get the following error and i can't figure it out the soloution. Run-time error ‘3265’ Item cannot be found in the collection corresponding to the requested name or ordinal Function ChangeQuantUnit(Material...

Hi, In an Access table i have a field type date/time. The format for the field is "00:00". I am trying to import that table in Sql but with no luck. I found out that the problem is related to the field type i mentioned before. What is the correct data type for Sql; Thanks

thank you tehNellie

Hi I want a date field to an SQL 2000 table, to have default value Now() or date() as in Access. Which is the similar functions for SQL? Thanks

I am done with this. Thanks for the assistance :)

Thanks for your response. It get so big because we are daily importing 40-42 tables from SAP. I want to reduce the size so i will be able to back it up Could you please tell me where to type the previous commands;

Hi I have a db which's LDF File is 64GB and the mdf file is 554MB. I want to reduce the size of LDF file. Is it risky and how can i do this; I 've tried the shrink database and file wizard but with no results. I am workink on Sql Server 2000. Thanks

..and in the case of Orthodox St Dionisios :)

Dennisk thank you very much for your help. The way you suggest me to open the recordset is the proper way. Thank you again.. PS: My name in Greek is (Διονύσης) Dionisis and in English is Dennis like your.

thanks dennisk for your reply. This is my code. As i previous said the problem is solved but i would really like to take a look to my code. Any suggestions will be pleasantly accepted. ________________________________________________________________ Public Function EditRecSpin(Id, DMin, DMax...

In Sql Server there was a navchar(255) field in a table. I have import that table from Access and the specific field was memo type. The memo field in Access was converted to navchar in SQL and there was some trouble with null entries. I left it as it was and in default value i add: N' ' :)...

I resolved the previous error message but i am stil dealing with a new one: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." Any help?

Hi guys I will try to explain (bad English) an error I am dealing I connect to an Sql 2000 Server with Access. I used to work with DAO method and I realize that is to slow. So I started converting my code to ADO method and at this time I am working on a problem. When I try to edit an opened...