Search results

As you can directly go live after developing the software using the MS Access 2013, Is it an alternative for the ASP.net as everything now is online directly. Please clarify, Thanks a lot

How to convert the data shown when opening the SQL Server tables as "#" symbol As a way to encrypt the data in the SQL Server, I have observer that when opening the SQL Server tables, I see it shown as "#" syble. How can I achieve this with my SQL Server database so not possible to read it...

Is there a VB code that I can use to automatically compress and repair the database?

I have searched all the sites for the MS Access 2003 Run-time software, but I failed to get it. It is a free software and free to redistribute. It is available in the Access Developer extension copy. I will appreciate If there is anyone who can tell me a web link I can use to download this...

If my computer name is Elephant, and I want to look for all the SQL instances at this computer, How can I get those?

Thanks Mr. georgedwilkinson. However, Unfortunatelly the another database is located in different server. If I only put the database name, it will not find it as it thinks its in the same database. Correct? For this reason I had clarify my question by mentioning the DSN Name which refers to...

Banana you always dont got what I am looking for. However, thanks.

I would like to write a stored procedure that insert data from table [SourceEvents] located at a DB linked to DSN called CARDAX into another table [AllAttendanceEvents] located at the same DB of the stored procedure, which this DB is linked to a DSN called BAHRAIN. If both tables are located...

Thanks very much it works. I observed that the MS SQL Server UDFs take the same time taken by the VB functions. Does the SQL SPs take less time than the UDFs or same if the code algorithm is same? My SP which calls a UDF called FindLeaveReason for every record of the table. Is the calling way...

I modify my code as you advise, but the problem still.

Mr. dAtarenaline, thanks very much for your continuous help and participations. When I run this code, it gives me the following error: Run-time error '3420': Object invalid or no longer set. but I am sure that the object (SP) is there. I even tested another object (SP), it gives me the same...

My code is as follow, please tell me What I should modify or add Dim db As Database Dim SQLstr As String Set db = DBEngine.Workspaces(0).OpenDatabase("", False, False, "ODBC;DSN=BAHRAIN;Description=BAHRAIN;UID=Administrator;DATABASE=Bahrain;Trusted_Connection=Yes") SQL...

I have a stored procedure that takes time to execute. It is supposed to work properly, but the problem is that it shows the message "Timeout expired" before showing making the results. How can I increase the total Timeout so it will not give me this message? Thanks in advance.

How can I move from record to the next record as what we do in the VB Code by using movenext and moveprevious. How can I achieve this in the SQL Server code. Thanks,

It works nice and perfect. I am highly appreciative for you. Can I to send you email on your personal one? Thanks & Regards

I am highly appreciative for you datAdrenaline. I have tried the first option and make it as follow: strSQL = "SELECT dbo.FindPSF" & "(" & MyIx & "," & "'" & Format(MySt, "dd-mmm-yyyy HH:MM:SS") & "') As MyFn" With CurrentDb.CreateQueryDef("~" & Int(timer), strSQL).Connect =...

I want to call a SQL server User Defined Function UDF from MS Access code and get its returned value. I successded in calling it but I dont know how to get its returned value. The code I used is as follow: MyIx = 50034 MySt = "20/12/2007 20:30:00" Set db =...

Correct. I will try the Start, Finish as datetime. However, what is the data type used if the fields are only time not datetime and not smalldatetime?

I have a SQL Server database. I buildt a stored procedure FindPSF as follow: CREATE PROCEDURE dbo.FindPSF(@Ix int) AS SELECT Indx, AttDay, Start, Finish, DATEDIFF(day, Start, Finish) FROM dbo.SelectedEmployeesWorkMode WHERE (Indx = @Ix) AND (NOT (Start IS NULL)) AND (NOT (Finish...

it works. thanks,