Search results

Do you mean I should change this datatype change in ms access before migrating to sql ? and this is just sample error there are more then 100 errors which appears while upsizing functionality

Hello I have ms access db which has complex relationship between tables, and there are above 100 tables in the database, the relation between tables are very much complex ( I mean in terms of referential integrity ). I would like to migrate ms access tables to sql server with referential...

Actually it does, but fails at lots of instance which shows by end of upsize report in ms access, there are lots of foreign key validation it fails because of size issues and all which works perfectly in ms access. any idea?

The uprising from access 2010 to SQL seems working (can see foreign keys and all in SQL )but I don't see relationship diagram when link back to access front end db.

Thanks does this also for foreign key as well ? or any other constrain as well ?

I dont believe so.

You mean if I imported 120 tables and each of them have referential integrity then I need to recreate them manually post import to sql ?

I have used SQL import export tool to upsize which has resulted to lost of referential integrity. Is there anyway I can have them them retain while using SQL export import tool ? I used identity enabled while doing this process I am using enterprise SQL server 2014.

Hello I have upsize backend access db to sql server, now and then again linked back the tables as connection string to the front end access db everything works ok and tables are now being linked very well. Now question is that when I had access db as backend and had them linked in access db...

Thanks this has worked, but I had to create primary keys manually after import. is there anyway we can import primary keys as well while import.

Hello I am upsizing ms access db ( access 2003 ) with sql server "version Microsoft SQL Server 2014 (SP2-GDR) (KB4019093) - 12.0.5207.0 (Intel X86) Jul 3 2017 02:37:05 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition on Windows NT 6.3 <X64> (Build 17134: ) (WOW64) "...

Thanks Pat here is the answer : You didn't answer the questions about how the app was structured. Was it originally linked to Jet/ACE tables? Are you using VBA or UDF functions in the queries that are slow? Are you joining heterogeneous tables (ie joining a SQL Server table to a Jet/ACE or...

I got to know what are pass through query now, it directly runs the query on sql server instead of access, will this eliminate use of linked ODBC table ? I know I can directly refer sql table here in pass throgh query ? Will it help me in imporving performance if I use pass through query ?

Thanks Pat, In fact I am using access query for the bound forms, in turns query uses linked table [ which is odbc linked table ]. Can you please explain me bit litte here on your below text: Did you do any optimization as part of the conversion such as eliminating any VBA and UDF queries from...

How to configure this connection string ? is this used in coding or it can be linked in same way as we do click on ODBC linking of table ( i mean configuration wise )

Ok, I have linked ODBC table [sql] in the access db and those tables are being referenced in queries and few of this tables and queries are bound to forms and report that makes database lots of slower. Comming back to your solution of connection string, can connectionstring would help me to...

Thats true but the linked ODBC table are used in query for reference: I know connection strings to used SQL mostly in unbound forms. Please advise. Thanks

Hello I have a database which has been linked odbc table in the database and database takes lots of time to open and view report etc. What would be best approach in this, does linking odbc table from sql server makes it uneasy and hampers performance ? what alter solution would be done in this...

You mean to say that I need to create function B and have there application.quite and shall I call function B after function A in autoexec ?

Hello I am running some function from autoexec macro using run code command and specify function name of vba, now this runs on scheduled activity I would like to close the database when program finishes with the activity. I tried in vba, application.quit but it does not work and gives me error...