Add User To MDW by VBA

  • Thread starter Thread starter Leo
  • Start date Start date
L

Leo

Hi Guys! I need to write users in a file .MDW using VBA
and bringing data from a table. I've already tried to make
myself using wrkspaces and createdb instruction but system
gives me error 3390 account already existing. I'm sure the
user account isn't in .MDW file that I've rapaired and
compacted to be sure no one (only administrator) are in
the MDW. Someone have an Idea ? Thank You !
 
Thank You Joan ...
is not enough... pls see the post "Adding User in MDW" to
better understand what I need.

Thank You again.
 
Leo, Joan may not have time to search for your other post, or it could have
disappeared from her newsserver. It's always best to make your questions
"self contained", and not refer to other posts.

Here's what you said in the other post:

"I need to add users in an MDW file bringing their data
from a Table in a SQL Server. I've an ADP (ADE) file
connected to a SQL Server and I need to distribute a
single file .MDW to all Users which have a "Peripherical"
Mdb (mde) Application file. So, I need to use ADOX and DAO
simultaneously to take data from ADOX and write whith DAO
in .MDW file.
Microsoft talk about unusable functions based
on "DBENGINE.SYSTEMDB"...
Someones have a different solution or other Idea ?"

Personally, I don't really understand what you are asking for here. I
suspect that no-one else does, either! That is probably why you did not
receive any replies.

Please give an actual example of the data coming from SQL Server, & a clear
description of what you want to do with that data, & where the MDW file
comes into it!

HTH,
TC
 
Ok TC.
I Understand. Thank You.


-----Original Message-----
Leo, Joan may not have time to search for your other post, or it could have
disappeared from her newsserver. It's always best to make your questions
"self contained", and not refer to other posts.

Here's what you said in the other post:

"I need to add users in an MDW file bringing their data
from a Table in a SQL Server. I've an ADP (ADE) file
connected to a SQL Server and I need to distribute a
single file .MDW to all Users which have a "Peripherical"
Mdb (mde) Application file. So, I need to use ADOX and DAO
simultaneously to take data from ADOX and write whith DAO
in .MDW file.
Microsoft talk about unusable functions based
on "DBENGINE.SYSTEMDB"...
Someones have a different solution or other Idea ?"

Personally, I don't really understand what you are asking for here. I
suspect that no-one else does, either! That is probably why you did not
receive any replies.

Please give an actual example of the data coming from SQL Server, & a clear
description of what you want to do with that data, & where the MDW file
comes into it!

HTH,
TC





.
Click to expand...
 
Leo said:
Hi Guys! I need to write users in a file .MDW using VBA fsd
and bringing data from a table. I've already tried to make
myself using wrkspaces and createdb instruction but system
gives me error 3390 account already existing. I'm sure the
user account isn't in .MDW file that I've rapaired and
compacted to be sure no one (only administrator) are in
the MDW. Someone have an Idea ? Thank You !
Click to expand...
 
Do you mean that you want to create a new user in the current Workgroup file
using VBA? If so, check out the CreateUser function in online help.

HTH,
TC
 
Back
Top