Search results

I noticed the result of my query from the selection window is non-exclusive, for eg: if I have two selection fields: VendorService ID, Network Type. The table has the following data (underlines added for formating): VendorService ID ____Network Type 1_________________ISDN 1_________________ATM...

Thanks Autoeng, I've thought of the old standby method, but that was what I was trying to avoid. Compact and Repair was fine when I opened the database exclusively, but when I open it in sharing mode, the problem remained the same. So I tried many times, eventually it just healed by itself as...

Great! It works. Thank you.

When trying to Compact and Repair my application, a warning message appears as shown: Table 'TempMSysAccessObjects' already exists. It exits without compacting or repairing. How can I fix this problem? Thanks for helping.

Hi AncientOne, Thank you for your suggestion, it still doesn't work though. :(

The [VendorService ID] is a numeric field.

I have a selectin window for a report that if nothing is entered for the field, all records will be displayed in the report. The query I've created is as follow: IIf(IsNull([forms].[fmVSSelection].[VendorService ID]),Like "*",[forms].[fmVSSelection].[VendorService ID]) However it doesn't work...

Thank you Auteng and ghudson... Your advice have been very helpful to me.

I'm not really sure that it is secure , but I believe my application is now encrypted after the workgroup creation because whenever I zip it, the file size remains the same. users are still able to run the application without being prompted to enter username and password

I've a question on security as the application that i've deployed doesn't ask for username/password when run. Here is a summary of what I've done: 1. Split the database 2. created a new workgroup, containing a 'superuser' as well as all the other normal users. 3. changed ownership of all the...

Thanks Autoeng. I called local Microsoft customer care and realised that I'm actually using Access 2002, not Access 2000 as I always thought. My apologies.

I've searched my office and home PCs in the folder location and also searched the entire harddisks for the file. The file simply does not exist in my systems for some reason. Could someone post the file here if the file is not too big please? Thanks...

I'm not able to locate the file 'Wrkgadm.exe' in any of the folders in my PC. I'm using Access 2000 and XP Developer running on W2K Prof. Could someone direct me to the right folder or post the file here please? Thanks...

ok, thanks Tim.

Hi CALV, I've split my database into 'be' and 'fe'. With the 'be' now residing in a server and the 'fe' being installed at a number of users' PCs in the company's workgroup environment. The reason I asked that question is because the IT support guy here is not so keen in providing filesharing...

Hi GumbyD, Thanks for your help. I've found a posting on the same subject and have realised I've not done what is required.

ic. Thanks Wayne.

Thanks Fizzio.

Just wonder whether it is possible to configure client application to link to tables in 'be' by pointing to the server's IP address instead of filesharing?

It's ok. Thank you anyway. :-) I just discovered that earlier today when I tried moving the link to 'be'. Thanks Pat.