Search results for query: *

In VB there are controls for Directory and file list boxes Is there anything in Access 2000 that is similar or am I forced to create my own or use the commdlg? the purpose will be to allow users to select multiple files accross several directories for importing into the database

Your connection string is wrong you need to specify server:=**** you can also do another syntax where you specify a driver as well - search on vb developers rather than access and look around ado connection objects or odbcconstr

The sql statement because it is a straight execute against database rather than an object.

I think your problem is you need a central mdw file on the server - This tells acces who has rights - each user would then need a shortcut that starts access and points to the Mdw file for security If your using 2000 use the Security wizard to play with these files. Although they need access to...

Basically - I had this Idea of storing predefined chart objects as an ole object within a table - then writing a function that would retreive the relevant Ole object from the table, where I could then adjust the data it's using in code and then use it on a report or save it back to the table...