Need to use different Name.mdb in a client write up accounting package

[GeraldJ]

I have a .DOS Client Write-up accounting package that works great and has been working for ten years. I have clients who want it in Windows. Now the question...

I use the client number to name my chart of accounts. 2001ca.98 and other files that give me the flat files for that client for that year. Works great. (2001ca.98 = General Ledger for client 2001, 2001cp.98 = detail tranisactions for that client. ETC. With this method of naming the files there is no way data can get mixed between clients.

I want to use the same naming in a VB 6.0 Professional. But with my data bound record sets are bound to TheKeeper.mdb I cannot figure out how to handle multiple clients, accounting years, and other tables that are unique to a client and peioding ending and other factors that make each clients records unique to that client.

Any Help or can this be done in VB for Windows. I have it in Quick Basic now.

Thanks,

Gerald J. Robinson

 

[MisterC]

Yes, it can be done but you have several options...
How about a separate TheKeeper.mdb for each client/year? Just add an additional table that specifies the client & year.

 

[GeraldJ]

that is what I wanted to do but I do not know how to do that when client one is the current data and I want to change clients and change TheKeeper.mdb for the second client.

 

[MisterC]

Use separate directories for each client with subdirectories for each year - format your references to TheKeeper.mdb to include the directory you want. You can change directories at run time with no problems...