[chrismogz]

Having a little problem naming my table which i create with the cobe below. want name it with the value of the string DbId, but tried using
'"+DbId+"' but that does not work. any idea's ? cheers for ur time



string DbId;
UserProfile objUserProfile2 = new UserProfile();
DbId = objUserProfile2.GetUsersDb();


DBConn.OleDbConns objConn = new DBConn.OleDbConns();
OleDbConnection objOleDbConn = objConn.OpenReadConn();

[cristobal03]

The string concatenation operator is the ampersand (&). That should be

"'" & DbId & "'"

HTH

chris.

[cristobal03]

[bump]

Welcome to TSG by the way

chris.

[cristobal03]

[bump 2]

Actually, I assumed you're using VB/VBA. What language are you developing?

chris.