Kati (1 Viewer)

[KAsad]

Hi
I am new in MS ACCESS coding. I have an application works based on ACCESS database. I have 2 copy of the application, one localy in my PC and one in anoher server. If I log in to my local PC, then log out and log in to server copy, it still looks for my local database. I can not understand why?? Does Access keeps any track of last log in in anywhere in my PC?

Thank you

 

[jdraw]

Yes.
If you would like to tell us more about your application and issues you may have, I'm sure readers will help.

Why 2 copies of the database? Is this a multi user database?

 

[KAsad]

I have 2 copy because one should be on live server for clients to use it and one I have in my local PC as I am continuously changing the forms, process....

So I develop forms in my PC and then transfer it to the live one. Hope it makes sense

Thank you

 

[jdraw]

Tell us more about the live database structure on the server, and client(s).
Are you having issues with the database? Is it a split Frontend/backend?

 

[KAsad]

It is a very simple database with a few tabless. I have a mdb which contains all tables lets name it as {kati Files.mdb}, then I have another mdb named {kati.mdb} which has link to the tables in {kati Files.mdb} and it also has all forms, query and processes.

The files on server are {kati Files.mdb} and {kati.mdb} and the copy in my pc are {Local Kati Files.mdb} amd {Local Kati.mdb}

In this way, I can see what database I am connected.

 

[KAsad]

Anybody can help me please?:banghead:

 

[JHB]

I depend of where you want to se which database you are working at.
The easiest way is to give it different names in the Application Title bar.

In Access 2000. Menu: Function -> Start, in the Application Title box, type the title that you want to be displayed.

In Access 2007 Click the Microsoft Office Button, and then click Access Options-> Current Database -> Application Options, in the Application Title box, type the title that you want to be displayed.

 

[jdraw]

What is the database application about? What is it used for?
It seems you have a "production database" and a "testing/development database".
Is your production database, that you say is shared by several users, split into a Front End/Back End?

You could have a third database: basically a form with 2 buttons

o----Development
o----Production

Click a button and "relink" the appropriate tables as first step. Create a Popup form to tell you WHICH DATABASE I AM LINKED TO.

My bigger concern is how you are handling your multi-user Production database.

 

[KAsad]

Thank you for your suggestions.

There was a peice of code hiding in a function, which was reconnection to wrong DB.

I have cleared that line and it works fine now.

Thank you