Recent content by AEtherson

I'm a newbie to SQL Server. I'm trying to create a database where multiple fields in a table can point to one field in a second table. I create a foreign key from Field1 in Table1 to Field1 in Table2. I then try to create a Foreign Key from Field2 in Table1 to Field1 in Table2. It won't let me...

What is the error message? just guess work without it

True true. A better way still would be close the connection if it is doing nothing for 5 mins

if Conn.state <> adstateopen then set conn = nothing reopen connection end if hope it helps

thanks alot

Hi All, Just a quick question. I have a data file that is over 2GB and I need a file size reading. below is my current code Meth1 unsigned long GetFileLength ( FILE * fileName) { unsigned long pos = ftell(fileName); unsigned long len = 0; fseek ( fileName, 0L, SEEK_END...

Option Explicit Const ERROR_SUCCESS = 0 Const ERROR_MORE_DATA = 234 Const SV_TYPE_SERVER = &H2 Const SIZE_SI_101 = 24 Private Type SERVER_INFO_101 dwPlatformId As Long lpszServerName As Long dwVersionMajor As Long dwVersionMinor As Long dwType As Long lpszComment As Long End Type...

sorry Used same as johnwm

i get 424 KB (434,176 bytes)

try downgrading mdac to 2.5 and making sure u do not have a circular refrence IE you make a change then the bound control does a change and so on Failing that you will have to post your code so we can look at it for you

what circumstances does it crash??

try upgrading mdac also check your refs and mack sure that one does not say missing

you have a provblem with a refrence to a c dll. A virtual function is a pointer to function in a class

upgrade to dao 3.6 Try using service packing vb as there was a problem with the prev version.

just user pure SQL to do the look up, It will be much faster