Database and Tabels

[BundaZSZ]

i have 26 tabels in a DB

now when i want to acces a tabel VFP's coming with a message :

"Can not open tha tabel" or "Can not acces tha tabel" something like that with an OK button
After i press the OK button the tabel is working and everything is just at is have to be

in the halp at this error wrote that i am running out of 32K of, i dont remember

What sould i do over this

Thank you for your support and help until now and from now on

 

[BPeisch]

Have you opened the DBC before trying to open the table? Is it the current database, if you are dealing with multiple databases opened at the same time?

Or is the error "Cannot access the selected table"? If so, that indicates a problem with a combo or listbox where you've closed the RowSource while the combo or listbox is still there.



-BP

http://www.peisch.com

 

[jimoo]

It sounds like the table is already in another work area or exclusively.

Try this:

IF USED('myTable')
SELECT myTable
ELSE
SELECT 0
USE myTable
ENDIF



Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com