Re: Access Plugins

2006-12-07 Thread Mikey
http://www.download.com/XML-2-MDB/3000-2210_4-10447327.html The way I populate an empty database is to construct the sql commands and save them as a text file, then execute the file. How are you going to do that without having Access installed? -- On the first day, God created the heavens and

Re: Access Plugins

2006-12-07 Thread Mark Wieder
Mikey- Wednesday, December 6, 2006, 11:46:58 AM, you wrote: > Well, a couple of things hre, > 1) the plane-disaster only supports access97, so that's a bit of a problem. > 2) Someone sent me a link to an application called xml-2-mdb, which > solves the database creation problem. > Now if I can

Re: Access Plugins

2006-12-06 Thread Mikey
Well, a couple of things hre, 1) the plane-disaster only supports access97, so that's a bit of a problem. 2) Someone sent me a link to an application called xml-2-mdb, which solves the database creation problem. Now if I can just populate the tables I'm set, other than talking to the piece of ha

Re: Access Plugins

2006-12-06 Thread Mark Wieder
Viktoras- Wednesday, December 6, 2006, 2:11:34 AM, you wrote: > Although I have never tried creating new database or defining schema with > this, but maybe it can be useful in this regard too... Rev studio has open IIRC the Access driver doesn't support the "CREATE DATABASE" sql command. -- -

Re: Access Plugins

2006-12-06 Thread Luis
Don't know if this might be useful (calling it from Rev): http://sourceforge.net/projects/plane-disaster/ Can create new files, you can then zip them up with Rev. From the description: 'PlaneDisaster.NET is a .NET Database front end for JetSQL (Microsoft Access File Format) and sqLite. In addi

Re: Access Plugins

2006-12-06 Thread Viktoras Didziulis
try communicating with Access driver through js or vbs script. In both js and vbs there is a way to build a dsn-less connections to nearly any type of relational database. A while ago I worked with this from within hta apps, but now went multiplatform with Rev and start forgetting those things... F

Re: Access Plugins

2006-12-05 Thread Scott Kane
I'd love to be able to do this one in RR, because there will be a significant amount of parsing, and chunk expressions are SO perfect for that. One possibility is to generate a DLL (if this is on Windows) that has the Jet Engine interface built into it. I'm not knowledgeable about building

Re: Access Plugins

2006-12-05 Thread Mark Wieder
Mikey- Tuesday, December 5, 2006, 11:08:45 AM, you wrote: > All, > I have a really interesting project that I'm going to be starting here > shortly, but it has a problem - I need to be able to generate Access > database files as output (and then zip them). > I'd love to be able to do this one in

Re: Access Plugins

2006-12-05 Thread Bill
It would be nice if there was a way to convert access databases to SQLite. On 12/5/06 3:57 PM, "Mikey" <[EMAIL PROTECTED]> wrote: > Unfortunately that isn't a solution. This is going to be a project > that is going to replace an embedded Access database, so access to > Access is negatory.

Re: Access Plugins

2006-12-05 Thread Mikey
Unfortunately that isn't a solution. This is going to be a project that is going to replace an embedded Access database, so access to Access is negatory. -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on

Re: Access Plugins

2006-12-05 Thread Jan Schenkel
ution Sent: Tuesday, December 5, 2006 8:08:45 PM Subject: Access Plugins All, I have a really interesting project that I'm going to be starting here shortly, but it has a problem - I need to be able to generate Access database files as output (and then zip them). I'd love to be able to

Access Plugins

2006-12-05 Thread Mikey
All, I have a really interesting project that I'm going to be starting here shortly, but it has a problem - I need to be able to generate Access database files as output (and then zip them). I'd love to be able to do this one in RR, because there will be a significant amount of parsing, and chunk