Recent content by John.Woody

You could create a bat file to copy the db running it every hour or half hour (incorporate date and time to make the file name unique), then you could copy the latest good copy back when the corruption occurs. Sent from my iPhone using Tapatalk

Not sure, but could Sec be a reserved word? John.woody

RD client from Microsoft on IOS should do what you want.

You can attach your MySQL tables to an access database and create your front end in Access, however I think most people would use php to create web pages and build an app to work via a web browser.

John To start with you haven't closed any of your paranthasis. It should start with something like $id = isset($_POST['id'] : $_POST['id']) : null; $date = isset($_POST['date'] : $_POST['date']) : null; and carry on with the rest. hth

Presumably your copying your db from 1 PC to another. In this case the db might be "blocked" by Windows. If you view the properties on the file in My Computer there may be a button that says "Unblock " if so click the button. Your db should work then.

Can you connect a local access db to your MySQL db? It can be. Done using ODBC driver, but your MySQL host may block the connection with their firewall. If you can then you could append data from access directly into MySQL.

You could try creating a new db in access 2013, then get a fresh copy of the db and import all of the objects, then check all needed references are there and compile the code, and see if that works.

Maybe you could dump your MySQL db in to a sql file and load in on to the server that works with the other db, make the appropriate location changes in your code and see if it works. It will rule in or out a server related issue.

Could it be a firewall blocking the connection, or router config port forwarding to the server?

Very narrow minded. She has done a tour of duty to help save others. At the end of the tour she's entitled to come home and followed procedure laid down by the government. Now she's fighting for her life she should have our support and good wishes rather than a stupid self centred rant from you.

Check out the workaround on this page. It's worked for me in the past. http://support.microsoft.com/kb/303650 Hth

Yes, the runtime package gets installed including A2010, and my db, I have taken to installing in a folder directly off the C drive on Win7 PCs to get round limited folder permissions. The first time the db is started I get a msgbox re trusted issue, I continue to load the db, run code to attach...

You can use a vba function to add a trusted location. Can't remember where I found this, but it works for me in 2010. After installing the package the first time I open the db I get a trust message, then run the function and it adds the location as trusted. Public Function AddTrustedLocation()...

A 2003 .mdb can not read data from 2007 .accdb so you need to look at your tables and find out what fields are stopping you from converting it to an mdb and see if you can change the fields to a compatible format.