Posts Tagged access

access database godaddy 500 error

A while back I moved a database from one GD hosting account to another just copy/paste and I couldn’t figure out why my code stopped working and was giving me a 500 error! It was a junior mistake it turns out. Because I copy/pasted the access_db folder with the database inside, it inheirited the permissions [...]

,

No Comments

Pull the email domain from a string VBA Access visual basic

Right([HomeEmail],Len([HomeEmail])-InStr([HomeEmail],”@”)) If the field containing the emails has and null or empty strings in it make sure you set the criteria to ” Is Not Null And Not “” ” or else you will get the error: “Data type mismatch in criteria expression.“

,

No Comments

You receive a “Type mismatch” error when you run the OpenRecordset method

http://support.microsoft.com/kb/181542 You get this error when you run vb code without having the right references set to the proper priority in Microsoft Access databases. Follow the directions from the link above to resolve the issue.

, , , , , ,

No Comments

OWA issue: View Only, cannot Reply, open attachments or delete messages

Microsoft Exchange Server 2003

VIEW ONLY in OWA.  Cannot reply, cannot open attachments, cannot delete messages. Outlook Web Access on Windows Server 2003 Standard, Exchange Server 2003 Standard While playing with SSL encryption, realized the issue was with the Front-End Exchange server and not the Back End.  Checked exchweb folders on both BE and FE and found that BE had a [...]

, , , , , , , , , , , , , , , , , , ,

No Comments

MS Access Error: The following error has occurred in procedure: on line 0 Error (3112) Record(s) cannot be read; no read permission on ‘table’.

MS Access Error: The following error has occurred in procedure: <procedure name> on line 0 Error (3112) Record(s) cannot be read; no read permission on ‘table’. This error was due to the user not being setup in the workgroup security table. You need to use the Workgroup Administrator, logged in with Admin rights and add [...]

, , , , ,

No Comments