var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is is possible to write Script in Access ?
Suppose I want to insert 10 records in an Access table. Is it possible to write script for that? I know it is possible to write a query for that. But do I need to write 10 queries for 10 records?
"Scripting" in Access is accomplished with macros, or VBA code.
You may be able to write code that loops 10 times to insert your 10 records.
Hope this helps,
You can use that
To run a Query, it is the good way to do it because Access Security will prevent anyone that don't have the right to insert datas to run the query.
You can also do
But since it is not a Microsoft Access object, security right will do nothing to prevent someone to insert these datas
CurrentDb.Execute "INSERT INTO Table1 VALUES(111,'aaa')"
JefB - hope it helps
I figured out following way.
Store the SQL statements in a file or table.
Write a function using DoCmd.RunSQL or CurrentDb.Execute which will execute all the SQL strings found in the file/table.