how to change frontend and backend in access

It would likely be part of the form that likely handles the authentication.

I.e. Part of your prior front end is what dictates where the data is.

Right, I understand that, but how to I get the front end to look at the correct location?

Just move the backend database to the same place as the front end, then use the Linked table manager to re-point the table links to the new location.

Jim.      

and FYI, it is better to leave it as a front end / back end setup, even if running the app on a single station.

Jim.

Having the two split complicates, adds overhead and requires bavkup management to remember they are related...

I did like you said, Jim, but I guess I had messed things up earlier because now everything related to invoicing is messed up.  I had tried to use the import method.  Somehow it changed my invoice name in the queries and so I am having to re-do the queries.
And, yes I would really like to have it all as one file.  

<<Having the two split complicates, adds overhead and requires bavkup management to remember they are related... >>

You wont find any Access developer that suggests doing this.  In fact even Microsoft suggests a split design right from the get go, even if you only expect to use it with a single user.  

<< I had tried to use the import method.   >>

 So the front end now has the tables in it.   I would suggest you take restore a copy from back up of both and start over since we are not sure where things stand.

 Once you have the clean copies, just place the backend on the station, then in the front end use the linked table manager to point to the new location.

<<And, yes I would really like to have it all as one file.>>

 This is generally a bad idea, unless the needs are very simple, and you fully expect this to be a single user app for the rest of it's life.    Since it's already split, there is no reason to go backwards.

Jim.



 

are you sure you imported the tables and not linked them....if you imported them you should be able to see the normal icon of the table (on each of them)...if not a small arrow indicates they are linked.

Okay I did as you said, Jim and everything is working good except for my checking account.  I had a table called "checkbookT" and for some reason it did not copy over which doesn't make any sense to me.  Since I still have the copy on the old drive I can open it up and see the table there.  Can you guide me to get it into the existing linked file?

I did get this issue resolved.  I also got my checkbook table back but had to go to a backup file as it had somehow got deleted.  I need to go through some more training and practice at this  To explain what all I did and should have done would be difficult as I kept getting disturbed correcting mistakes that I had made earlier.  But you was a great help.  Thank you.  I have another issue I want to resolve, maybe this weekend if I get time.  

Glad to hear you got it figured out.

Jim.