Search results for query: *

PS an mde file does not protect the data in the tables only your code! you will want to create a robust front end with access keys disabled and make sure there are no backdoors to get to the database window in order to protect your lockout table (and encryt your database!).

you could also increment a value in the table to give say 30 runs before it locks. you may also want to have a trigger field so that once the date has been passed it trips the trigger to prevent the user adjusting thier system clock. (I presume you are encrypting and converting your database to...

I have only two suggestions to try: 1) decompile your database to clean out old code. (Run: "msaccess.exe /decompile") 2) get hold of the MS jet compact utility and run a full compact on the database, This can fix errors that an access compact and repair will not detect. (search MS...

If you have called the field by the same name and have not specified which table birthdate comes from then it will create a circular reference, ie it looks at itself. Either give the field a different name or add the name of the table that the birthdate comes from. in query designer use this...

I have included my test code below, it gives the time taken to access each record in the table. I used the same table of 26000 records, the Access Backend Database is located in a share on the SQL server machine, to keep network useage the same. I have: 1 a linked access table 2 an odbc...

I am at present looking into upgrading an Acc97 back end to SQL Server, I have done a few tests and am finding that there are some wierd performace issues. I was looking at improving sections of the database and leaving other sections alone and linking (via odbc) the remaining tables so that...

Runtime is freely distributable. Its avaiabable in office developers edtion.

Runtime is freely distributable. Its avaiabable in office developers edtion.

yes you can still use Access set up the sql database as a local odbc source then Link to odbc data source instead of to the mdb.

On Error GoTo GagePoint_Enter should be On Error GoTo Err_GagePoint_Enter

"OMG Please help!!" is not a very descriptive subject! your thread will get read last!! MS claim Access will handle Databases upto 1GB - this does not mean tht your host will allow you to use 1gb of their drives though!! If your database is SQL server then capaicty is not an issue...

Thanks for the info I've got it up and running a star for you both, as you both were heading towards .Properties("Description") and that solved the problem =)

I have several fields in several tables that contain a numeric ID representing a contact record in another database (hence not linked) I am in need of creating a method to update this ID in every occurance, I was thinking of For Each tbl In CurrentDb.TableDefs For Each fld In tbl.Fields...

Try : Call Shell("net send " & StrRecipient & " " & strSendText)

I had not heard of that either but I just checked and it is correct!! if you want to see for yourself: create a new DB set view system objects to true (in tool/options) look in msysobjects table create and save a new form [Form1] notice the object appears in msysobjects table - Name:[Form1] go...

Try this: =format([Location],"000") & "-" & format([Department],"000") & "-" & Format([Supplier],"000") & "-" & Format([Asset],"000")

oops lol I have on error resume next at the start of the function, this just tells it to skip the error and move on, your right the function does produce an error if it cant find any file, or incorrect path. Sub moveimages() on error resume next Dim rs As Recordset Dim fs As Object const...

WRT new versions: I use a bat file to copy a new front end to a users pc - it is also clever enough to re-open the database once copied (if u notice it doesn't matter where access is installed on the users pc) note strVersion is a Public constant in each front-end and tblversionmaster is a...

well dont check for the file - if its there it would be moved if it isn't it wont. the fs.copyfile does not error if the file does not exist. Dim rs As Recordset Dim fs As Object const strPath as string = "\\zurich\applications\images\" Set fs =...

Look for the position of the first space then show all chars to the left: forename:Trim(left(Name,(instr(Name," ")))) Or Right: Surname:Trim(Right(Name,(Len(Name)-instr(Name," "))))) This fails if there is no space!! so apply a filter and deal with those seperatly.