This is great! I can't believe I didn't think of that as it's basically the exact routine I'm doing to check if a table in the backend is not in the front end, just with the loops reversed....:banghead:
Quick question - is there any way to check if the table it finds is a system table? I've...
1. People can't make any front end tables.
2. As convoluted and untrustworthy as this probably sounds, there are tables keeping track of the new tables!
3. The user never has to 'see' a table. They're not even aware they've created a table, per se - just that the object they've imported is now...
It's the TB.RefreshLink bit which takes time and which ignores the error handling.
In my routine, I already have both databases open as DAO.Database objects , and have the path freely available, so anything utilising that should be fine.
Thank you so much!
There is no error message involved - none of the forms will try to access a table that has been deleted from the backend.
It's just that the front end still thinks the table is there, which is wasted space/clutter and potential confusion if anybody were to look at the tables for some reason...
Ah - I doubt that will work. The issue in question is that the table is removed from the backend and there is still a link to the nonexistant table in the front end. Compact and repair will clean up the saved space in the backend but not delete the link in the front end.
I honestly appreciate...
The user has to import excel files as part of general usage. It necessitates creation of tables as if this were to be stored in one table, it would require several thousand fields.
Sorry! I don't mean versions in that respect - I meant different copies of the same approved edition.
It is set...
Hi,
I have an update routine which checks the backend for any new/deleted tables.
Firstly, is there a simple way to do this? i.e. make it so that any added or deleted tables will update accordingly in all versions of the front end without needing to do it programmatically?
If not, I have an...
Thank you,
I'm also aware of this - however, that would mean anybody correctly logged into their PC would be able to do what they wanted...All it does it stops one person from using another person's PC to mess about.
Damn. That's a shame. I supposed it'd be a major security flaw.
Hi,
I considered using something like this, but it feels very easy to mess about with...
Hi everybody,
I want certain functions of my database to be password protected. It's not a very high risk situation which warrants high security, it's just been decided that people shouldn't be allowed to delete things without awareness of knock on consequences etc...
Seeing as I wish to...
Hi,
I am struggling in general to deal with navigation forms at all.
How could I remotely set the active record of a navigation form via VBA?
Thanks,
Lady marmalade
Hi guys,
I have a function which is intended to return a TableDef
Function GetTable(ByVal TableCode As String) As TableDef
Dim myTable As DAO.TableDef
Dim myDB As DAO.Database
Set myDB = CurrentDb
For Each myTable In myDB.TableDefs
If myTable.Name Like...