list all tables/cols of access DB ?

[Smoerble]

hi all !
i need to know how to code the follwing thing in ASP/vbScript, hopefully someone can help...



open access file '--- i know this
"Select All TABLES"
loop through all TABLES
"Select All Columns That Belongs To Current Table"
loop through all columns
if (currentColumn is Striong or Memo-Field) then
dummyString = currentColumn(columnName)
dummyString = Replace(dummyString, oldIP, newIP)
call updateColumn(...) ' --- i know how to do this if i know
how the things above would work
end if
loop
loop

 

[Smoerble]

ok, i found an example (german only) but it doesn't work, it says i have no right to read the 'MSysObjects'. any suggestions ?
the german tutorial you find here:

http://www.aspfaq.de/index.asp?FID=55&ELE=4789

 

[cmmrfrds]

Are you logged into access as admin or are you in the admins group? You probably need to be one of these to have the permissions.