Search results

Using MS Access 2010 'ACCDB' file type. I've been asked to encrypt the db and if it is using 'AES256'? Is this the default stanfard for 2010 and is it any stronger for 2013? Can it be changed in the Windows registry/MS Office settings?

Yes, error when only using vba. I use the Wizard and don't get any 'import errors'. It just showing the line break symbol at the end of each row (see attached snapshot). I just manually created it so have complete control at dev stage until it goes live I don't think so. Not sure what...

There are only 2-4 records in each file. The PK is a manual type (also tried auto). I've opened the CSV file in notepad and ther are no extra rows or null values. These are only test files so I can manipulate them if need be. It was working fine last week!

(Access 2010). I'm using the following vb code to import from a csv file: DoCmd.TransferText acImportDelim, strFileImportSpec, strTableNameImport, gb_strPathAndFileName Everything imports fine yet I always get the standard 'Duplicate records violation MS Access error message': 'MS Access was...

They did, as did I (as I am one of the users who is also affected).

Thanks, but that didn't solve the problem.

Recently, some users have been unable to open a shared db (un-secured) via a shortcut or direct from the file itself, yet they can if they open MS access (2003) first an THEN open the file from within. I've checked that all users have write permissions to the folder and that mdb files 'open...

Thanks Yes, it's a bit of a strange one so I won't go into too much detail, but due to a regular bulk append I end up with a lot entries (foreign language verbs) that are slightly mis-spelt after being processed and then have to go through several to correct them. This is where the 'find and...

When I use the built in 'Find and Replace' utility in a subform (datasheet view), it does the replace on multile rows but when I try and navigate to another record on the main form I keep getting an error mesage 'Operation Not Supported in Transactions' and have to close the form and all the...

These days more and more of my databases are wanting to be accessed via the web as well as from MS Acess. I guess this is the norm these days but in most of our (office) dbs it's just 'web for web's sake' and there is no real need to access it outside of Ms Access. Bu hey that's what they...

I think the end user is concerned that some emails may not get sent if one invalid one halts proceedings. I think he may be using a mixture of internal and external email addresses, but more likey one or the other. So if they were all external emails then the code would continue to excecute...

Thanks, yes it's an internal mailing system and the mail server is generating the error, although it gives the usual 'Debug, end' options. I thought their might be a way of trapping or skipping it and continuing on with the code that loops through the recordset which calls the email vb function.

We tested using an email address 'mynamexxxx@mydomain.ac.uk' Only the added 'xxxx' makes it invalid so it's not actually 'malformed'. The error message reports that the user does not exist. It says 'The server rejected one or more mail recipient addresses: 550 Unknown User'. What we can't...

I'm using CDOSYS and SMTP in a vb function to send emails via Ms Access 2003. My code loops through a recordset an sends an email to the email address in the table. However, all works fine until an invalid email address is encountered, at which point I get an 'Invalid address' error message...

Thanks tehNellie for all your help.

I'm just using a standard MS Access form and no SQL or vb code to to the INSERT. I'm just relying in the built in mechanisms which is where i'm having a problem to capture the error. I am comfortable using SQL server and TRIGGERS etc but this custom message box is only necassary for the MS...

Thanks for your help on this. The error message is not the usual 'MS Access debug' type, it's an 'ODBC Error dialog box'. The err number is 3146 'ODBC Call Failed' but it's still not trapping it. Sub example() On Error GoTo errhandle errhandle: If Err.Number = 3146 Then MsgBox...

Thanks tehNellie I'll go down the VBA route. Just having problems in the placement of the error message. At what event proc should it be placed in the form? Many Thanks

In MS Access 2003 my tables are linked via a SQL Server. I'd like to change the default long-winded 'ODBC etc etc 'error message when a duplicate PK is added to a table to a more user friendly 'plain english' message. Can this be done is Access, VBA or even on the SQL server? (which I have acces...

In all my years of developing 100s of databses I've never managed to pin down a way of creating a good interface for a 'timetable/schedule' type database. Problem has always been is the users like to use a spreadsheet style interface with multiple columns as date headings and be able to edit...