How to open/connect to a ms access DB
Posted on 2006-11-29
I'm looking for the script to open a Access DB from a proceedure in sql. Then I need to create a recordset object and be able to refer records in that object. here's the suedo code
create recordset based on a customer name
If the name doesn't exist in AccDB then create new record
I'm new to SQL scripting coming from a VB and C# background so my methods differ from sql scripting.
any code examples??