Create New Back End table

[jimmyspinner]

Hi there,

Please help, I've trawled this site and others in an attempt to find some code to create a table in my database without success. The database is already split and therefore needs to be created in the back end and would happen when the user logs in for the first time to the front end.

The database is already out there and being used. I've seen examples of the TransferDatabase which I would add to the code on the login script but is there another way to do this? Or am I clutching at straws and should just use the TransferDatabase function.

Thanks in advance for your comments/help

Cheers

Dave aka Jimmyspinner

 

[SOS]

Bob Larson has a Backend Auto Updater that might be useful in this case. You can add tables with it.

 

[gemma-the-husky]

but note it is far from easy to create tables, and manipulate their properties in code - especially something like the relationships window. Note that the back end may be in a different Access version, which may prevent some actions altogether.

Maybe an easier way is to create the table in the front end, export it to the back end, delete the original table, and then relink the back end

 

[jimmyspinner]

Sorry for the late reply and thanks both for your suggestions. Decided to go with Dave's suggestion and have made some good progress with this now.

Cheers

Dave (Jimmyspinner)

 

[SOS]

Maybe an easier way is to create the table in the front end, export it to the back end, delete the original table, and then relink the back end

Actually, the relationships should be defined in the BACKend and not the frontend.