ADOX (also know by its full name: "Microsoft ADO Extensions for DDL and Security") is an extension to ADO and allows you to create and modify database schemas, as well as apply security to your database objects.
If you try out these files, put them in the same folder.
Excel code in Module1: This solution was initially tested on a Windows 7 PC.
You can take a look at the complete code by following this link.
Once the page is finished loading, you can see the new database in the folder you specified in all its glory.
I ran it on another PC with Windows XP and got and error when setting the Access security level.
Assuming you are using one of these operating systems, the Excel Module1 replacement code below should eliminate this error.
I have it set up to edit, everything seems to be working, except the update doesn't work. If this is a network share issue, I cannot comment on it, having not worked over a network with Expression.
I click the edit link that it generates, I change the field value and hit update and the value stays the same. Where do I look to troubleshoot something like this? Is this a single or multiple table Access database?
Is the primary key properly represented in the update query?
hmm, well I'm not sure about this because I dont set things up quite the way you do.
my_photo.jpg) and get some sort of link to display it on the results page? Create a form using VWD (so I can use some of the nifty controls there) 2.