Search results

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

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...

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]...

I am working on a project that uses a VB program and connects to a access database to store customer records ect. Im adapting this to a website so customers can view there repair status. how ever in order to do this i have to link tables from the access database to the MySql databse required...