Create a new database

[duvenhlc]

I am using a split database, I have a table to create new datasets. My question is it posible to create a new "database" for each new dataset. For instance, I want to add a new customer, and then create a new backend database for each customer outomatically.

 

[jdraw]

My question is it posible to create a new "database" for each new dataset.

I'm sure it's possible, but my question is "Why?"

Perhaps you could explain what it is you're trying to do, and you'll get some alternative solutions.

Good luck.

 

[JamesMcS]

It does seem like a lot of work when one or a few tables would do the same job...

 

[duvenhlc]

I know it does not make sence, but the story is. I will be storing pictures in this databse. The database currently stores only the link and do not imbed the pictures. The problem with this is that if you put this database on a network, do you get problems when all the PC allowcate differetn drive numbers to the server. The other problem is that access is limited in capacity, the pictures use this capacity in no time.

So this is my story any advice or suggestions, that why I was thinking of creating background database files.

 

[JamesMcS]

You could always store the network path rather than the mapped drive location, e.g. \\computername\foldername rather than f:\foldername

 

[Rabbie]

I know it does not make sence, but the story is. I will be storing pictures in this databse. The database currently stores only the link and do not imbed the pictures. The problem with this is that if you put this database on a network, do you get problems when all the PC allowcate differetn drive numbers to the server. The other problem is that access is limited in capacity, the pictures use this capacity in no time.

So this is my story any advice or suggestions, that why I was thinking of creating background database files.

Thats why it is always reccomended to store pictures outside your DB and just store the path to the picture in the DB. This helps to prevent bloat