HI
We have a database over Citrix on Company's virtual drive with limited admin permission for Access 2003 version...
it have 37000 records and 90 columns
It's a Split database - backend and frontend.
it's a multi-user database
We don't have any SQL or any kind or server to store backend, its basically normal jet 4 engine based database.
We don't even have command prompt on virtual drive so cant even debug/decompile the database via that route.
Issue is backend table "Main" gets deleted sometimes when accessed from frontend.
I have audit trial function built but its not showing why its been deleted.
I don't have any other way to get to know what is triggering the table deletion in backend.
Can anyone help me with the solution or suggestion, I need to apply to my database ...
Also, any known issue or bug -if you know - let me know how to fix it or get a workaround of it...
Any help will be appreciated..
Manythanks,
Guddu...
We have a database over Citrix on Company's virtual drive with limited admin permission for Access 2003 version...
it have 37000 records and 90 columns
It's a Split database - backend and frontend.
it's a multi-user database
We don't have any SQL or any kind or server to store backend, its basically normal jet 4 engine based database.
We don't even have command prompt on virtual drive so cant even debug/decompile the database via that route.
Issue is backend table "Main" gets deleted sometimes when accessed from frontend.
I have audit trial function built but its not showing why its been deleted.
I don't have any other way to get to know what is triggering the table deletion in backend.
Can anyone help me with the solution or suggestion, I need to apply to my database ...
Also, any known issue or bug -if you know - let me know how to fix it or get a workaround of it...
Any help will be appreciated..
Manythanks,
Guddu...