Search results

Hi All Thank you for your help the problem was caused by ports blocked by the ISP. I got the pointers from the thread with a summary below <cant attach a link unfortunately> The summary solution from the link above is as below; Windows Azure SQL Database (formerly known as SQL Azure) works...

I found a way around this... 1. i created last updated by field on all key tables 2.When creating a new record i sent the logged in user 3. when record is updated i save the last person to update it. 4. on the delete action bar i first update the last updated by field 5. then on the data macros...

Hi David I am still plagued by the problem. To do some elimination of possible causes, i took one off the PC off the Local Area Network(LAN) and connected to the Internet through a mobile 3G connection. I set up an ODBC connection to the SQL Azure database it worked fine. I put back the computer...

Thanks David. Yes I do have SQL Native client installed on all the computers... The connection string is exactly the same as it appears on my computer as I am simply copying the same ms access file and redistribute... Wondering if because they are inside a network and possibly they are trying to...

Hi David I am using link tables generated by microsoft access automatically when you create an acces database from report on my data option in the back stage of ms access 2013. I think they are called DNS Less ODBC connections? when pointing to the link table it shows as attached image.

I have an access 2013 web app where i implemented audit trail to track changes and deletes and inserts on key tables. I am using the table level data Macro. On Insert, On delete and On Update. How do i grab the sharepoint user deleting or inserting the data. I notice that userDisplayName()...

I have an ms access 2013 web database on office 365. I created a reporting ms access database and build reports for distribution to client PC. the database works fine for computers that are not inside the my client's local area network but gives connection failed when connecting using the...