Create a Log for Database modifications...

[darno]

Hi Friends,

I was wondering if there was a way to log all the modifications made to a database in a table with user name and time of modification. I have been searching this for quite a long time but no use. Please help if you know the solution.


Warm Regards,


Darno

 

[RuralGuy]

It is called an Audit Trail. Here's one example:

http://allenbrowne.com/AppAudit.html
Creating an Audit Log

I suspect if you search this forum you will find other examples.

 

[ghudson]

I have been searching this for quite a long time but no use. Please help if you know the solution.

You are kidding, right? This thread only has @ 7,000 views... Audit Trail

 

[darno]

You are kidding, right? This thread only has @ 7,000 views... Audit Trail

Thanks alot Mr. GHUDSON, you made my day, Cheers to you and to all wonderful human beings on earth who love helping newbies like me. I am thankful to you whole heartedly for providing such a great help. Thanks again.

by the way do you know an automated way to import tables data to another database tables. both the databases have same fields. Thanks again

 

[ScottGem]

by the way do you know an automated way to import tables data to another database tables. both the databases have same fields. Thanks again

Why would you want to? The advantage of relational databases is that you don't duplicate data. There are very few valid reasons to move or copy records from one table to another.

 

[darno]

Import Data

Why would you want to? The advantage of relational databases is that you don't duplicate data. There are very few valid reasons to move or copy records from one table to another.

I am working on modification of my old database. there aren't many changes in the new database as such, but i still need the old database data to be imported into the new database tables for trial and testing purpose and the new database has got same tables with same names except few addition of fields in the new database. Hope this will clear the air.


Warm Regards,


Darno

 

[ScottGem]

Ok, if I follow you, you are creating a new app that will include new tables and will replace the old app eventually. And you just need to copy records for testing. In that case, link to the old tables and run an Append query.

 

[darno]

Importing Records from Tables

Thanks Scottgem,

Your advise was helpful, but still i have a big question mark on this issue of importing records from tables. I think till now there is no one who have figured out a way to import records but not the whole table to another database without linking or creating another table to the database. I am positive that there must be a VB guru who could fetch the records from an old database and put them in the new database. Sure there must be someone out there.

Anyways, i appreciate your help and follow up it helped me alot. Thanks again.


Warm regards


Darno

 

[neileg]

Don't double post. Your question about importing tables has already been answered. Just link or import the old table, append the data to your new table, then delete the link or delete the imported table. You don't need custom VBA code to do simple taks like this.

 

[ScottGem]

Thanks Scottgem,
I think till now there is no one who have figured out a way to import records but not the whole table to another database without linking or creating another table to the database. I am positive that there must be a VB guru who could fetch the records from an old database and put them in the new database. Darno

You are correct that no one has figured out a way... But you are incorrect that some VB guru could do it.

The fact of the matter is that before VBA can be used to access records in a table, that table has to be connected to. You can use an IN clause in SQL to create a temporary connection by referencing the table and MDB file. But I think that will work only with Access tables, not other types of data.

My question is why are you trying to shoehorn this? To import only some records you have you create a query to filter the records. To do that you need to establish a connection to the table. End of story.