Search results

Guys thanks for helping me out with your inputs on my other post. Can you help me again on this one. I have this code researched that will add vba reference. code: Function FixUpRefs() Dim loRef As Access.Reference Dim intCount As Integer Dim intX As Integer Dim blnBroke As...

In a way, the code you provided was identical to mine. When I test, Filelen, LOF and filesystemobject in getting the db size, their results were the same. So I can use either of the three. I was just thinking if their where other functions that will state the correct db size because I am...

Ok guys, thank you very much for your inputs. So was LOF or Filelen or filesystemobject were the only ways that we can get the value of db size correctly?

Thanks Galaxion for your input.

I think application.setoption is right method. search for it on the internet or access help.

What do you mean about bastards Chris?

i just mention those qualifiers because I have 3 functions to get the size value in bytes and I wanted to know if there will be difference in the result if between the 3 for more test to be conducted. Anyway, LOF will already suffice. But I will do more test between the three. thanks

I see. Thank you very much.

ok. I havent tested the LOF, filelen and filesystemobject more than twice, but base on my 2 test conducted, the result between the three where the same. But you suggested to use LOF. Do you mean in the long run and more tests, LOF will return the most accurate correct length in bytes?

1000 bytes = 1 kb When does it make a difference to me? I want to get the exact database size of the access db. The purpose is to collect the record of the increment from the previous to current database size which will inform the user that the database has increased by this value.

I am using filelen, LOF and FileSystemObject to get the size of the access database. They get similar result however, for example my database in the windows explorer says 4864 kb, the function will give result as 4,980,736 which is 4981 kb. There is the difference of 117. What is the right...

David, The program is not self-installed It is in ACCDE format There are no additional files such as ocx's, dll yet. The program is only for XP The program cannot be access remotely For the moment I have not thought about liabilities on support, I will think about that. Thanks for that input...

Thanks David. In addition to that, what support can I provide for Application only and what support can I provide for Data? I have only few ideas on my mind now. Can suggest some?

Any inputs guys?

I see. What other after sales product or service can you recommend to me Dave? And how much do you think it should cost?

I have read from somewhere that it was more enhanced. Does anybody know this?

Dim rs As Recordset Dim ws As Workspace Dim db As Database Dim dbname As String dbname = CurrentProject.Path & "\container\config.accdb" Set ws = DBEngine.Workspaces(0) Set db = ws.OpenDatabase(dbname) Set rs = db.OpenRecordset("confpath", dbOpenSnapshot) Set Me.Form.Recordset = rs This is the...

I cant use the record source property because if I do that the underlying database of it will be opened and I need to do backup of the said db. If I will do that, I will get permission denied error message. Anyway, I saw the problem, that is I should not close the recordset, the database...

Good day guys, Does anybody know what is the difference between Access 2007 and 2010 in terms of password security?

Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim ws As DAO.Workspace Dim rst As DAO.Recordset Set ws = DBEngine.Workspaces(0) Set db = ws.OpenDatabase(CurrentProject.Path & "\container\config.accdb", False, False, "MS Access;PWD=""") Set rst =...