each web online user connect with there own acces

Question

in my project, when a new user register online on my website, then my project create a directory on server with the user name "abc" and copy a myDB.mdb file in it.

this .mdb file contains predefined 2 tables.

now my question is :

1 is it possible to connect and use with Dataset.xsd in this task.

2 how each user read and write data with there own myDB.mdb file

3 how to make the connection string flexible. so it ll connect with each user myDB.mdb file.

I don't have any clue that how to complete it. i worked with dataset.xsd and vb asp.net but those were static dataset.xsd or predefined .xsd

JS

Answer 1

Oh, please don't do this. You really, really, really need to avoid this approach at all possible costs.

I strongly suggest that you install the free SQL Server Express, or MySQL, or any other multi-user database and store your data in there instead.

Doing this will preserve your sanity both when creating the initial implementation and when you have to update a column or a table in all of the MDBs that have been created for your end users.