Transfer confirmation

[border20]

Hi ! I have a access program that transfers tables from a Handheld PC to some access tables... but the transfer sometimes fails so I need an easy way of confirming that the transfer went well.

Anyone have any idea how i would do this ?
like is there a way to see when a table was last modified ?

 

[IMO]

Could you use a Date field in your table with the Default Value set to =Now() ? This way anthing added to the table will always have the date it was added next to it.

IMO

 

[border20]

would that be effective with modified reccords ?? would the now value change when a field in the reccord was changed »?

 

[IMO]

For modified records you'll be best to look up 'Dirty' in Access Help. The Now() will only work with new data entered or imported.

IMO

 

[Mile-O]

like is there a way to see when a table was last modified ?

Dim rs as Recordset
Set rs = CurrentDb.OpenRecordset("SELECT * FROM MSysObjects WHERE Name = 'YourTableNameHere';")
Msgbox rs.Fields("DateUpdate")

Something along those lines should give you the information for the table you wish to check the last updated details for.

To see the table MSysObjects, go to the options and select show system objects.

 

[border20]

the folliwing line gives me an error:

Set rs = CurrentDb.OpenRecordset("SELECT * FROM MSysObjects WHERE Name = 'YourTableNameHere';")
says incompatible type

 

[Mile-O]

Strange, I just tested it in a quick module and it worked fine for me.

I am using Access '97, so it may just be a question of syntax for a greater version.


NB - You did change the "YourTableNameHere" part of the code, didn't you?

 

[border20]

of course

I have access 2000,,, i'll try to see if there is any difference un syntax for that line.