I had a split database that I wanted to do some structural work on so I made a copy for testing and converted the tables to local tables (Right click -> convert to local table) to help me keep from breaking anything too permanently. The changes ended up taking longer then I expected them to and out of laziness I did some data entry in the "test database" figuring that I would just split the database again later and everything would be ok.
So up until this morning I was thinking that I had an out dated front end, an outdated back end, and the new test database which I had been working on that contained all of my current tables, queries, forms, reports and vba in one application. Upon archiving my outdated back end and front end databases I discovered that my new test database (which i was about to deploy for live use) would no longer open. When I attempted to open it, it acted as if I'd opened access without specifying a database. So I restored the back end to it's previous location and I was again able to open the new database.
- I've checked and double checked the linked table manager, it doesn't show any linked tables to my out dated backend database.
- I've made a copy of the new database and tried splitting it out into FE and BE again thinking maybe it would reconfigure something and resolve the problem
- I've compacted and repaired
- I've decompiled my vba code
something sneaky is still linking my new database with all local tables to the old back end database and I haven't been able to figure it out. :banghead:
Any thoughts on what I might have missed?
Thanks!
So up until this morning I was thinking that I had an out dated front end, an outdated back end, and the new test database which I had been working on that contained all of my current tables, queries, forms, reports and vba in one application. Upon archiving my outdated back end and front end databases I discovered that my new test database (which i was about to deploy for live use) would no longer open. When I attempted to open it, it acted as if I'd opened access without specifying a database. So I restored the back end to it's previous location and I was again able to open the new database.
- I've checked and double checked the linked table manager, it doesn't show any linked tables to my out dated backend database.
- I've made a copy of the new database and tried splitting it out into FE and BE again thinking maybe it would reconfigure something and resolve the problem
- I've compacted and repaired
- I've decompiled my vba code
something sneaky is still linking my new database with all local tables to the old back end database and I haven't been able to figure it out. :banghead:
Any thoughts on what I might have missed?
Thanks!