Can Opus create a table within MS Access and name it?

Matra · **Posted:** May 14th, 2015, 7:32 am

I am writting a publication, and need to know if it is possible for Opus to create tables within MS Access and rename the table to the User's name.

Lar_123 · **Posted:** June 5th, 2015, 3:22 am

I think the basic answer is 'yes'. I have not worked with Access, but in working with an SQL database, ( IIRC ) if you do a SQL write operation to the DB and specify a table that does not already exist, the Table is created.

It should be fairly simple for you to just test out that approach on MS Access. It's been some time since I've played with database stuff, but it's worth a try.

Matra · **Posted:** June 5th, 2015, 8:16 am

Lar 123,

I eventually got the right code, the problem was with my DSN.

Thank you for your help and time.

Matra · **Posted:** June 5th, 2015, 2:31 pm

I need your help again haha..

I am trying to create a table with the users name and idnumber as the name of the table, the code works fine except when the user's name got a space somewhere then no table will be created in MSACCESS (I don't know why), do do you know the solution to this problem, or how can I force the "loginuser" to leave out all the spaces or be replaced by a underscore

Code:

var myDB = new Database("FILEDSN=C:\\Backup\\CBT\\Published\\J281 Ross Operators\\Data\\database.dsn");
myDB.ExecuteSQL("CREATE TABLE " + loginuser + "_" + loginidnumber + "  (street varchar(15))");

Please help.

mackavi · **Posted:** June 5th, 2015, 4:07 pm

Your can change the Opus input box properties to prevent special characters or you can use loginname.split(" ").join("_") to replace spaces with underscores.

</mack>

Matra · **Posted:** June 8th, 2015, 8:14 am

Hi Mack,

Your "split and join" to replace spaces worked, thank you very much, apologies but still a beginner.

mackavi · **Posted:** June 8th, 2015, 9:00 am

We're all beginners at something :-)

</mack>

Digital Workshop

Can Opus create a table within MS Access and name it?

Who is online