Search results

  1. A

    How to Disable Editing SQL Server Linked Recordsets and Encrypt it?

    So What should I do??? If any one can advise
  2. A

    Show Windows in Taskbar Problem With Access 2007

    The option "Show Windows in Taskbar" was working very fine in Access 2003. However, when I immigrate to Access 2007, the problem arise and checking this option checkbox doesnt take effect in Access 2007. for example, if I generate more than one report at the same time, they are not appearing...
  3. A

    How to Disable Editing SQL Server Linked Recordsets and Encrypt it?

    I am developing a system using the MS Access 2003 tool. The backend is SQL Server MSDE2000. I want: - Disable the user from directly editing the SQL Server Linked tables objects in the database window if he open these tables in the Datasheet view. He should edit it only through the MS Access...
  4. A

    How can I add Descending Sorting Index within a SQL Statement when creating a table

    I am talking about making SQL server table using SQL statement. How can I make it?
  5. A

    How can I add Descending Sorting Index within a SQL Statement when creating a table

    I built a table [EmployeesAttendanceReportSource_Normal] using the SQL Statement as shown below. What I need is to add a descending sorting index for the column [AttDay]. How to rewrite this SQL statement to achieve this: CREATE TABLE [dbo].[EmployeesAttendanceReportSource_Normal] (...
  6. A

    Is the Linking of Access tables through ODBC to SQL Server DB acheive the target?

    I am developing a client-server application, which means a multi-user and concurrent connection to the database at the same time. This requires a DBMS like SQL Server, ORACLE, DB2,... which achieve this requirement. As the MS Access is a NON multi user environment, and doesn't enable a user to...
  7. A

    How can automatically read from Excel Sheet?

    Is it possible to write a code that opens Excel file then read from a specific sheet then read cell by cell into the variables? Thanks,
  8. A

    How to open read a text file letter by letter without using "Scripting" object

    How to open read a text file letter by letter without using "Scripting" object I have a text file and I need to open it for reading and read it letter by letter without using the CreateObject("Scripting.FileSystemObject") statement. I need to know if I reach the end of the file also. Thanks &...
  9. A

    What is the Correspondent data definiton in SQL database for the "Yes/No" definiton?

    What is the Correspondent data definiton in SQL database for the "Yes/No" definiton? What is the Correspondent data definiton in MS SQL database for the "Yes/No" definiton in the MS Access? Thanks,
  10. A

    How to programmatically run a batch file

    How to programmatically run a batch file ( MS DOS ) file. What is the VB instruction used to run this file type? Thanks,
  11. A

    Disabling the user from viewing MDE tables design

    It is known that users of the MDE are diabled from viewing the design of the Reports, Forms, Modules objects. However, the Tables design is viewable. How can I prevent the user from viewing its design?
  12. A

    How can I programmatically make the system remove itself? Is this possible?

    I mean I want to write a code inside my access database(MDB) that remove the project itself from the PC. This is because I no longer need this database. Is there API that can I can call which will remove the caller application . Thanks,
  13. A

    How can I programmatically make the system remove itself? Is this possible?

    Is it possible to programmatically write a code in a form to fully make the system remove itself? Thanks,
  14. A

    How to get the actual time using API

    What I want is to get the actual date/time, even the user changes the date/time of the PC by setting the "Date and Time properties" window which shown in the system tray. Thanks,
  15. A

    How to disable the Importing functionality from my database?

    How can I disable any one from importing objects from my database?
  16. A

    If the AllowBypassKey property is disabled, how can the user reset this property

    If the AllowBypassKey property is disabled, how can the user reset this property? at the time that he can not open the system using the Shift+Enter. I mean he will directly see the system startup events. Thanks,
  17. A

    How to disable the user from using the Documenter tool?

    Is it possible to disable the user from using the Documenter tool, noted that the system is MDB and I dont want to make it MDE. Thanks,
  18. A

    I want to disable the user from opening the system using the Shift key

    Thanks for this valued assistant. I will apply it and see. Thanks,
  19. A

    I want to disable the user from opening the system using the Shift key

    I want to disable the user from opening the system using the Shift key. I want him to be able to open the system only normally. Noted that the system is mdb and without the need to convert it to mde.
  20. A

    How to programatically disable/uncheck the "Document deletions" option

    How to programatically disable/uncheck the "Document deletions" option which is used to confirm the deletion of the database objects?
Back
Top Bottom