[AccessD] Access droping linked tables from Database.

[Steve Turner]

Steve A. Turner                  
Mark,
 Sorry haven't posted in awhile. We use Access 2010.
Steve
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Saturday, April 18, 2015 10:53 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access droping linked tables from Database.

As should be customary....Always, ALWAYS mention the release of Access for which there is a problem.
Access is so....release sensitive. AC2013: bug-city.

>
> Help,
> I have an Access Database for some reports that are standard. In 
> attempting to add a new report I needed to link a couple of tables not 
> in the database. When I create a new link with ODBC to link in a table 
> from SQL Express I have a table dbo_Employee in the database that when 
> I hover on the table is linking to another table than the name. I've 
> deleted it and linked to the correct table and even made a copy in the 
> database. When I close the database and reopen it the new tables are 
> gone and the old dbo_Employee is back. This table only had 4 columns 
> out of the entire Employee file for some reason. This is not happening 
> in any of our other databases with linked tables to the same data. I 
> will say that the report and qry that I imported to it is still in the 
> database.
>


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com