Recent content by SamCec

Immediately under the "General Declaration" section of my Main Form, I added this code: Private Declare Function apiGetComputerName Lib "kernel32" Alias _ "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSMachineName() As String 'Returns the computername Dim...

I saw the property called "Locked" and another one called "Enabled". What one is used, I presume "Locked". Can you or someone else show be how to get the current "Computer-Name"? In coding, I can then compare a literal to that computer name. Of course, if I get an un-equal condition, I can then...

After reading the above suggestions, I was wondering if it is possible to do this: In the LOAD event of the MAIN form, write some code that would check for the Computer-Name. If the routine is being run from that computer, allow updates to the db; if it is not, the db is READ-ONLY. If you...

Dave H. and others. I should have clarified this in my original post-- This is not being done on any type of network. Mine plus the other 1/2 dozen users I mentioned are all using standalone (home) PC's. Sam

DCrake: Thank you for the reply but I need to ask you or other members of this forum to help me do what you suggested above. I have no idea how to write the code and no idea how to tell the system "it's read only". If Access or the runtime version is not on the User's PC, will they be prompted...

Hi: I'm new to Access and installed Access 2003 to my system. I developed a database (mdb), some Reports and some Queries. This database, reports and queries must be given to 1/2 dozen people. My first question is: Must they have MS Access on their system in order to use the reports, the...

Doc Man:via your input I traced down my problem. After importing the data and description from SDB1.mdb into RDB2.mdb, I forgot to change the Table Name. So thank you for your reply. I do have another question concerning this: The original database of RDB2.mdb used a SEQuence field (automtic...

I have 2 MS Access 2003 databases (.mbd). For simplicity I will call these SDB1.mdb and RDB2.mdb. SDB1 is a standard mdb database with approximately 350 records. RDB2.mdb has 0 records (I deleted all records from this database but DID NOT delete the field descriptions). RDB2.mdb was written...