Unhide tables in back end....(Access 2010)

I am trying to unhide my tables (in my Access 2010 database back end).

In the Navigation Options, when I click “Show Hidden Objects” I do see my hidden tables in a light grey, but they are still "hidden" in essence (when I look at Table Property it is checked....but will not let me uncheck".

Note: the table names of the hidden tables are greyed out in the navigation pane.

Any suggestions?

Thanks
Sarah


Post your answer or comment

comments powered by Disqus
Hello,

I was wondering, whats best way to compact splitted database back-end from front-end. This thing just came to my mind one day, cause my database keeps growing and growing, all tho it's just bout 2mb but this could be good feature later on, when it's bout 200mb or something.

I was thinking, that should I compact before user link tables to front-end or when user quits database, all tho then tables need unlink etc. etc. tricks before I can compact it.

Ok, when user start's this application, there's a popup form where user can select either if he's going to link tables to back-end, skip linking tables and start using application or simply just quit using application. If user decide to skip linking tables, then front-end uses last known path to linked tables in back-end.

Now I ask your opinion,

1. should I add another button to that form, so user could compact back-end database manually, before he link any tables and start using it.

2. should I do it automatically, when user start using application and there would be message if database was succesfully compacted or not.

What you think guys, what should I do?

All replies are welcome and approciated.

Also if someone has any example codes etc. what would be useful, I would be very grateful, cause I'm a bit newbie with coding and things.

I've got myself into a bit of a pickle insofaras a good while back I created an important updatable data table in the Front End of a split database.

Thus, whenever I issue a Front End update the data table gets overwritten with a blank table and the data needs recovery via a backup to that data table. That 'workaround' works OK but I'd dearly love to be able to issue the next Front End update with a permanent fix to the problem by (in sequence):-Copying the Table to the Back End (BE) file (structure and data) Deleting the table from the Front End Linking the Back End file to the Front End Thus, all existing queries, forms etc in the FE will behave as normal! Any ideas on some VB code that could do this on a 'once-and-once-only' basis?

Oh, almost forgot! The databases are issued and run in Access Runtime so the end user doesn't have common access to the BE file.

Hi,

Computer configuration :
- Windows 7 pro
- Office 2010
- 32 bits
- Back SQL Express
- Front Access .accdb

We upgraded from Office 2007 to Office 2010. Everybody is fine except one.
On this exception, I can open the software (.accde), my login form appear, then I write my username and password and when I click on the button "Login" I have an error message : Error in loading .dll on the ODBC connection line. I can also have this error message when I try to link my external tables to the front (Access).
Even if the message appear with a .accdb version I can access to the tables,data, forms queries...

What I did :

- Install all the Windows updates
- Re-create an .accde version
- Compare the references with an other computer
- Re-create the ODBC connection

The error is still there...

Do you have a suggestion ?

Thank you very much !

Hello colleagues,

I'm struggling with Combo Box and Not In List event. I want to be able to "add new record of First Name and Last Name if it is not in the list.
Here is the picture of how my form looks:

I have two tables: "Patients" and "Visit" - these are related as one to many(one patient can have many visit dates)
I also have Two forms - "Main" and "Patient_ex" .

So far my code for the Not In List event is:

	Code:
	Private Sub Combo19_NotInList(NewData As String, Response As Integer)
      
Dim Db As DAO.Database
Dim Rs As DAO.Recordset
Dim Msg As String
Dim NewID As String

On Error GoTo Err_combo19_NotInList

    ' Exit this subroutine if the combo box was cleared.
    If NewData = "" Then Exit Sub

    ' Confirm that the user wants to add the new customer.
    Msg = "'" & NewData & "' is not in the list." & vbCr & vbCr
    Msg = Msg & "Do you want to add it?"
    If MsgBox(Msg, vbQuestion + vbYesNo) = vbNo Then
        ' If the user chose not to add a customer, set the Response
        ' argument to suppress an error message and undo changes.
        Response = acDataErrContinue
        ' Display a customized message.
        MsgBox "Please try again."
    Else
        ' If the user chose to add a new customer, open a recordset
        ' using the table.
        Set Db = CurrentDb
        Set Rs = Db.OpenRecordset("Patients", dbOpenDynaset)
        ' Create a new record.
        Rs.AddNew
        ' Save the record.
        Rs.Update

        ' Set Response argument to indicate that new data is being added.
        Response = acDataErrAdded

    End If

Exit_combo19_NotInList:
       Exit Sub
Err_combo19_NotInList:
       ' An unexpected error occurred, display the normal error message.
       MsgBox Err.Description
       ' Set the Response argument to suppress an error message and undo
       ' changes.
       Response = acDataErrContinue


End Sub

As you can see in the picture, the code half works.
It doesn't save the new record with values Last Name and First Name.

Moreover I do not want to open a new form in order to add the new record details, but instead I would like to be able to add the new record details in the same form as the combo box(as you see in the picture).

my goal is:
1. When I enter new Name, Access detects that it is not in the list (Quite working)
2. If the name is NOT in the list, then the Values I entered (Last and first name) goes to the Text Field in the Patient_ex form so that I would no need to enter them again. Then I could update the new entered record and save it.(saving buttons works).

Guys, please, help me! I really struggling with VB...

Also, can I achieve same thing using only macros? (Access 2010)

Thank you!

I have a split Access 2003 database with all tables in the back end. Being a relative newcomer to vb I want to search each back end table for a particular value in a field and then list all tables in which the value is contained. (It is actually a "Where Used" search for a part in various parts list.)

The help I need is advice on the best way to connect to the back end, there seems to be a number of options such as ADO or DAO. Can someone point me in the right direction, preferably with reference to a detailed tutorial on the subject.

Thanks.

Hi,
I know this may not be appropriate place to post , Access problem but if anyone can help me with this issue, it would be a great help.
I have crated a linked access database from excel. Bunch of kid's enter data in excel (Front end), access table (as back end ) gets updated. The problem is , when They (kid's) enter some special character's (some mathematical symbol) in excel , it does not gets updated in access. It is represented as letter U or Un. How can be this problem fixed. I am using office 2007.
Thanks
athens

hello everyone,
i have developed an application in access 2010 . and split into front and back end .
now i want to add more tables in back end and i need to define lookup list in table definition from the query presently in front end . when i get into lookup list and query builder doesnt show front end content ... how to solve this problem ???? thanks

Hello All,

Is it possible to develop an application with six front ends and one back end and data volume of 40,000 records in a table using Ms-Access.

Please give your comments..

DavidCdp1..

I have a Front End Database and a Back End Database.

Certain tables in the BE are linked to the FE.

Once or twice a day I need to run Make Table Queries in the FE, but I am unable to do so if someone else has the BE open.

Best solution would be greatly appreciated

Many thanks

John

Hi.

I'm about to move to a back end / front end system, from a single database file. Before I do so, I want to make sure I have all bases covered so to speak.

My back end file will reside on a server. I am aware that path names are sometimes changed by network administrators without warning.

From tests, I notice that, if the path to the back end can't be found, one cannot open the front end database file at all (Access 2003).

My question is: if my back end file gets moved, or the path changed, how can I get into my front end file to update the linked tables.

Many thanks in advance.

Mat.

I have a database that I built as one large database, then used a method I found on here to creat 2 brand new databases and copy the tables from the original to one and use it for a back end and then copy everything else to another file to use as the front end. I did this and it worked great, except that now the information being input into the forms on the front end is not being recorded into the back end. I tried relinking the tables and it still was not working. Is there a secret step I missed or something I need to fix in order to make this work properly? The way I made the front end dependent on the back end was by linking the table from the back end to the front end. I checked the object dependencies and it shows those as being correct. Any suggestions or comments would be greatly appreciated!!! I am truly only a novice when it comes to Access and just in the past 6 months or so have been using it regularly.

Thanks in advance.

Hi all!

I have a table with multiple records (Complete Parts List Table). Whenever a user purchases, sells, or manually removes inventory, these records are updated in this table. Problem: There is no paper trail for the changes to these records. Is there any way to run a command so whenever one of these records is changed in the back-end, a report can be created to document the change in the data? It sounds easy in theory, but I cannot figure out how to get this to happen!

Any help is appreciated!

Thank you!

Hi,

At what point is a back end table updated with a new record created on a form in your front end?

I need to run a report of data i have just entered into a form and it returns black as the record doesn't yet exist in the table... is there a docmd to create the record?

thanks for any help.

Rob

I split my database into a Front End and a Back End. However now I added another table on the backend. How do I get access to that table on the front end?

Hello everyone,
Hope someone can help.

I developed a front end /back end Access 2000 application (using Access 2003) some time ago for a friend that runs a small local business.

On my desktop I have Access 2003 installed and on my laptop I have Access 2007 installed. Both machines have Windows 7.

My problem is that my friend's PC has a fault and he has replaced it with a new Windows 7 PC and Office 2010.

I don't have Office 2010.
He wants the Access application to run on his new PC (with no extra features).

What's the best way to deal with this?
I can't borrow his PC as it is heavily used.
I had thought about converting the application to Access 2007 in the hope that Access 2010 will run it- Would this work?

Any ideas very gratefully received!

Thanks

I did a search in here as well as Google to figure out why when I relinked the front end to the back end after adding 2 tables to the back end that the tables did NOT show up on the front end. Only the original tables that I began with.

From what I have read there are different ways to do it. One suggestion on here was to create the table on the front end and export it to the back end. I guess I will have to do this going forward.

But my question is, after searching pages upon pages with no luck, since I already have the tables in the back end how do I tell the front end to find them and link them?

Thank you!

I have a split database (Access 97).

I've included the menu item that compacts and repairs a database in a custom menu that is always available to the user. Will that compact both the front AND back end of the split db?

I am curious, does bloating occur in both ends or just one? If so, which end does the bloating occur in?

I have a form using a linked table named TotalInvestments. This name appears in the table list on the Front End. But when I open the Back End there is no such table name. It is named TotalInvestmentsREV3. The form shows the data source as TotalInvestments bur when I add a record it appears in TotalInvestmentsREV3. I renamed TotalInvestmentREV3 as TotalInvestments in the back end but the old name persists in the Back End but shows as the new name in the Front End as a linked table. Any suggestions? I'm baffled.

Testing on a split database, SQL back end, Access 2007 front. I haven't priviledges on SQL so I had that group add a new field to a table. They did it, and I refreshed the tables - so I can "see" the new field in Access land.

When I try and add the new field to the form in Design Mode, the form prompts for whether or not I want to save the changes (I do!) but if I select Yes nothing happens...at all. The form won't close, task manager doesn't show anything not responding, it just hangs. Only way to the get out is to cancel the update in order to get the form to close.

Ideas?

Lisa

Hi All,

I have created a chart in a MS Access 2010 Report to show an account balance over time.

NOTE: As I'm new to this forum I'm prevented from including images in my post and without images you just cannot see the problem Accordingly I've included a reference to the images, all the references need is for http: to be put in front of them and the whole lot copied to a web browser to be able to see the images which are located on ImageShack.

The report looks like this (put http: in front of the following to create a URL link):

//imageshack.us/a/img208/6885/20121021balancecharterr.jpg

However if you look closely you'll note that the Report From/To dates do not agree with those shown on the chart, in particular the chart does not extend to the To date.

Going to Design mode the screen looks like this (put http: in front of the following to create a URL link):

//imageshack.us/a/img99/6885/20121021balancecharterr.jpg

This chart looks the same as the report - the error persists.

Clicking on the Chart produces the following (put http: in front of the following to create a URL link):

//imageshack.us/a/img42/6885/20121021balancecharterr.jpg

You will note that the chart shown the full date range from the the Period From / To dates and the data table includes data for the whole period.

Any ideas on why the X-Axis truncates and how to overcome the problem?

Cheers

BygAuldByrd

Can anyone outline the code I would use to create new tables in a PostgresQL database using MS Access 2003. Thank you.

Hi,

I've been having trouble all this day with this if anyone can help me.

The following code works for a table in a oracle database making a select from Access modules.

But for a database that i have like
server = orion.sys

and the table name is deli_up.contacts_cty_zip
the "deli_up" is the schema or the instance of the database and "contacts_cty_zip" is the table name

so here is my code:

Dim ws As Workspace
Dim db As Database
Dim rsSnap As Recordset
Dim LConnect As String

'Use{Microsoft ODBC For Oracle} ODBC Connection
LConnect = "ODBC;DSN=orion.sys;UID=name;PWD=pass;SERVER=orion .sys"

'Point to the current workspace
Set ws = DBEngine.Workspaces(0)

'Connect to Oracle
Set db = ws.OpenDatabase("", False, True, LConnect)

=== Here is my error ====
' Open snapshot-type recordset
Set rsSnap = db.OpenRecordset("SELECT * FROM contacts_cty_zip", dbOpenSnapshot)

the error says
Connecting to orion.sys Failed 3078 - The Microsoft jet engine cannot find the input table or query 'contacts_cty_zip'. Make sure it exists and that its name is spelled correctly.

I'm sure is the instance "deli_up" but i don't know how to use it in here.

can anyone helpme with this.

Thanks
Hermann

Hello,

I've spent hours trying to find a solution without any luck!

*** Situation ***
I have a number of ODBC linked tables in an MS Access 2003 application. I want to be able to switch between source databases; i.e. between production and development databases, easily.

*** What works ***
Open Linked Table Manager;
Select the numerous linked tables;
Select Always Prompt For a New Location;
Click OK;
Provide the new DSN....

This works fine, but is rather manual, and does not provide for hands-free deployment. I'd like to be able to do this from code. All I need to do is change the Connect property on the tabledef, how ever, this property is read-only on existing tables! **** Microsoft!

The only method that turned up through hours of research is to drop the old table, then to connect the new table. This of course would be a nightmare, because then I would have to rebuild all of the security settings on the table, all the captions on each field, and all of the combo box lookups on some of the fields! Not gonna happen!

Anyone who can solve this riddle is a true guru!

Thank you,

Daniel Odulo
http://www.Odulo.com/Consulting/

I have 10 accounts using the same access program, except they have different data in their tables. I have made several changes to the queries, forms and reports in one of the access programs. I would like to split the databases and reconnect the front end with the changes to the tables in the 10 access programs currently in use. All the programs were copies of the same program originally so the tables are the same, except for the data of course. I have tried to split the new program and an old program and connect the front end of the new program to the data in the old program and it did not work...any ideas?:


Not finding an answer? Try a Google search.