Recent content by Francescina

It is possible that your MDW does NOT contain an user with administrator rights. This means that the developer of the application has completely applied the "double-MDW" security improvement I always recommend. If you do not get hold of a MDW that contains a real administrator (or...

Korngeek, Your question: How do you allow them to create new users and set their permissions without allowing them to get into protected areas of the program? The answer: Only users with adminstrator rights (to EVERYTHING) can create new users. If you absolutely need this feature then you have...

Deploying applications with ACCESS is nearly as buggy in A-XP as in A2K. Have a look to the runtime-related articles in the ACCESS online Encyclopedia on www.unsoftwareag.com. Since my new computer was delivered with A-XP I use A-XP to develop the new applications but I stay with the A2K...

Apparently one of your references is not correctly set and thus VBA can not find the function.

Fireviking, There is only one possible explanation for this behaviour: You did not delete all rights from the standard user and admin (both users AND groups) and replaced them with custom admin and users. This is why as soon as any standard MDW is used (containing the standard admin and user...

The Windows Registry can be modified from within ACCESS by three ways: 1.) GetSetting and SetSetting give you Read/Write to a certain area of the Registry (see online help) 2.) API calls allow you full access to everything in the Registry but are a pain in the *** to program. 3.) Using the...

You might also create a "prison" form that opens automatically and gives only access to certain options and once it is closed or minimized the application quits automatically.

As far as I know Your transaction will only work with VBA, not via the properties of the query in the database window. Is your MDB file located on a web server? In this case you need to use ASP/ADO features.

Your "full permission user" will be able to change the data but not the table's structure.

Since Access2K is using UNICODE there is no problem to store chinese in a table field. But since I do not use Chinese or any other language using non-latin characters I can not help you any further. You might need to read Michael Kaplan's book on VBA's Internationalization to understand how...

I fear that the only professional solution is to activate the security system on the database.

Either you create a new table 1:1 that contains the record ID and its password or your table structure needs a supplementary field "Password". In either case you need to check via VBA before exposing any record whether it is protected or not. If so, you need a PW-checking routine...

ACCESS ONLINE ENCYCLOPEDIA ( www.unsoftwareag.com ) Article Code: G8 ACCESS and Barcodes ? Problem In many applications, such as POS or member administration, Barcodes are a great help since you can read articles with a scanner: The execution speed increases The number of errors decreases...

Have a look at the MS white paper on security and the security related articles in the ACCESS Online Encyclopedia at www.unsoftwareag.com

In general terms: 220.000 records is not a big quantity for ACCESS, I am working with tables containing more than 1.5 million records. If the MDB is working with 150.000 records this is a very good sign concerning its design so do not be afraid to accumulate their data. If you want to have...