Search results

Here is the core problem. It is not the complete protection - there still is the chance dropped packet will hurt tables when writing occurs. Indeed, database splitting decreases the chances - lets say to 1/4 or so, but doesn't eliminates the risks completely. In order to keep data protected...

So what will protect the backend in this case?

Frontend is not the most valueable part. I mean what will protect the backend, which holds the data?

Boblarson, I have one question for you. Whats the difference? What will prevent data corruption if you split database?

You don't need to do anything, just let 2 users use the same Access database file from network share.

Why are you so sure? If Aman needs to show some suggestions, then he has a lot of people in that database. When amount of records grow and number of people using database increase, fulltext search queries will need more and more time to complete. Being bind to OnUpdate event handler that delay...

Once it becomes hard for database to display suggestion list with every letter typed, Timer event can be used to update list once in few seconds (if text changed).

Btw, it is not obvious, that several users can use Access database simultaniously. Period. No locks, no special setup, no client-server. Just put it in shared network folder. Possibilities of database corruptions? It depends of wireless link quality. Usually it doesn't hurt much. But it...

Maybe you are getting it from wrong end? Just show your form in dialog mode full-screen-sized. User will not be able to switch to Access until he copes with this form.

Adwords is a real power, don't judge it fast. The key to it is a good words set. You don't need wrong people clicking - they enter and leave, you waste your money. So make word sets, that lead to result with big propability. Activate google analytics along with adwords. You will see who...

If you are working with Access 2007, you can use regular Image control. If you bind it to the field or expression that is a picture path and filename, it will display that picture.

Maybe you don't need that zooming controls so much? You can make a special form with big picture and user will scroll it back and forth... Or you can save img to temporary file and make some nice viewer to open it.

You can try Ammara DBPix (www.ammara.com), but its expensive a bit.

Access can't put controls ontop of some active content. Do you really need to use Word document? I think you do not change it often, if you are going to put some controls on it. You can use a form background image for your purposes, i think. If you need to modify word document in fact, you...

Don't you think 60 users is too much for Access database? I've heard Access stays reliable when 10 users open 1 MDB, and goes not very well when number of users increase. You can use SQL Server or terminal services, or do some database splitting/optimizations.

Can you post a tiny sample database for us to try to get it working in Access 2007?

Thumbnail pictures in continuous forms Tiny example of contacts database. Uses ActiveX for user-friendly image handling. Techniques demonstrated here: thumbnails generation continuous forms with pictures on-demand component installation instructing user how to turn active content on

If you need to compare text field on form to some current record field, you can reach them by their names. Lets assume you have: Table1 with (ID,Full Name) fields form tied to Table1, but without the textbox bound to Full Name field unbound textbox named Txt You can write something like...

If you are trying to automate this, you'd better look at Acrobat Reader ActiveX component - it is installed along with Reader itself. It has rich scripting interface.

The problem is that it's extremely hard to keep things simple and advanced the same time. While most users need simple solutions, they can't use complex ones - its too hard to understand and use em at once. Most big companies need extra-complex solutions and they can't use simple ones. Nice...