Recent content by Rolly189

Locking record is definitely a pdf - and it was someone had chage the "open with" Thanks

Hi I have inherited a number of 2007 Access databases that have a PDF (Adobe Acrobat Document) as the file type for the locking record. These databases seem significantly slower, and have more frequent "Not Responding" periods on the network - especially when compared to those with a...

thanks - will check my our IT guys and ensure SP's are up to date

Mark Unfortunately I am unable to post the current DB - I will try and copy (change the names etc) to a new database - and hopefully this issue will keep occuring. Happy to share that with you. RecordID Data Type - AutoNumber, Field Size - Long Interger, New Values Increment, Indexed - Yes...

Thanks Mark - only tried that to fix the problem (so will cease!). But the problem still exists - the autonumber will correctly append new records but after a update is done it will try and reallocate a used number (usually aroung 336)

Hi All - some help if possible Using Access 2007 I have a table where the RecordID is an autonumber, and PK. To set this table up I have a load routine, (becuase I have done this multiple times for testing and further deveopment and I compact and repair the DB prior to loading) - the 690...

Hi All - some help if possible Using Access 2007 I have a table where the RecordID is an autonumber, and PK. To set this table up I have a load routine, (becuase I have done this multiple times for testing and further deveopment and I compact and repair the DB prior to loading) - the 690...

When opening a 2007 Access Databse a locking record is created in the folder alongside the database file - normally this is has a .ldb suffix (Access Record - Locking Information). In the current database I am working on this locking record is laccdb suffix (and is a Adobe Acrobat Document...

Sorry - I don't understand that - can you please answer in simple detail and if possible the other parts of the question. Thanks for responding Ian

I am modifying a Access 2007 database and notice the locking record is a PDF. Can someone advise why this would be the case, any benefits (risks) in having this and if reverting to the standard Access locking record is preferable (how is this done) Many Thanks Ian

Compact and repair seems to have fixed - thanks for your thoughts

Kiwi - definitely Had a great summer (drought over most of country) but a real cold snap at the moment - lots of snow for those that like it cold

Thanks for your efforts from accros the ditch. Will do as you suggest asap. Thanks again

Hi Agian - Access 2007 - and as I mentioned in original message "no Format, Validation, Compression, IME and only Plain Text. Tried the new field - with the same result - test data was cut and pasted from Word (not Excel) Thanks

As stated above - this is directly into the field on the table