Temporarily close down bound objects in table

[hgus393]

Hi all,

Is it possible to temporarily close down bound objects in table as I need to change the data type for a column? SQL Alter will no work, opening the table in design view does not work either..

Cheers

Rob

 

[boblarson]

1. Is this a split database (frontend/backend)

2. What datatype are you changing FROM and what you want to change it TO?

3. For table changes you need exclusive access to the database where the table resides. That means that everyone will need to be out of the database in order for you to make the changes.

 

[hgus393]

My own database (exclusive), changing from text to double. However I have a startform which has several subforms which have the table a control source...

1. Is this a split database (frontend/backend)

2. What datatype are you changing FROM and what you want to change it TO?

3. For table changes you need exclusive access to the database where the table resides. That means that everyone will need to be out of the database in order for you to make the changes.

 

[boblarson]

Just hold the shift key down when starting the database so nothing opens up.

 

[hgus393]

Just hold the shift key down when starting the database so nothing opens up.

Of course ....Cheers mate!!

//Rob