want to prompt user to open an access database from a server location

[DSMarcinko]

Does anyone have a simple example of a user prompt database access VI.

I want to have the user prompted to designate the database file from a server location. The server location will change for each user pc configuration.

[unclebump]

Try the file dialog function.

[DSMarcinko]

Not exactly what I was looking for.

I know how to use the file open dialog function, I just don't have any experience with the database access tools and was hoping for an example of opening a database using these tools. My ultimate goal is to open the database extract the message table and utilize this data in another vi to decode and save the table in text format. Do you have any examples that perform these functions? I'll eventually figure it out, but wanted to avoid the trial and error method if something is readily available.

Thanks for the reply

[Will.D]

Are you using the Database connectivity toolkit?

[DSMarcinko]

Yes, I have the toolkit.

I need to dynamically create the datalink to a MSAccess (.mdb) database on a server.

Thanks for the reply

[Will.D]

That I'm not so sure about.  Is there a finite and definitive list of all the databases that need to be accounted for?  Is it possible that you could create an array containing the paths to all the necessary udl files, and when the user selects a database, you pull the appropriate link from your array?

There may be a better way to do this (with .net I'm sure it could work), but this is the most readily apparent to me...

[dan_u]

Hi Jdam

This is possible, I had to do exactly the same some time ago. I attached a VI which basically dynamically creates UDL data connection string and inputs it to a subVI of DB Tools Open Connection.
You can provide a local path or a network path to the attached VI.

[DSMarcinko]

Thank you.

I modified my open dialog path to string and was able to make the connection.

Now I can work on pulling the message table data out and saving as a spreadsheet.