Search results

Hi, I have noticed that on our network, certain people can open an Access db that is already open by another person, yet some cannot. We are using the same shortcut (to the mdb file) and all have the same windows read/write permissions. I can only think it is some setting in Access? Can...

I have a DB with tables where the primary key fields are autoincremented, but with formatting applied. Formatting is for example "CC"000000 so record 1 will be CC000001. (each table has a different alpha prefix) This works fine, except the database content is being read by another...

apologies for answering my own thread, and not finding the answer before I posted. I can confirm that the sticky suggesting use google rather than on-site search is worth taking notice of! With google I found this thread which has sorted me out...

Hi, I have a DB where I want text entry of the primary key to adhere to a certain format. I'm already using a mask of >LL000000 to force two capital letter and 6 numbers. Is there any way I can force extra restrictions, by making for example the first 3 characters to have to be AB1, thus making...

thanks Bob

If I have a DB with several tables containing thousands of records, and most of those records only ever need say 8 characters, does anyone know if changing the field size from default 255 chars to 8 chars will actually benefits the the DB? Potential benefits I'm thinking may occur are reduced...

Forget it sorry. I definately couldn't get it to work yesterday, but today it worked first time. Sorry guys and gals.

I have a database with existing tables. I now want to add a whole bunch of records into my access tables. A lot of the data is repeated, and lends itself to my doing it in excel with it's better copy and paste abilities, and it's ability to easily increment alphanumeric fields. I can't seem to...