Recent content by rommelgenlight

I have created an executable file that will load my access project. What I want to know what code to use in Access that will not continue to load itself when it is not called by the executable file. my design would be, the executable file is the only file that will load the access project...

Here we go again! THE DESIGN FLAW ? 2GB LIMIT ? is it a FLAW? big word isn't it?

try this one. http://www.hansenonline.net/Access/index.html

http://www.access-programmers.co.uk/forums/showthread.php?t=173517

if the database that you work on with is simultaneously work with other country users and there is a need for updated data immediately then you really need the internet but if not necessary, then you can provide copy of the database the you work on to other countries and get it back from them...

in the long run. they have expense for creating new and free stuffs like sql server lite. Do they have benefit or income or sales or increase profits from this free stuffs. I dont think so. Moreover, they have created the new MS Access 2007 under MS Office 2007 edition. They can increase...

ofcourse that would be inefficient storing of data. I was just stating how many records will there be by that manner.

yep. I have stated it on the statement on what is your opinion. And I think there is no harm in trying. Same as you said, they have expensed making sql server lite to be free so why not do it to ms access if microsoft is to be a user friendly software amongst the rest. they have expensed...

Yes I have done that last night Banana! I have tried one table with 4 fields of which are all text fields with 255 length and I got full 2 gigabyte size only and full pack roughly 2.2 million rows of records only. Moreover, this does not concern only single users. I am looking forward to...

And my suggestion for you is that you create a field as tag on the table where your form's record source. therefore on_open event if that tag is set to yes then you can make a statements in your code to prevent edits. and after the first user finishes his transaction on that form, on_close of...

we have way for Microsoft to listen to us now.

you can lock or disable the field itself if your purpose only is to prevent the user from entering or editing records.

why do you need to insert record while you can relate the two tables to get the information or you can use UNION QUERY.

1. MS Access has been increased from 1 to 2 gigabyte, so therefore Microsoft can upgrade or improve its size limit. 2. Other say that Microsoft want us to purchase other programming software that is why they did not increase much the size limit of the database. But it is also true that we also...

your queries are not supposed to be affected by the splitting of your database because only the tables are splitted to other database unless the table names are changed? so I think it is!