Building an Database in CODE using ADO 1

[Monguse]

I have a program the use's an Access database and it prints infromation from tables that were made only forit to print from. Program stores data in a 'print table' and in another table as well. My problem is that only one user can be in the program printing (The database is on a server) if multi-users try to print is prints items it should not be printing.

Anyway it was suggested by a friend to have the program (which is installed on each workstation) creat a DB and table to print from 'on the fly' only problem I have no idea how to do this and as yet have not found anything in books to help. Can someone here help with this or suggest a better way?

Thanks

 

[Foada]

Search MSDN for ADOX. There are several Samples on how to create a DB and tables from code. Hope this is what you are looking for, Good luck. Anything is possible, the problem is I only have one lifetime.

 

[HermanvLimbeek]

faq222-1422 should give you a start.

Herman :-Q

 

[Monguse]

Thanks for the help this solved my problem.