Newly Migrated backend DB

Question

Post reply

Newly Migrated backend DB

todd.ayers

SSCommitted

Points: 1837
More actions
January 15, 2014 at 5:29 am

#303234

I just migrated a small back end access db to sql server. How can I tell if the Front end is accessing the backend from SQl or still accessing the same back end it was?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

check connections in the sql server.

Rename the backend Access db 😀

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Update or insert a row into a table and check via the front end whether or not you can see the change.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

todd.ayers SSCommitted Points: 1837 More actions · Answer 3

All my Backend tables were renamed with SSMA$...... and then the same table name is showing with a world with an arrow? How do I link them back to the front end of my database? Because now when I try to open my front end it says records source ' ' specified on this form or report does not exist?

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

you'll need to use linked table manager to relink the tables

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

todd.ayers SSCommitted Points: 1837 More actions · Answer 5

And I did that... I went into the front end DB clicked on the linked table manager and chose the Backend again. When I did that it said it could not link the tables because the table names were not recognized.... Since the names changed when they were migrated I get a message saying basically the database engine cannot find the input table or query......

On a side note... should I migrate the front end and back end?

pietlinden SSC Guru Points: 63503 More actions · Answer 6

Inside Access, right-click on one of your linked tables, select Linked Table Manager from the menu, and it will show you where the tables are pointing to.