Connecting Altered Front End to Existing Back End

[Aussie60]

Hi

Can someone give me step by step instructions on how to connect an existing front end that has been altered to an existing back end that contains existing data.

This is what I have been doing

Open front end and it says can't connect to database. Locate existing database and connect

Located existing back end database and double clicked on, message comes up and says connected to database.

I then go to front end and click Get External Data and click on Link Tables select all and import. Says all tables linked.

Yet when I go into the front end there is no data in the combo boxes although it shows data in the sub form

This should be simple

Where am I going wrong

 

[mdlueck]

What exactly changed since last time the application was working?

 

[Aussie60]

Some alterations were only done to the front end forms

 

[mdlueck]

Some alterations were only done to the front end forms

Alterations like changing the DB schema? Or were no changes made to the DB schema?

Do you know how the application authenticates with the BE DB?

It sounds perhaps like the application uses Linked Tables. Did you try opening one of the linked tables?

 

[Aussie60]

Yes I tried opening the tables and they contain data. They also have the arrow next to them signifying that they have been kinked

 

[mdlueck]

All right, sounds like something went wrong in your update to the FE DB, perhaps nothing really wrong with the connection to the BE DB.

Yet when I go into the front end there is no data in the combo boxes although it shows data in the sub form

Go in form edit more, inspect said combo box(es) and see where the data should be coming from. If it is directly connected to a table, if it is populated by a query, etc...

If direct to a table, try opening the table to verify it has records in it.

If a query, then try running the query manually outside of the form / control.

 

[Aussie60]

When I tried to run the query it came up with Disc or Network error

There is data in tables but there is also a double up of the tables Like tblSupplier and then another table straight underneath tblSupplier1 The tblSupplier1 has the data in it. If I try and open tblSupplier I get the same error message as above Disc or Network Error

I have attached a screen shot of the tables

 

[mdlueck]

When I tried to run the query it came up with Disc or Network error

All right, edit that QueryDef object. See if there is some connection string within the query. Or is it referencing the LinkedTable object which itself is able to be opened?

One other thought. Make a BACKUP copy of your FE DB and run through the Decomplie process documented here:

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk...to_Decompile_/_Compact_/_Compile_an_Access_DB