Search results

Hi Guys Is there any way to find out which queries are using my specific table in MS Access? Instead of checking each and every query , is there any other way to know which queries are using that specific table (e.g tblAudit)? Many Thanks

Yes i deleted all the old links in the Access frontend and tried ODBC connection from External data -> ODBC database but the Link tables windows displays all the 'system tables' or 'Information_schema' tables of sql server . Not sure why its not showing all the tables that I have migrated in the...

Hi Guys I am migrating tables from Access database to sql server using upsizing wizard in Access. I have done the following steps: 1. exported all the tables from MS Access Backend file to sql server. When this is done then it automatically adds suffix 'Local' to all the existing tables names...

Arnelgp, do you mean creating user groups ?

I will be using upsizing wizard in ms access to connect to sql server. So when do we pass the username and password in the connection string without using VBA for linking tables?

when do we pass the username and password in the connection string??? AT what stage?

The one problem my boss was talking about is anyone who know the IP address and ODBC connection string to that server can access that backend. how can we avoid that to happen?

There are number of steps that we need to follow in order to link access frontend to sql server backend. In one of the steps you need to choose authentication method for the question “How should sql server verify the authenticity of the login id”. By default 1st option is selected. Will it make...

how do we password protect sql server database and how can frontend be linked using password? thanks

I am talking about accessing data from sql server . how to secure data in sql server so that it is accessible by only that frontend which has rights to do that.

Hi Guys How can we ensure data security in sql server? If we have ms access frontend and sql server as a backend then there are chances that any access frontend can access to the data stored in sql server . Is there anything like locking tables / password protection or something similar that...

Thanks , I have never used Pass-through queries. Do we need to create those queries in MS Access so basically those queries will be created in MS access but will be processed on server side (sql server). am I right?

No I want all the queries on server side for optimum performance..

Hi Guys We are planning to migrate tables and queries from access to sql server and use ms access as a frontend for the applications only. I have the option to migrate tables using upsizing wizard or sql server migration assistant. But as there is no migration tool available to migrate queries...

Hi Guys I am using a global variable called 'GCampId' within code that holds 'Campaign ID' value. Now I want to use this value to filter my access query. I have created a query in design view and when I try to se the critaria of 'CampaignID' field to GCampID and run the query then it gives me...

Ridders, I have already used Form timer for marquee text . Can I use another form timer to make the buttons visible in turn? How would I distinguish two form timers then ?

whats Shockwave Flash? can you please help me with this?

Thanks for this. I am getting an error on FileExists statement saying sub or function not defined .

Guys I want to do it using vba ? Any help will be much appreciated. Thanks

Yes I exactly want to do this for the 5 buttons under Admin. Can you please help me with the code. So basically when I click on Admin button then the 5 options under it become visible one after another and grow slowly.