How do I change the back-end database

[willkr]

I've got my app to a point that I want someone else to do some testing. When I copy the app and the back-end to a flash drive, the app on the flash drive is still linked to the back-end on my hard drive. How so I change the linkage to be on the flash drive?

[CJ_London]

Use the linked table manager to relinki

[willkr]

When I go to the linked table manager it only shows the back-end that is on my hard drive.

I've tried several things but all it did was duplicate all my tables. Now I have 3 versions of each when I look at them from the flash drive.

I really have no idea what I'm doing here.

[CJ_London]

Bing is your friend
https://support.microsoft.com/en-us/...e-4caec2262797

[willkr]

CJ,
I followed all the instructions in the Bing link you provided. Now I have a database with ALL file names have a 1 appended to them and nothing works!

[willkr]

OK, I figured it out. I needed to delete the existing link before creating the new link.

Thanks for putting up with my stupidity!

[moke123]

try JStreet relinker. https://jstreettech.com/developer-downloads/

Theres a READ ME table in the database which gives good instructions on how to use it.

[willkr]

Moke123,

I just installed the JStreet relinker. Wow! Thanks for the lead.

BTW, is there a way to display the currently linked backend DB?

willkr

[willkr]

Never mind on the be location. I found out how to do it.

[moke123]

Private Function fGetBackEndName() As String

'replace "Your Table Name Here" with a table name from your back end (ie. "tblMain")


  fGetBackEndName = Mid(CurrentDb().TableDefs("Your Table Name Here").Connect, InStrRev(CurrentDb().TableDefs("Your Table Name Here").Connect, "") + 1)


End Function

[Bulzie]

You should also be able to mouse hover over the table and it will show you the connection information.