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