Recent content by jrsl

All the data was lost in the result.

But would you think that DbSync could have done it? or more likely somebody has been messing around? Cheers, Justin

No the program would not do that if not called for. Also DbSync is connected to sync data from access to mysql. This is a one way street though. Since it has been connected it has not been syncing data (task scheduler not run yet). The only other i can think of is if somebody cut/paste the mdb...

The database has been used for a long time without this happening before. The access file is never accessed directly, a program reads it but office access is never opened. Is it possible that a disk clean up was run randomly and compressed it?

Does anybody know why an access database would delete itself? The database file was 170mb and it is now about 10mb.. why did it drop all of the records in an instant? I'm clueless. Any explanation would be great. Justin

Thanks for the reply, I will need to update that table based on the data in the other database, as this will be done automatically with a macro. I think my code will work but i just don't know how to specify the database url in the update query correctly. I have the same thing to append data...

Nice work john

You will have to read the database with either php or asp. I would hit google for some simple connection strings and then copy/paste your sql queries into the php/asp script to mimic your program. From my experience there are more php tutorials. type (connect to access database with php)...

You could select each one like this: SELECT RecordEntryT.RecordNumber, RecordEntryT.Date, RecordEntryT.Month, RecordEntryT.MediaTitle, RecordEntryT.Audience, RecordEntryT.[Business advice and information], RecordEntryT.[To become the one govt site for all businesses], RecordEntryT.[Helps...

hi, I'm trying to update a table in a database based on the info from the same table in another access database. here is what i have so far with no success. UPDATE jobs_web SET StatusCNTR = 'C:\Users\Justin\AppData\Local\VirtualStore\Program Files...

Hi all, I have created a .bat file to open my database run a macro and then close. This works file however another program uses this database useing the jet engine and a password is set. The password is not from the users and passwords section it is the database password "set database...

it wont run as a batch file like that. The batch file runs fine when i double click it (previous way) but it wont run through scheduled tasks. it says it run fine but it never opened the database and my macro didnt run. Justin

It suggested to use a .bat file with this code: C: CD\Program Files\Microsoft Office\Office Msaccess.exe C:\Northwind.mdb /x Macro1 (related to mine of course) It didn't work with access 2007 and vista, however i managed to use this code: START MSACCESS.exe...

I have a macro that i want to run every five minutes so i have made a scheduled task. the string is: "C:\Users\Justin\AppData\Local\VirtualStore\Program Files (x86)\PaperWRX\Data\pwEssentials.mdb - Shortcut" "/x ApendCustMacro" Which runs perfect from the run (start menu) but i get errors from...

Hi im new to Access and VB. Im having trouble with appending a table to another access database table. With my code im trying to make it only update new records. Here is what i have: Sub AppendMacro() With DoCmd .SetWarnings False .RunSQL "INSERT INTO Customers1 ( [CNTR]...